Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Advanced Topics in Oracle

Recommended Duration:
3 Days
Version
Oracle 12c
(earlier course versions available)
Benefits
Participants will improve SQL and other Oracle-related skills so that they may more efficiently and easily satisfy user needs. The latest releases of Oracle products will be discussed. Hands-on exercises will allow participants to: practice complex SQL statements, learn how to use catalog tables, properly use indexes, be able to detect and improve many common performance problems, and use PL/SQL.
Audience
Experienced users of Oracle and SQL needing to further develop 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 machine exercises.