Optimization of SQL query Tuning and Performance

位教师：Omnya Khaled

访问权限由 New York State Department of Labor 提供

2,871 人已注册

指导项目

在专家的指导下，学习、练习并应用工作就绪技能

3.2

（32 条评论）

中级等级

推荐体验

2 Hours

自行安排学习进度

实践学习

了解更多

指导项目

在专家的指导下，学习、练习并应用工作就绪技能

3.2

（32 条评论）

中级等级

推荐体验

2 Hours

自行安排学习进度

实践学习

了解更多

您将学到什么

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.

您将练习的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

授课语言：英语（English）

无需下载或安装

仅桌面可用

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

在 2 小时内学习、练习并应用岗位必备技能

接受行业专家的培训
获得解决实训工作任务的实践经验
使用最新的工具和技术来建立信心

关于此指导项目

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.

分步进行学习

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

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.