Oracle Database


Oracle Database Courses

Course Name Hours CEUs Content
OR5475: Troubleshooting, Debugging and Tuning Oracle PL/SQL Programs 14.00 1.40
Description: This fast-paced, hands-on course helps the student identify performance issues and problem areas within their PL/SQL code using various techniques and packages. Some of the topics covered include Profiling and Tracing, Debugging, Tuning and Exception Handling. These topics include details on the PL/SQL Optimizer, Subprogram Inlining, Subprogram Invocations, Bulk Binding, Pipelined Table Functions, Helpful Pragmas and Native Compilation and Execution of PL/SQL code. A number of useful Oracle supplied packages are covered including DBMSPROFILER, DBMSTRACE, DBMSHPROF, DBMSWARNING and DBMSPARALLELEXECUTE. Oracle versions 11g and 12c are covered.

# of Days:
Select Location:
Select Date & Time:
OR5480: Oracle SQL Optimization for Developers and DBAs 21.00 2.10
Oracle Database 12c: Administration Workshop 35.00 3.50
Oracle Database 12c: PL/SQL I - Introduction 14.00 1.40
Oracle Database 12c: PL/SQL II - Intermediate: Develop Program Units 21.00 2.10
Oracle Database 12c: PL/SQL III - Advanced Programming Tuning 35.00 3.50
Oracle Database 12c: SQL Fundamentals I 21.00 2.10
Oracle Database 12c: SQL Fundamentals II 21.00 2.10
Teradata v15 Architecture and SQL 35.00 3.50