SQL Tuning Mastery

Database Internals
($97 value)
A 30k foot view of database internals, answering questions like "How can UNDO slow your queries down, and how can you avoid it?" or "Why does a 16GB database not fit in a 16GB buffer cache?"
Fundamentals of Tuning
($97 value)
This gives you the rock-solid foundation you need for attacking any tuning problem. We answer questions like "What tuning metrics should I use? How do I know when I have the best possible plan? "
Index Mastery
($1297 value)
Provides a rock-solid understanding of what exactly an index is, how it works, and what to do to make your indexes RIDICULOUSLY efficient.
Reading Plans
($750 value)
This is all about how to interpret the various operations of an execution plan so that you can understand exactly what's happening with your query under the hood.
Controlling Plans
($675 value)
This is all about how to overcome "Oracle-is-ignoring-my-hint" syndrome. I show you how to hint like a PRO, use baselines and SQL profiles to bend the optimizer to your will.
Join Order
($850 value)
Join order is critical to getting the best performance for your query. In this section, I reveal the SECRET to finding the perfect join order....EVERY SINGLE TIME. Very, very few trainings teach this; but when you master it, your queries run faster than a speeding bullet.
Cardinality Feedback
($750 value)
This is all about how to make the optimizer better understand your data, so that you can avoid having to tune queries in the first place.
Phrasing Queries for Performance
($997 value)
This is all about how to rewrite queries for performance. Very few resources are available on this topic; exploring this all-but-forgotten art will help you get the plans you want and help the database better understand what you mean.
Time Analysis
($897 value)
This module lets you quickly identify your query's bottleneck.
BONUS #1 - Practice SQL Tuning Database
($597 value)
31 days access to a practice tuning database with 25 different scenarios where you can hone your tuning skills, available at any time.
BONUS #2 - 12 Weeks of Coaching Calls
($6,000 value)
Bring any SQL Monitor report, any execution plan, any AWR report, or ask any questions you'd like.