Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera Project Network

Optimization of SQL query Tuning and Performance

Coursera Project Network via Coursera

Overview

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.

Syllabus

  • Project Overview
    • 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.

Taught by

Omnya Khaled

Reviews

3.2 rating at Coursera based on 26 ratings

Start your review of Optimization of SQL query Tuning and Performance

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.