Oracle for Experienced SQL Developers

Course Number:  580-JK
Recommended Duration:  3 days

Intended Audience
Developers with prior experience using SQL and PL/SQL to create applications.

Course Overview
Introduces experienced SQL Developers and Programmers to Oracle, Oracle SQL, SQL*Plus, PL/SQL, and Oracle's data dictionary.  Targeted to those with programming experience using DB2, Sybase, Informix, MS SQL Server, etc..  There are ten machine exercises.  (The instructor may provide additional exercises based upon the needs of the students.)

Course appropriate for Oracle 11g or Oracle 10g. (earlier course versions available).

Objectives
Attendees will learn the differences encountered when developing applications for Oracle and when converting systems to Oracle.  Through a series of exercises and lectures, students will learn Oracle's products and features first-hand and how they may best be utilized.

Prerequisites:  Prior knowledge of SQL is necessary.

Topics

• Oracle architecture and available tools

• SQL enhancements and differences

• Oracle objects

• Large objects (BLOB, CLOB, BFILE)

• Oracle security features, storage quotas and limits

• SQL*Plus

• Oracle data dictionary views

• PL/SQL fundamentals

• Stored procedures, functions, and triggers

• Query optimization, and optimization differences

• EXPLAIN, TKPROF and AUTOTRACE

• Locking