To enroll for training, call 1-510-790-3300 or email training@samepageinfosol.com

PL/SQL Course Outline

• Introduction to SQL
• Introduction to DDL’s : Creating/Droping/Renaming/Altering tables
• Introduction to DML’s: Inserting/Deleting/Updating tables
• Simple Queries
• Introduction to joins (Equi, Self, Outer, Inner joins)
• Introduction to subqueries and correlated queries
• Group By, having clauses and group functions overview
• Introduction to PL/SQL
• Cursors
• Exception handling
• Triggers
• Stored Procedures
• Packages
• Batch processing overview
• Performance tuning