ORACLE

DURATION:

• 45 DAYS

DESCRIPTION:

Introduction to SQL and PL/SQL is an intensive five day course that is designed to give the student maximum exposure to Oracle SQL and PL/SQL.  The student learns by doing, and this class has dozens of in-class exercises and the student will be guided from very simple SQL commands to increasingly complex PL/SQL coding techniques.

The topics start with the basics of SQL and progress into increasingly complex queries, including table joins, subqueries and creating Oracle views.  The PL/SQL section begins with simple concepts and the student gradually masters PL/SQL through increasingly challenging classroom exercises.

COURSE CONTENT:

• Introduction to DBMS
• Introduction to RDBMS
• SQL Commands
• Built in Functions
• Integrity Constraints
• Joins
• Sub queries
• Views
• Locks
• PL-SQL(Procedure Language –SQL)
• Advanced PL/SQL
• Procedures
• Functions
• Packages
• Exceptions
• Triggers