SQL is awesome. You tell the database the result you want. And it figures out how to execute it.
If the optimizer decides how to run your query, how do you go about making it faster?!
Ask many experts and they'll tell you to look at the statement's execution plan. But what is this plan, how do you get it, and how does it help you make your SQL quicker?
In this you'll learn how to get and understand an execution plan to find the slowest parts of your statement. It then shows you how to get better plans by improving the table's statistics and make SQL faster by creating indexes or materialized views.
The course continues with a discussion of how the join algorithms work and specifics for making inserts, updates, and deletes faster. The class finishes with an overview of how to find the slowest SQL statements in your application and a course review.
This class covers these topics:
Each module starts with a video introducing a performance concept. These informative videos give an overview of the feature. An interactive Live SQL tutorial follows. These flesh out the syntax details and enable you to practice tuning real SQL statements.
To finish each module there is a series of quizzes to check you've understood the concepts.
The best part? This tutorial is 100% FREE and run completely online.
The first module starts on Monday 3rd August. You can register for free now.
Still not sure?
Here are selected quotes from students from previous Oracle Dev Gym classes:
"The most useful aspect was the possibility to practice the exercises on Oracle Live SQL. That alleviate me to install an Oracle Database on my notebook and jump right away to what matter."
"The combination of videos which were both entertaining & informative, Live SQL examples to work through the topics, and the Quizzes is a winning formula! Being able to try out the topics in an online version of the database and then use the Quizzes to reinforce your understanding of those concepts is really useful."
"Videos are interesting to watch and listen to. They are engaging, diverse and illustrate well the concepts."
"I got a few concepts clarified. Thanks for being precise and concise and the exact documents to be referred as well. You explained well."
"Mix of teaching modes plus quiz. You see and hear, then you read and (in theory) try it, then double check that you got it with a quiz."
"Everything was well explained."
"Great content presented casually but thouroghly"
Nothing. Nada. Nil. Zilch. That's right, it's 100% FREE! As is everything else at the Oracle Dev Gym.
You'll learn the basics of SQL performance tuning:
Once you complete all modules of a class, you can print your class certificate. If your average grade in the class is 90% or higher, you receive a Certificate of Excellence. Otherwise you will get a Certificate of Completion. Either way, congratulations on a job well done!
Yes! You can join Databases for Developers: Performance at any time
If you want to do a complete restart, simply drop the class and re-register. You can do this by scrolling down to the bottom of the page and clicking on the link provided. If you simply want to retake the quizzes in an individual module or entire class, again, go to the bottom of the page and click on that link.
The modules have no fixed end date. Once you're registered you can take the class whenever you want
We estimate that this will take up to 30 minutes per module.
This is a self-paced course. Once registered, you have lifetime access to these materials to review at any time. So you can complete it at your leisure.
The course is a combination of:
No! This is a fully online course. The materials are designed so you can complete the course without a database.
Yes! Oracle has the following free offerings:
This course assumes a solid understanding of SQL. If you're looking to learn SQL, join Databases for Developers: Foundations or Databases for Developers: Next Level to improve your skills.
You can reach out to Chris Saxon.
Ready to join? Head to the registration page to sign up!
Chris Saxon is an Oracle Developer Advocate for SQL. His job is to help you get the best out of the Oracle Database and have fun with SQL!