Available Training Rooms

  • Classroom Training
    PRIVATE BATCH
  • Virtual Instructor-led Training
    PUBLIC PROGRAM
  • On Demand Training
    ON DEMAND
  • Hybrid Training
    BLENDED

Course Details

  1. Understanding Execution Plans:
  • How to generate and interpret execution plans.
  • Identifying inefficiencies in SQL statements.

 

  1. Optimizer Fundamentals:
  • Role of the Oracle optimizer.
  • Table and index access paths.
  • Join operations and their impact on performance.

 

  1. Indexing Techniques:
  • Creating and using indexes effectively.
  • Bitmap and function-based indexes.

 

  1. Database Statistics:
  • Importance of accurate statistics.
  • Automatic statistics gathering and manual updates.

 

  1. SQL Tuning Techniques:
  • Using SQL Tuning Advisor.
  • Rewriting queries for better performance.
  • Adaptive cursor sharing and bind variables.

 

  1. Materialized Views:
  • Creating and using materialized views for faster data retrieval.
  • Global temporary tables

 

  1. Performance Monitoring Tools:
  • Using SQL Trace, TKPROF, and Automatic Workload Repository (AWR reports).
  • Identifying and addressing slow SQL queries.

 

  1. SQL Plan Management:
  • Managing and evolving SQL execution plans.

 

  1. Advanced Topics:
  • Parallel execution.
  • Optimizing DML operations (INSERT, UPDATE, DELETE).

 

  1. Workshops &  Hands-On Practice:
  • Real-world scenarios for SQL tuning.
  • Analyzing and optimizing poorly written SQL statements.

Audience

  • Administrators

Public Program Schedule

Course NameDurationBrochureLocationScheduleEnroll
SQL Optimization & Performance Tuning4 Days
img
Register

Download the syllabus

Download

The highest standard, The happiest learners

img

Sarada
Accenture Security-India | Training Operations

We appreciate the session conducted by Rohit Srivastava on Metaverse and Web3 Security as part of the ATCI Security Week 2022.   We received excellent feedback from the audience and look forward to many such collaborative opportunities in the future.

img

Rich Rushton
COO Layer 8 Training

Brijesh has done an excellent job. Things are a little bit slow in May – but RPS is high on our list to fill voids in our schedule. Thank you for being easy to work with!

Our Enterprise Clients

  • Logo - i Nautix
  • Logo - Genpact
  • Logo - Unisys
  • Logo - Fujitsu
  • Virtusa
  • Logo - Microland
  • Logo - GE
  • Logo - Intuit
  • Logo - Allstate

FAQ

Other Related Courses

    Related courses will be updated soon...

Other Certifications

AWS Training Partner
Google cloud
VMware Partner Logo
Redhat Partner logo
Citrix

Students Certified

0167899

Keep me Updated

Get tips, latest Courses and Offers


I can confirm that I have read the Privacy policy and accepted the terms and conditions