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
