| ORACLE 10 g |
| DBMS |
- Concepts of DBMS
- Introduction
- Importance and Need
- Database Models and Normalization
- Models
- Hierarchial
- Relational
- Object
- Normalization Techniques
|
| Introduction to RDBMS |
- Concepts of RDBMS
- Introdution
- Comparision with DBMS
- COOD Rules
- Normalization Revisited
- Concepts of ORDBMS & OODBMS
- Introduction to ORDBMS
- Introduction to OODBMS
- Comparision and analysis
|
| Structured Query Language(SQL) |
- Introduction to SQL
- Predefined Data Types
- Introduction to database objects
- Table,View
|
| Commands in SQL |
- Data Defination Language(DDL)
- Data Manipulation Language(DML)
- Data Control Language(DCL)
- Transaction Control Language(TCL)
- Database Security and Privileges(DCL)
|
| Working with DDL,DML,TCL Commands |
- Operators
- Conditional,Logical,Comparison,SET
- Functions
- Date,Number,Character,String,Group,Group by,Having clause
- Transformation Functions
- DECODE,TRANSLATE
- NVL,NVL2(9i)
- Aggregate Functions
|
| Integrity Constraints |
- Different Types of Integrity Constraint
- Use of Integrity Constraint in table
|
| Joins |
- Usage of Joins
- Different Types of Joins
- Equi Join
- Cartesian join
- Self Join
- Outer join
|
| Sub Queries |
- Need of Sub Queries
- Nested Sub queries
- Co-related Sub Quries
- Flash Back Queries (9i)
|
| View |
- Importance of views
- Creating,Manipulating Views
- Materialized views(9i)
|
| Working with database objects |
- Sequences and synonyms
- Index,Cluster,Creating cluster table
|
| Using External Tables(9i) |
- System Privileges
- Table Privileges
|
| Locks and SQL Plus editor commands |
| 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
|
| Advanced PL/SQL |
- Introduction to Triggers
- Types of Triggers : - Row level,Statement Level
- Before and After ,Instead of Triggers
- Procedures,Functions in PL/SQL
- Argument modes
- User Defined Packages
- Dropping triggers,Procedures,Functions
- Reference Cursors
- Usage of ref cursores in Procedures,Functions,Packages.
|
  |
|
|
|
