Optimization of SQL query Tuning and Performance

提供方
Coursera Project Network
在此指导项目中,您将:

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.

Clock2 Hours
Intermediate中级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

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.

您要培养的技能

  • Postgresql
  • Database (DBMS)
  • Relational Database
  • SQL

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1. You will be able to create tables and insert data.

  2. You will be able to execute and plan times of the queries using Explain and Explain Analyze.

  3. You will be able to apply different types of indexes to improve performance.

  4. You will be able to apply the hash and nest loop join strategies.

  5. You will be able to apply the merge join strategy.

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心