| Day | Chapter | Topic | Hours |
| 1 | DBMS Concepts | Introduction to DBMS Advantages |
1 |
| 2 | File system vs DBMS | 1 | |
| 4 | Data Models | 2 | |
| 6 7 |
DBMS Components | 2 | |
| 8 9 |
DBMS Architecture Client Server Technology |
2 | |
| 10 11 |
Oracle Basics | Introductin to Oracle Oracle Features |
2 |
| 12 | Oracle DataBase Architecture | 1 | |
| 13 | SQL | Types of SQL statements(DDL,DML,DCL) SQL Features SQL Data types |
1 |
| 14 | Oracle Table Operations | Oracle Demo tables Table Creation |
1 |
| 15 | Insert | 1 | |
| 16 | Select with with various operations | 1 | |
| 17 18 |
SQL pre defined functions | 2 | |
| 19 | Updating Table data | 1 | |
| 20 21 |
Deleting Table data Dropping table Truncating tables |
2 | |
| 22 | Rollback, commit, savepoint | 1 | |
| 23 24 |
Constraints | Domain Integrity Constraints Unique, Not Null, Primary Key, Check Referential Integrity Constrains Foreign Key Adding & Removing Constraints to existing table |
2 |
| 25 26 |
Sub Queries | Nested Sub Queries Correlated Sub Queries |
2 |
| 27 28 |
Table Joins | Equi join, outer join, Cartesian join, self join Set opeations Union, intersect, union all , minus |
2 |
| 29 | Group by operations | Select with group by Aggrigate functions using group by |
1 |
| 30 31 |
Views | View definition, Advantages Creating views various operations |
2 |
| 32 | Sequences | Creating , retrieving data , modifying, dropping sequences | 1 |
| 33 | Indexing | What is index, advantages Types of indexes Creating index Retrieving data using index Dropping sequence |
1 |
| 34 | Clustering | What is clustering, |
1 |
| 35 36 |
SQL Reports | Preparing SQL reports | 2 |
| 37 | PL/SQL | Introduction to PL/SQL PL/SQL features PL/SQL Block Structure |
1 |
| 38 39 40 |
Basic Programming with PL/SQL Control statements, loops |
3 | |
| 41 42 43 |
Cursors Definition,Advantages, Implementation,Explicit Cursor Attributes,Ref cursors |
3 | |
| 44 45 |
PL/SQL | Stored Procedures introduction Implementing Procedures for various operations on data base |
2 |
| 46 47 |
User Defined functions Implementing User Defined functions with various operations Parameter Modes(in,out,inout) |
2 | |
| 48 49 |
Packages importance, advantages Implementing packages |
2 | |
| 50 51 |
Data Base Triggers Definitions, Implementing triggers for various |
2 | |
| 52 | Other Tables | User_tables, User_views User_constraints User_procedures User_objects User_triggers User_indexes |
1 |
| 53 54 |
OOPS | Object Oriented Programming Creating Object types, Implementing data members & member functions in objects Static methods, self , ref, deref |
2 |
| 55 | Varying Arrays | Varying Arrays | 1 |
| 56 | Nested Tables | Nested Tables | 1 |
| 57 | User Creation | Creating users Granting & Revoking permissions on Data base Granting & Revoking permissions on Objects |
|
| 58 59 |
Table partitions | Various types of partitions Range, list, hash |
2 |