Course Description
Good SQL Developers are in high demand and demand 100k+ salary in the IT industry.
SQL performance tuning is an art to master - for all of us!!!
Many
SQL Developers have tried to understand why a particualr SQL was
running slow - including me - but have failed over and over again
because we never tried to understand how SQL works? We were thinking it
is database administrators Job!!!!
If we have to advance in our career and earn a good salary, we need these SQL tuning skills.
We know how it feels if someone talks about SQL Tuning and I dont want you to feel the same.
I took baby steps in introducing you to the optimizer and helping you write an effecient SQL.
This
course takes a systematic approach to planning, analyzing, debugging
and troubleshooting common query-related performance problems and will
provide you with the skills necessary to write scalable, high
performance SQL.
The SQL tuning methodology I used:
- Identify a problem SQL statement
- Determine how Oracle is executing SQL statement and why Oracle chose that way.
- Investigate whether alternative executon plans would be better.
- Update the SQL statement to push Oracle towards the better plan.
Trust me, I will catch your hand and take you step by step!!!
Curriculum
Why SQL Tuning?
Access Paths
Bitmap Indexes
Checking SQL statements which are performing BAD
Choosing between FULL and INDEX scan
Comparing a character column to a numeric value
Cost based Optimization
Effective Schema Design
Execution Plan
Execution Plan
Execution Plan Example #1
Execution Plan Example #2
Execution Plan Example #3
Execution Plan Example #4
EXISTS vs IN
Forcing a specific Join Method
Function based Indexes
Gathering Statistics
Hash Join
HINTS list
Index Organized Tables
Index Range Scan
Index Suppression reasons
Index Suppression SQL
Index Unique Scan
Invalid Optimizer Statistics
Issue frequent COMMIT statements
Join Methods
Minimize Table lookups in a Query
Nested Loop Join
Optimizer statistics
Parsing
Partitioned Tables
Prerequisites for SQL Tuning
Reading Execution Plan
Reading same table multiple times?
Reduce the number of Trips to the database
Rules of Execution Plan Tree
Running Explain Plan
Section 1: SQL Tuning Introduction
Section 10: HINTS to the database
Section 11: House Keeping
Section 12: Design Considerations
Section 2: Optimizer and its Execution Plan
Section 3: Accessing Tables
Section 4: Explain Plan
Section 5: Simple Tuning Rules
Section 6: Index Suppression
Section 7: Performance Improvement Considerations
Section 8: Considerations while using SQL in programming
Section 9: Join Methods
SELECT consideration
Separate Tablespace for Data and Index
Simple Rules
SOFT parse vs HARD parse
Sort Merge Join
SQL Processing
SQL Tuning Tools
Table Access by ROWID
Table Access FULL
Traversing through the Tree
Types of Table Accesses
Use BIND variables
Use EXISTS instead of DISTINCT
Use of || operator
Use of <> operator
Use of Arithmetic operators
Use of IS NULL and IS NOT NULL
Use of SUBSTR function
Use of TRUNC function on Date columns
Use TRUNCATE instead of DELETE
Use UNION ALL instead of UNION
Use UNION instead of OR
Using BULK COLLECT
Using Table Aliases
Using WHERE rather than HAVING
What is COST?
What is my Address?
What should you look for?
Why HINTS?
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
