ORACLE DATABASE 19C: SQL TUNING WORKSHOP

ORACLE DATABASE 19C: SQL TUNING WORKSHOP

Summary

Location

Location

Malaysia

Duration

Duration

3 Days
Format

Format

Public Class

Public Class

Unleash Your Potential with Oracle Training

Looking to supercharge your career in the world of databases and SQL? Dive into the realm of Oracle with our comprehensive ‘Oracle Database 19C: SQL Tuning Workshop’ course. This oracle training program, offered by Info Trek, is your gateway to mastering the art of SQL tuning and performance optimization.

Elevate Your Database Expertise

Designed for Application Developers, Data Warehouse Developers, PL/SQL Developers, and Support Engineers, this 3-day/21-hour course takes you on a journey to harness the full potential of Oracle Database 19C. With a strong foundation in database architecture, SQL, and PL/SQL, you’ll delve into the intricacies of SQL tuning. Learn to identify poorly performing SQL, trace applications through their architecture, and understand how the Query Optimizer makes critical data access decisions.

Practical Learning for Real-World Impact

Through interactive lectures, discussions, practical exercises, and workshops, you’ll not only modify SQL statements for peak performance but also gain valuable insights into optimizing execution plans, understanding access paths, and utilizing optimizer statistics. This course equips you with the skills needed to excel in the fast-paced world of database management, making you an indispensable asset to your organization and boosting your career prospects.

Don’t just keep up with the corporate world; lead the way with Oracle training from Info Trek. Join us on this exciting journey of learning and empowerment, and let Oracle Database 19C: SQL Tuning Workshop be your stepping stone to a brighter and more prosperous future.

Course Details

Course Duration: 3 days/21 hours; Instructor-led/ remote online training

Audience

This course is specially design for Application Developers, Data Warehouse Developer, Developer, PL/SQL Developer and Support Engineer

Prerequisites

Required Prerequisites:

  • Familiarity with database architecture
  • Knowledge of SQL and PL/SQL
  • Oracle Database: Introduction to SQL

Recommended Related Training Courses:

  • Using Java – for PL/SQL and Database Developers. This Java for PL/SQL and Developers training teaches you to access Oracle Database using JDBC, UCP, Java stored procedures and SQLJ technologies. Learn to create, load, resolve and publish Java classes in the Database and more.
  • Oracle Database: SQL Workshop II. This Oracle Database: SQL Workshop II helps you manage the database objects, data dictionary views and multiolumn sub queries. Learn to write more efficient queries using the functions supporting the timezone and regular expressions.
  • Oracle Database: SQL Tuning for Developers. 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.
  • Oracle Database: Develop PL/SQL Program Units. This Oracle Database: Develop PL/SQL Program Units training helps you enhance your skills by developing stored procedures, functions, packages, and database triggers. Learn to manage PL/SQL program units and use Oracle-supplied packages.
  • Oracle Database: PL/SQL Fundamentals. Oracle Database: PL/SQL Fundamentals introduces you to the PL/SQL programming language. Learn about stored procedures, functions and creating blocks of application code that can be shared by multiple forms and data management applications.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

Course Objectives

Upon completion of this program, participants should 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.

Outlines

  • Course Introduction
  • Workshop 1: Enhancing the Performance of a SQL Query Statement
  • Introduction to SQL Tuning
  • Quick Solution Strategy
  • Workshop 2: Reviewing the Execution Steps of the SQL Statement
  • Practice 2-1: Using SQL Developer
  • Using Application Tracing Tools
  • Trcsess Utility
  • Workshop 3: Learn to Tune Sort Operation Using an Index in the ORDER BY Clauses
  • Practice 3-1: Tracing Applications (Part 01)
  • Practice 3-1: Tracing Applications (Part 02)
  • Optimizer Fundamentals
  • Query Estimator: Selectivity and Cardinality
  • Plan Generator
  • Workshop 4: Identifying and Tuning a Poorly Written SQL Statement
  • Practice 4-1: Understanding Optimizer Decisions (Optional)
  • Generating and Displaying Execution Plans
  • AUTOTRACE
  • Automatic Workload Repository
  • Workshop 5: Effects of Changing the Column Order in a Composite Index
  • Practice 5-1: Extracting an Execution Plan by Using SQL Developer
  • Practice 5-2: Extracting Execution Plans
  • Interpreting Execution Plans and Enhancements
  • Workshop-6: Using Information in the 10053 File to Tune a SQL Statement
  • Practice 6-1: Using Dynamic Plans
  • Optimizer: Table and Index Access Paths
  • Indexes: Overview
  • Bitmap Indexes
  • Common Observations
  • Workshop 7: Understanding the Optimizer’s Decision
  • Practice 7-1: Using Different Access Paths (Part 01)
  • Practice 7-1: Using Different Access Paths (Part 02)
  • Practice 7-1: Using Different Access Paths (Part 03)
  • Practice 7-1: Using Different Access Paths (Part 04)
  • Optimizer: Join Operators
  • Workshop 8: Tuning Strategy
  • Practice 8: Using Join Paths
  • Other Optimizer Operators
  • Workshop 9: Using SQL Plan Baseline to Manage a Better Execution Plan
  • Practice 9-1: Using the Result Cache
  • Practice 9-2: Using Other Access Paths (Optional)
  • Introduction to Optimizer Statistics Concepts
  • Column Statistics: Histograms
  • Session-Specific Statistics for Global Temporary Tables
  • Practice 10-1: Index Clustering Factor
  • Practice 10-2: Creating Expression Statistics
  • Practice 10-3: Enabling Automatic Statistics Gathering Optional (Part 01)
  • Practice 10-3: Enabling Automatic Statistics Gathering Optional (Part 02)
  • Practice 10-4: Using System Statistics (Optional)
  • Using Bind Variables
  • Cursor Sharing Enhancements
  • Practice 11-1: Using Adaptive Cursor Sharing
  • Practice 11-2: Using CURSOR_SHARING (Optional)
  • SQL Plan Management
  • Configuring SQL Plan Management
  • Possible SQL Plan Manageability Scenarios
  • Practice 12-1: Using SQL Plan Management SPM (Part 01)
  • Practice 12-1: Using SQL Plan Management SPM (Part 02)

Trainers

Reviews

Interested In

ORACLE DATABASE 19C: SQL TUNING WORKSHOP

Starting From
RM5000
Intake Date
17-19 APR 2024
,
10-12 JULY 2024
,
7-9 OCT 2024
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: ORACLE DATABASE 19C: SQL TUNING WORKSHOP
Duration: 3 Days
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *