| Durations 1800(Mins) 30HRS | ||||||||
| 1 : Introduction Database | 60 (Min) | |||||||
| 1 | What is DBMS? | 10 | ||||||
| 2 | What is RDBMS? | 10 | ||||||
| 3 | Difference between DBMS and RDBMS | 10 | ||||||
| 4 | Need Of Database (Why Database is used?) | 10 | ||||||
| 5 | Why Oracle? and its Advantage | 10 | ||||||
| 6 | What is SQL? | 10 | ||||||
| 2 : Basics of Oracle SQL | 200(Min) | |||||||
| 1 | Understand the Basic Data Types | 30 | ||||||
| 2 | Create Tables and modifying the Oracle Tables and other objects | 50 | ||||||
| 3 | Understand DML Statements | 60 | ||||||
| 4 | Use SELECT Statements WHERE clause (Using Operators and Handle NULL values) | 60 | ||||||
| 3 : SQL Functions | 120(Min) | |||||||
| 1 | String Function | 50 | ||||||
| 2 | Number Function | 10 | ||||||
| 3 | Date Functions | 40 | ||||||
| 4 | General Functions | 20 | ||||||
| 4 : Transaction Control Language | 90(Min) | |||||||
| 1 | Understand the state of data after COMMIT and Rollback | 90 | ||||||
| 5 : Normalization and Constraints | 120 (Min) | |||||||
| 1 | All three normalization forms | 50 | ||||||
| 2 | Types of Constraints | 50 | ||||||
| 3 | Understand Query Processing | 20 | ||||||
| 6 : Joins | 100 (Mins) | |||||||
| 1 | Inner Joins | 20 | ||||||
| 2 | Outer Joins | 30 | ||||||
| 3 | Self Joins | 30 | ||||||
| 4 | Cross Joins | 20 | ||||||
| 7 : Use Aggregate Functions | 60(Min) | |||||||
| 1 | Group By clause | 40 | ||||||
| 2 | Having Clause | 20 | ||||||
| 8 : Sub-query | 90(Mins) | |||||||
| 1 | Sub-Query | 60 | ||||||
| 2 | Co-related sub-query | 30 | ||||||
| 9:- Other SQL Objects | 90(Mins) | |||||||
| 1 | Views | 20 | ||||||
| 2 | Synonims | 10 | ||||||
| 3 | Sequences | 10 | ||||||
| 4 | Index | 30 | ||||||
| 4 | DCL Commands | 20 | ||||||
| 10 :- Advanced SQL | 90(Min) | |||||||
| 1 | SQL Control Statements | 10 | ||||||
| 2 | SET Operators | 20 | ||||||
| 3 | Analytical Functions | 40 | ||||||
| 3 | Merge Statements | 20 | ||||||
| 11 :- Introduction to PL/SQL | 120(Min) | |||||||
| 1 | Basic Block | 15 | ||||||
| 2 | Anonymous Block | 15 | ||||||
| 3 | Nested Block | 20 | ||||||
| 4 | Loops | 30 | ||||||
| 5 | If-Else | 20 | ||||||
| 6 | Implicit Cursor | 10 | ||||||
| 7 | Explicit Cursor | 10 | ||||||
| 12 :- Procedures | 120(Mins) | |||||||
| 1 | Basic of Procedures, Creating Procedure and Calling Procedure | 40 | ||||||
| 2 | Various scenarios where Procedure can be used with Examples | 40 | ||||||
| 3 | Procedure Using Loops and Cursors | 40 | ||||||
| 13 :- Functions | 120(min) | |||||||
| 1 | What is function? | 30 | ||||||
| 2 | Function Creation | 10 | ||||||
| 3 | Function Parameters | 10 | ||||||
| 4 | Invoking Function | 10 | ||||||
| 5 | Various scenarios where function can be used with Examples | 40 | ||||||
| 6 | Difference Between Procedure and Function | 20 | ||||||
| 14 ;- Exceptions | 90(Min) | |||||||
| 1 | User defined Exceptions | 45 | ||||||
| 2 | System Defined Exceptions | 45 | ||||||
| 15 :- Packages | 90(Mins) | |||||||
| 1 | What is Package and Its Advantage | 10 | ||||||
| 2 | OOPS Concepts | 20 | ||||||
| 4 | Functional dependancy | 30 | ||||||
| 5 | Global Varaible | 10 | ||||||
| 6 | Overloading | 10 | ||||||
| 7 | Partial dependency | 10 | ||||||
| 16 :- Trigger | 120(Mins) | |||||||
| What is trigger? | 10 | |||||||
| Types of Trigger? | 20 | |||||||
| Bifference between them | 20 | |||||||
| Use of Trigger? | 20 | |||||||
| Trigger Creation | 30 | |||||||
| Execution of Difference types of trigger | 20 | |||||||
| 17 :- Rivision (Optional) | 120(Mins) | |||||||
| What is tunning and its advantegs? | 30 | |||||||
| Basic Guide Lines of Tunning | 20 | |||||||
| Dynamic SQL | 30 | |||||||
| Some New features of 11g | 40 | |||||||
