Oracle for Developers with PL/SQL

Course Number: 573-JK
Recommended Duration: 5 days

Intended Audience
Application developers who will design, code, and support systems using the Oracle Data Base and its various programming tools.

Course Overview
This course introduces developers to Oracle 10g, SQL, SQL*Plus, and PL/SQL. (Suitable for Oracle9i, or Oracle8i; (Oracle 7 version available)). There are eighteen machine exercises.

Objectives
Introduces participants to Oracle and its most commonly used tools. Numerous hands-on exercises provide practice using SQL, SQL*Plus, and PL/SQL.

Prerequisites
No prior knowledge of SQL or Oracle is required. Some programming experience is helpful for the embedded SQL portion of class.

Topics

Relational database concepts
SQL syntax and usage
Oracle database storage and locking
SELECT, INSERT, UPDATE, DELETE, TRUNCATE, GRANT, REVOKE statements
Joins and outer joins
Subqueries
UNION/INTERSECT/MINUS
Table / View / Synonym creation (DROP, CREATE, ALTER)
Referential Integrity features
SQL*Plus reporting
Stored PL/SQL Procedures, Functions, and Packages
Database Triggers

Oracle for Developers with PL/SQL

Relational database concepts

SQL syntax and usage

Oracle database storage and locking

SELECT, INSERT, UPDATE, DELETE, TRUNCATE, GRANT, REVOKE statements

Joins and outer joins

Subqueries

UNION/INTERSECT/MINUS

Table / View / Synonym creation (DROP, CREATE, ALTER)

Referential Integrity features

SQL*Plus reporting

Stored PL/SQL Procedures, Functions, and Packages

Database Triggers