0(0)

Oracle Database 12c: SQL Tuning for Developers Ed 1

  • Course level: Intermediate
  • Categories Oracle
  • Total Enrolled 0
  • Last Update February 20, 2021

Description

In Oracle Database: SQL Tuning for Developers Training course, you will learn about Oracle SQL tuning and explore to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. This course will take you through introduction to Oracle Database Exadata Express Cloud Service, how to decipher, decide and then apply tuning to your SQL code.

What Will I Learn?

  • Use Oracle tools to identify inefficient SQL statements.
  • Use Automatic SQL Tuning.
  • Use Real Time SQL monitoring.
  • Write more efficient SQL statements.
  • Monitor and trace high load SQL statements.
  • Manage optimizer statistics on database objects.
  • Understand the optimizer process steps and operators.
  • Interpret execution plans.
  • Perform application tracing.
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service.
Free

Material Includes

  • Duration: Full-time- 15 Days
  • Duration: Part-time- 9 Months
  • 28 hours on-demand video
  • 11 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Requirements

  • Familiarity with database architecture
  • Knowledge of SQL and PL/SQL

Target Audience

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