Oracle for Experienced SQL Developers
- Recommended Duration:
- 3 Days
- Version
- Oracle 11g or Oracle 10g. Course is also useful for shops using Oracle9i or Oracle8i. (earlier course versions available).
- Benefits
- 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.
- Audience
- Developers with prior experience using SQL and PL/SQL to create applications.
- Prerequisites
- Prior knowledge of SQL is necessary.
- Major 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
- Exercises
- There are eight machine exercises. (The instructor may provide additional exercises based upon the needs of the students.)