Schedule today!

Call Peggy at
  (800) 252-0652

Contact Us

More Oracle

Related Courses

Advanced Topics in Oracle

Recommended Duration:
3 Days
Oracle 12c
(earlier course versions available)
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.
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.
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
  • 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
There are eleven machine exercises.