Viện Công Nghệ Kỹ Thuật Sài Gòn - Đào tạo CNTT

Chương trình đào tạo
Trang chủ   //   Chương trình đào tạo   //   Hãng đào tạo   //  

Oracle Database 12c: Administrator Certified Expert (OCE)

Oracle Database: SQL Tuning for Developers

24 hours

In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

  • PL/SQL Developer
  • Support Engineer
  • Application Developers
  • Developer
  • Data Warehouse Developer

After completing this course, students will be able to:

  • Modify a SQL statement to perform at its best
  • Identify poorly performing SQL
  • Trace an application through its different levels of the application architecture
  • Understand how the Query Optimizer makes decisions about how to access data
  • Define how optimizer statistics affect the performance of SQL
  • List the possible methods of accessing data, including different join methods
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service

OCE

Before attending this course, students must have:

  • Familiarity with database architecture
  • Knowledge of SQL and PL/SQL
  • Introduction
  • Introduction to SQL Tuning
  • Using Application Tracing Tools
  • Understanding Basic Tuning Techniques
  • Optimizer Fundamentals
  • Generating and Displaying Execution Plans
  • Interpreting Execution Plans and Enhancements
  • Optimizer: Table and Index Access Paths
  • Optimizer Join Operations
  • Other Optimizer Operators
  • Introduction to Optimizer Statistics Concepts
  • Using Bind Variables
  • SQL Plan Management
  • Workshops
  • Oracle Cloud Overview