Oracle Database 19c: SQL Tuning Workshop Course Overview

To ensure you have a successful learning experience in the Oracle Database 19c: SQL Tuning Workshop, the following prerequisites are recommended:

• Basic understanding of database concepts, including relational database design and structure.
• Familiarity with data manipulation language (DML) such as INSERT, UPDATE, DELETE, and SELECT statements in SQL.
• Experience with Oracle Database management and maintenance, including an understanding of the Oracle Database architecture and components.
• Knowledge of how to use Oracle SQL Developer or similar database tools for executing SQL queries.
• Prior experience with creating and managing database objects like tables, indexes, and views.
• Understanding of basic query optimization principles and the significance of execution plans.
• Comfort with the use of command-line interfaces, as some tools like trcsess may require command-line operations.

These prerequisites are designed to ensure that you can fully engage with the course content and apply the SQL tuning techniques taught. If you are new to some of these concepts, consider taking foundational courses in SQL and Oracle Database administration before enrolling in the SQL Tuning Workshop.

Target Audience for Oracle Database 19c: SQL Tuning Workshop

The Oracle Database 19c: SQL Tuning Workshop is designed for professionals looking to optimize SQL performance on Oracle databases.

• Database Administrators

  
  

• SQL Database Developers

  
  

• Performance Analysts

  
  

• Oracle Database Engineers

  
  

• IT Professionals involved in SQL tuning and optimization

  
  

• Technical Consultants

  
  

• Support Engineers

  
  

• Data Scientists with a focus on database management

  
  

• Application Developers managing database back-ends

  
  

• Data Analysts requiring in-depth knowledge of Oracle SQL performance

  
  

• System Architects designing applications with Oracle databases

  
  

• Database Managers overseeing performance and tuning

  
  

• Business Intelligence Professionals

  
  

• Data Warehouse Specialists

  
  

• IT Project Managers with a focus on database projects

  
  

• Professionals preparing for Oracle SQL Performance Tuning certification

  
  

Learning Objectives - What you will Learn in this Oracle Database 19c: SQL Tuning Workshop?

Introduction to Oracle Database 19c: SQL Tuning Workshop Course Outcomes:

This course offers an in-depth understanding of SQL tuning for Oracle Database 19c, focusing on optimizing SQL statements to achieve better database performance and stability.

Learning Objectives and Outcomes:

• Understand the fundamentals of SQL tuning and develop quick solution strategies for performance enhancement.
• Use application tracing tools and the trcsess utility to identify performance bottlenecks.
• Grasp the core principles of the Oracle Optimizer, including the estimator's approach to selectivity and cardinality.
• Acquire the skills to generate and interpret execution plans using tools like AUTOTRACE and Automatic Workload Repository (AWR).
• Learn to interpret and enhance execution plans to optimize SQL statement performance.
• Explore the Optimizer's approach to table and index access paths, including the use and benefits of different index types such as bitmap indexes.
• Gain insights into the different join operators used by the Optimizer and understand their impact on query performance.
• Investigate various Optimizer operators and their roles in query execution plans.
• Understand the importance of Optimizer statistics and how to use histograms for improved query plans.
• Implement the use of bind variables and cursor sharing to promote efficient SQL execution.
• Master SQL Plan Management, including configuration and management scenarios, to maintain SQL performance consistency.