Optimization of SQL query Tuning and Performance
Create tables, insert data and execute and plan times of the queries using Explain and Explain Analyze.
Apply different types of indexes to improve performance.
Apply the hash, merge and nest loop join strategies.
By the end of this project, you will be able to professionally write queries with better performance using some techniques and improve the performance of queries and make the execution time faster. It provides you with the important steps to tune your queries. database tuning is essential to easily organizing and accessing database data by creating different types of indexes to improve performance. and in applying the hash, nest loop joins and merge join strategies. You will also be able to create tables and insert data. And You will be able to execute queries using Explain and Explain Analyze. This guided project is for people in the field of data and data engineering. people who want to learn how to improve the performance of queries and make the execution time faster. It provides you with the important steps to tune your queries.
Skills you will develop
Learn step-by-step
In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:
You will be able to create tables and insert data.
You will be able to execute and plan times of the queries using Explain and Explain Analyze.
You will be able to apply different types of indexes to improve performance.
You will be able to apply the hash and nest loop join strategies.
You will be able to apply the merge join strategy.
How Guided Projects work
Your workspace is a cloud desktop right in your browser, no download required
In a split-screen video, your instructor guides you step-by-step
Frequently asked questions
Frequently Asked Questions
What will I get if I purchase a Guided Project?
Are Guided Projects available on desktop and mobile?
Who are the instructors for Guided Projects?
Can I download the work from my Guided Project after I complete it?
What is the refund policy?
Is financial aid available?
Can I audit a Guided Project and watch the video portion for free?
How much experience do I need to do this Guided Project?
Can I complete this Guided Project right through my web browser, instead of installing special software?
What is the learning experience like with Guided Projects?
More questions? Visit the Learner Help Center.
Coursera Footer
