In this class, students will learn how to create, retrieve & manipulate objects in Oracle 10g Structure Query Language (SQL).  Students will also be introduced to Oracle 10g database features & tools.  In addition, students will learn the functions of the PL/SQL programming language.  Students will write stored procedures, functions, packages & triggers & implement complex business rules in Oracle.  Students will learn programming, management & security issues of working with PL/SQL program units.  Programming topics will include he built-in packages that come with Oracle, the creation of triggers & stored procedure features.

Duration: 5 Days

Relational Database & SQL Overview
Using Oracle SQL *Plus
SQL Queries - the SELECT Statement
Scalar Functions
SQL Queries - Joins
Aggregate Functions & Advanced Techniques
Data Manipulation & Transactions
Data Definition & Control Statements
Other Database Objects
Triggers
PL/SQL Variables & Datatypes
PL/SQL Syntax & Logic
Stored Procedures & Functions
Exception Handling
Records & Collections
Cursors
Using Packages
Creating Packages
Working with LOBs
Maintaining PL/SQL Code

Basic knowledge of relational databases.