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:
Vishnu M an EX-IITian with nearly 12+ years of rich, varied and extensive experience in Performance Engineering. His impeccable passion for sharing his knowledge has motivated to take-up Technical Training. He has 12+ years of real time experience and 12+ years Technical Training experience. |
Sample Videos:
DB Performance Engineering Demo:
DB Performance Engineering Day 1:
Who can enroll in this course?
- Performance Engineers
- Performance architects
- Manual Testers
- Automation Testers
- Test Architects
- Data Analysts
- Data Scientists
- QA Engineers
Recorded Videos Price:
The offer price after the discount is 99 USD 59 39 USD Or USD6500 INR 3500 INR 2500 Rupees.
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, ASH, V$ views, SQL tracing, real-time monitoring,
- 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.
- Discover the ineffectively performing queries
- 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
What student’s have to say about Vishnu:
It was completely amazing course for me and I enjoyed this course a lot while studying. The teaching method is very nice and all the practicals are performed in this course are very easy to memorise. Thanks a lot to Vishnu – Ramesh Kumar
This course has been a great source of learning for me as a Junior DBA,i have learned so much ,it had so much to offer that I never expected from it and overall I am so happy that I took this course. – Melendra Amazing Knowledge Shared by the instructor. A great course to work with. I really recommend this course to the beginners. – Caelyn L. This course greatly assisted me in understanding the basic concept. Truly appreciate the explanation and illustrations. – Ahmed The course was well explained. Just what I wanted to learn. This was my first attempt in Isha and I’m ready impressed with the instructor presentation. Thanks! – Duc N. |
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
- 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.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)
How can I enroll for this course?
OR
Call or WhatsApp on +91-8019952427 to register for free demo
Recorded Videos Price:
The offer price after the discount is 99 USD 59 39 USD Or USD6500 INR 3500 INR 2500 Rupees.
Sample Course Completion Certificate:
Your course completion certificate looks like this….
Course Features
- Lectures 28
- Quizzes 0
- Duration 20 hours
- Skill level All levels
- Language English
- Students 1398
- Assessments Yes