Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

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.)