| |
|
|
|
|
| Online Training From India, B1, 3rd Floor, Eureka Court, Beside Image Hospitals, Ameerpet, Hyderabad. |
|
|
|
|
|
| Oracle 9i Online Training : |
Course Duration - 35hrs |
DBMS
- Concepts of DBMS
- Introduction
- Importance and Need
- Database Models and Normalization
- Relational
- Object
- ormalization 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
- User Defined Packages
- Dropping triggers,Procedures,Functions
|
|
|
|
| |
|
