Course Duration in Hours
120
Course Category
Request Call Back
Course Details
Introduction to SQL constructs
Review of Basic SQL statements
Restricting row returns
Using SQL*Plus
Joining Oracle tables
Advanced SQL operators
Aggregation in SQL
SQL access methods
SQL Tuning
PL/SQL Section
1. Basics of PL/SQL
2. PL/SQL structures
3. Error checking exception handling
4. Boolean logic in PL/SQL
5. Cursors in PL/SQL
6. Iteration in PL/SQL
7. PL/SQL tables
8. Dynamic SQL in PL/SQL
9. Nested blocks in PL/SQL
10. Triggers in PL/SQL
11. Stored procedures, functions and packages
12. Bulking in PL/SQL
Upcoming Class
- June 15, 2025 7:55 am - September 3, 2025 7:55 am Add to Google Calendar Add to iCalendar
- July 15, 2025 7:55 am - October 3, 2025 7:55 am Add to Google Calendar Add to iCalendar
