Courses
SQL Serverでクエリ性能を改善する
中級スキルレベル
更新 2023/02無料でコースを始める
含まれるものプレミアム or チーム
SQLProgramming4時間16 videos58 Exercises4,450 XP24,561達成証明書
数千社の学習者に愛用されています
2人以上をトレーニングしますか?
DataCamp for Businessを試すコースの説明
前提条件
Intermediate SQL Server1
Introduction, Review and The Order of Things
In this chapter, students will learn how SQL code formatting, commenting, and aliasing is used to make queries easy to read and understand. Students will also be introduced to query processing order in the database versus the order of the SQL syntax in a query.
2
Filtering and Data Interrogation
This chapter introduces filtering with WHERE and HAVING and some best practices for how (and how not) to use these keywords. Next, it explains the methods used to interrogate data and the effects these may have on performance. Finally, the chapter goes over the roles of DISTINCT() and UNION in removing duplicates and their potential effects on performance.
3
Sub-queries and presence or absence
This chapter is an introduction to sub-queries and their potential impacts on query performance. It also examines the different methods used to determine if the data in one table is present, or absent, in a related table.
4
Query performance tuning
Students are introduced to how STATISTICS TIME, STATISTICS IO, indexes, and executions plans can be used in SQL Server to help analyze and tune query performance.
SQL Serverでクエリ性能を改善する
コース完了