course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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:
Trust me, I will catch your hand and take you step by step!!!
See you inside,
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: SQL Tuning Introduction|
Why SQL Tuning?Preview
Prerequisites for SQL TuningPreview
SOFT parse vs HARD parsePreview
|Quiz 1||2 questions|
Which Parse is better?
|Section 2: Optimizer and its Execution Plan|
Cost based Optimization
SQL Tuning Tools
Running Explain Plan
|Section 3: Accessing Tables|
What is my Address?
Types of Table Accesses
Table Access FULL
Table Access by ROWID
Index Unique Scan
Index Range Scan
Choosing between FULL and INDEX scan
|Section 4: Explain Plan|
What should you look for?
What is COST?
Rules of Execution Plan Tree
Traversing through the Tree
Reading Execution Plan
Execution Plan Example #1
Execution Plan Example #2
Execution Plan Example #3
Execution Plan Example #4
|Section 5: Simple Tuning Rules|
Using Table Aliases
Using WHERE rather than HAVING
|Section 6: Index Suppression|
Index Suppression reasons
Use of <> operator
Use of SUBSTR function
Use of Arithmetic operators
Use of TRUNC function on Date columns
Use of || operator
Comparing a character column to a numeric value
Use of IS NULL and IS NOT NULL
Function based Indexes
Index Suppression SQL
|Section 7: Performance Improvement Considerations|
Use UNION instead of OR
Use UNION ALL instead of UNION
Minimize Table lookups in a Query
EXISTS vs IN
Use EXISTS instead of DISTINCT
Reading same table multiple times?
Use TRUNCATE instead of DELETE
|Section 8: Considerations while using SQL in programming|
Reduce the number of Trips to the database
Issue frequent COMMIT statements
Using BULK COLLECT
|Section 9: Join Methods|
Nested Loop Join
Sort Merge Join
|Section 10: HINTS to the database|
Forcing a specific Join Method
|Section 11: House Keeping|
Invalid Optimizer Statistics
Checking SQL statements which are performing BAD
|Section 12: Design Considerations|
Effective Schema Design
Separate Tablespace for Data and Index
Index Organized Tables
Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.
Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.
Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.