Course Details

Comprehensive training regarding all the aspect of the subject shall be provided during the classes. We offer the following in our course module:

SQL

• Introduction to SQL
• Restricting and Sorting Data
• Single Row functions
• Conversion Functions
• Group functions
• Oracle Joins
• Sub queries
• Set operators
• More on DML statements and Data integrity
• More on DDL and Constraints
• Creating other Schema objects
• Controlling User Access
• Managing other Schema Objects
• Miscellaneous

PL/SQL

• Basics of PL/SQL
• PL/SQL structures
• Error checking ïƒ  exception handling
• Boolean logic in PL/SQL
• Cursors in PL/SQL
• Iteration in PL/SQL
• PL/SQL tables
• Triggers in PL/SQL
• Stored procedures, functions and packages
• Bulking in PL/SQL
• Left Over TOPICS
• Real Time Assignments