Whom ?

This course is for professionals who want to become hardcore PL/SQL developers and work in IT industry.

What ?

This course will cover basics of Oracle database Architecture, practical usage of  basic & advanced PL/SQL features in hard core PL/SQL development and performance tuning.

Course will cover below topics :-

1. Oracle Database Architecture 

 a. Physical structures of DB

 b. Logical structures of DB

2. Tables, Views, Synonyms & Clusters

3. Functions, Procedures & Packages

4. Cursor

 i. Implicit cursor

 ii. Explicit cursor

5. Trigger

 i. Database/Server level triggers

 ii. Schema level / DDL triggers

 iii. Object level / DML triggers

6. Indexes

 i. B-tree Indexes

 ii. Bitmap Indexes

 iii. Function based Indexes

7. Collections

 i. Associative Array / INDEX by TABLE

 ii. Nested Table

 iii. Varray

8. Performance tuning

 i. Execution plan

 ii. Query hints

 iii. Table Partitions

 iv. Bulk Collect & For All

9. PL/SQL Record

10. Integrity Constraints

Schedule :-

1. Sessions will be conducted on weekend only between 12-3 PM (Sat & Sun)

2. Each session would be of 2 hours

3. Total sessions conducted would be 8. (One session of two hours each weekend)