DBMS
PL/SQL
- Concepts of DBMS
- Introduction
- Importance and Need
- Database Models and Normalization
- Relational
- Object
- Normalization Techniques
- Concepts of RDBMS
- Introduction
- Comparision with DBMS
- COOD Rules
- Normalization Revisited
- Concepts of ORDBMS & OODBMS
- Introduction to ORDBMS
- Introduction to OODBMS
- Comparision and analysis
- Introduction to SQL
- Predefined Data Types
- Introduction to database objects
- Table,View
- Data Defination Language(DDL)
- Data Manipulation Language(DML)
- Data Control Language(DCL)
- Transaction Control Language(TCL)
- Database Security and Privileges(DCL)
- Operators
- Conditional,Logical,Comparison,SET
- Functions
- Date,Number,Character,String,Group,Group by,Having clause
- Transformation Functions
- DECODE,TRANSLATE
- NVL,NVL2(9i)
- Aggregate Functions
- Different Types of Integrity Constraint
- Use of Integrity Constraint in table
- Usage of Joins
- Different Types of Joins
- Equi Join
- Cartesian join
- Self Join
- Outer join
- Need of Sub Queries
- Nested Sub queries
- Co-related Sub Quries
- Flash Back Queries (9i)
- Importance of views
- Creating,Manipulating Views
- Materialized views(9i)
- Sequences and synonyms
- Index,Cluster,Creating cluster table
- System Privileges
- Table Privileges
PL/SQL
- Introduction to PL/SQL
- Advantage of PL/SQL
- Data Types in PL/SQL
- Variables and Constants
- Referencing NON-PL/SQL Variable
- Using built in Functions
- Conditional and iterative Statements
- SQL in PL/SQL
- Composite Data Types
- Cursors
- Exceptions:-Predefined ,User Defined
- Records and PL/SQl table types
- Introduction to Triggers
- Types of Triggers : - Row level,Statement Level
- Before and After ,Instead of Triggers
- Procedures,Functions in PL/SQL
- User Defined Packages
- Dropping triggers,Procedures,Functions
