DB Performance Engineering – LIVE Sessions

Gain expertise in Oracle SQL database Tuning and problem solving in performance of SQL queries and Database. Isha presents an Extensive and highly interactive “Database Performance Tuning” Course by our industry expert with 12+ years of hands-on experience. The course syllabus is designed by considering the current job market trends and industry requirements as a Performance engineer or a Performance architect.

About the Instructor:

Who can enroll in this course?

• Performance Engineers
• Performance architects
• Manual Testers
• Automation Testers
• Test Architects
• Data Analysts
• Data Scientists
• QA Engineers

Live Sessions  Price:

For LIVE sessions – Offer price after discount is 199 USD 159 USD  119USD Or 13000 INR 8900 INR 7900 Rupees.

Enroll For Free Demo 

What will I Learn by the end of this course?

• Complete overall knowledge in Oracle Db’s and fine tuning them for better performance
• Determine the bottlenecks in low-performance Oracle databases
• Use Oracle database performance tuning tools, like: Wait Events, AWR, RBO V/S CBO, ASH, V$ views, SQL tracing, real-time monitoring, and EM Express
• Propose solutions to database performance issues
• Implement Oracle methodology in performance tuning
• Using Oracle optimizer for better tuning and execution
• Implementing various tuning methods like different types of indexes, using bind variables and much more.
• Advanced indexing techniques to improve performance and removing bottlenecks
• Discover the ineffectively performing queries and Advanced Query Tuning Techniques
• Identifying bad and good queries to improve performance and removing bottlenecks and Implementing proper tuning approach
• Gathering the metrics and generating performance reports, Creating test plans and strategies

Free Demo Session Timings:

 6th June @ 8 AM – 9 AM (IST) (Indian Timings)

5th June @ 10:30 PM – 11:30 PM EST (U.S Timings)

6th June @ 3:30 AM – 4:30 AM GMT (UK Timings)

Class Schedule:

For Participants in India: Monday to Friday 8 AM  to 9 AM (IST)

For Participants in US: Sunday to Thursday 10:30 PM to 11:30 PM (EST)

For Participants in UK: Monday to Friday 3:30 AM – 4:30 AM (GMT)

What student’s have to say about Vishnu:

Salient Features:

• 20 Hours of Live Training along with recorded videos
• Lifetime access to the recorded videos
• Course Completion Certificate

Course syllabus:

1. Oracle DB and its components:

• Needs of SQL Tuning & Prerequisites for SQL DB Tuning.
• Need for knowing oracle DB Architecture.
• Oracle DB Architecture.
• Data Blocks, PGA, Shared pool, Buffer cache & Redo Log Buffer
• DML Processing, Automatic Memory management, Storage Architecture of Oracle DB, Logical and Physical DB.

2. Oracle Tuning Basics and Tools:

• Wait events
• AWR
• RBO V/S CBO
• Bad SQL, Efficient Schema, Table Partition, SQL statement processing, Optimizer and the needs of it, Query transform, Selectivity and Cardinality, Plan Generator & Row source Generator
• SQL Tuning and Query analysis strategy principles.

3. Execution Plan and Statistics:

• Execution Plan and Explain Plan, Generating Statistics, Generating Execution Plan
• V$SQL_PLAN View
• Reading Execution Plans & Execution Plan Analysis

4. Tables and Index access pathway:

• Indexes and how they work?
• Types of Table and Index Access Paths
• Table Access Full
• Index Unique Scan, Index Range Scan, Index Full Scan, Index Fast Full Scan, Index Skip Scan, Index Join Scan

5. Optimizer hints & Joins

• Hints and their use, some useful Hints
• Join Methods & Join Types
• Nested Loop Joins, Sort Merge Joins, Hash Joins, Cartesian Joins
• Equi joins, Outer Joins, Semi Joins, Anti Joins

6. Optimizer Operators

• Result Cache Operator, View Operator, Clusters
• Sort Operators, Inlist Operator, Count Stopkey Operator, First Row Operator, Filter Operator, Concatenation Operator, Union Operator, Intersect Operator, Minus Operator

7. In Depth SQL Tuning With Query Profiling

• How to find a performance problem and its tuning solution?
• Different Ways of Getting the Execution Plan and the Statistics
• Using the Real-Time SQL Monitoring Tool, Using the Trace Files & TKPROF Utility, Fetch only those absolutely needed.
• Index Usage, Using Concatenation, Using Arithmetic Operators, Using Like Conditions, Using Functions on the Indexed Columns, Handling NULL-Based Performance Problems, Using EXISTS instead of IN Clause, Using TRUNCATE instead of DELETE command, Data Type Mismatch, Tuning Ordered Queries, Fetching MIN & MAX Values, UNION and UNION ALL Operators, Prevent HAVING Clause, Alert about Views, Materialized Views, Optimized use of COMMIT, Partition Pruning, BULK COLLECT, Tuning the Join Order, Multitable DML Operations, Using Temporary Tables, Combining SQL Statements, WITH Clause, Using Analytical Functions

8. Tuning with advanced indexing

• Why is Indexing Important?
• Index Selectivity & Cardinality, B-Tree Indexes in Detail, Bitmap Indexes in Detail, Bitmap Operations
• Composite Indexes and Order of Indexed Columns
• Covering Indexes, Reverse Key Indexes, Bitmap Join Indexes, Cluster Indexes, Invisible Indexes
• Combining Bitmap Indexes, Function-Based Indexes, Index-Organized Tables, Index Key Compression, Full-Text Searches

9. Advanced Oracle DB/SQL Tuning Concepts

• Tuning Star Queries, Using Bind Variables, Beware of Bind Variable Peeking
• Cursor Sharing &Adaptive Cursor Sharing
• Adaptive Plans, Dynamic Statistics (Dynamic Sampling)