Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Oracle for Experienced SQL Developers

Recommended Duration:
3-4 Days
Version
Oracle 12c or Oracle 11g.
(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 and SQL Developer
  • Oracle data dictionary views
  • PL/SQL fundamentals
  • Stored procedures, functions, and triggers
  • Query optimization, and optimization differences
  • EXPLAIN, TKPROF, AUTOTRACE, DBMS_XPLAN
  • Locking
Exercises
There are eleven regular and two optional machine exercises. (The instructor may provide additional exercises based upon the needs of the students.)