Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Oracle SQL and PL/SQL Update

Recommended Duration:
3 Days
Version
Oracle 12c
(earlier course versions available)
Benefits
Participants improve SQL, PL/SQL and other Oracle-related skills so that they may more efficiently and easily satisfy user needs. Latest releases and features of Oracle products are discussed. Hands-on exercises allow participants to practice new skills.
Audience
Database Administrators or other experienced users of Oracle and SQL needing to further update Oracle knowledge and skills. This class is intended for administrators, designers and developers of Oracle systems.
Prerequisites
Previous Oracle experience/education is essential to understanding the advanced topics presented in this class. Participants should be familiar with SQL, PL/SQL, and SQL*Plus or SQL Developer (or the local tool).
Major Topics
  • Oracle concepts and data storage
  • Advanced SQL usage
  • EXPLAIN and DBMS_XPLAN
  • TKPROF
  • AUTOTRACE
  • Complex SELECT statements (subqueries, joins, outer joins, analytic functions, and more)
  • Oracle object creation
  • Granting/revoking authorizations
  • Dynamic SQL
  • Indexing, proper use of indexes
  • SQL use of indexes
  • Optimizing SQL
  • Caching
  • Hints
  • XML
  • JSON
  • PL/SQL performance keys
  • Stored Procedures, Functions, Packages, and Triggers
  • Backup and Recovery
  • SQL Loader
Exercises
There are eleven hands-on machine exercises.