OR-415A: Oracle 10g: SQL & PL/SQL Programming

OR-415A: Oracle 11g: SQL & PL/SQL Programming

Dates/Locations:

OR-415A: Oracle 10g: SQL & PL/SQL Programming | 02/27/2012 - 03/01/2012 | Austin

Duration: 4 Days

Course Overview:

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 the built-in packages that come with Oracle, the creation of triggers & stored procedure features.

Course Objectives:

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

L/SQL Syntax & Logic

Stored Procedures & Functions

Exception Handling

Records & Collections

Cursors

Using Packages

Creating Packages

Working with LOBs

Maintaining PL/SQL Code