Oracle for Experienced SQL Developers
- Recommended Duration:
- 3 Days
- Version
- Oracle 10g, Oracle 9i, or Oracle8i. Course may be adapted for Oracle8 or Oracle 7.
- 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 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.)