Oracle Database

Back

Oracle Database Courses

Course Name Hours CEUs Content
OR5480: Oracle SQL Optimization for Developers and DBAs 21.00 2.10
Description: This course provides students with an introduction to application and database tuning. Students will learn how the cost-based optimizer works. A discussion of basic Oracle architecture will provide the foundation for understanding both SQL statement and system performance. Students will use EXPLAIN PLAN and AUTOTRACE for evaluating execution strategies and the DBMSSTATS package for gathering optimizer statistics. Also discussed is how to influence the behavior of the optimizer with hints, physical schema changes, and alternative SQL statement syntax. Factors that affect overall system performance such as the buffer cache, SGA structures, and waits due to locks and latches are presented. Hands-on workshops provide students with a solid understanding of the concepts presented in the lectures. This course can be taught for any Oracle version.

# of Days:
Setting:
Select Location:
v
Select Date & Time:
v
Price:
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