Improving Query Performance in SQL Server
In this course, students will learn to write queries that are both efficient and easy to read and understand.
Comienza El Curso Gratis4 horas16 vídeos58 ejercicios21.755 aprendicesDeclaración de cumplimiento
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.¿Entrenar a 2 o más personas?
Probar DataCamp for BusinessPreferido por estudiantes en miles de empresas
Descripción del curso
A mission critical assignment is depending on your SQL coding skills. You’ve been given some code to fix. It is giving the results you need but it’s running too slow, and it’s poorly formatted making it hard to read. The deadline is tomorrow. You’ll need to reformat the code and try different methods to improve performance. The pressure is on!!! In this course we’ll be using SQL on real world datasets, from sports and geoscience, to look at good coding practices and different ways how we can can improve the performance of queries to achieve the same outcome.
¿Entrenar a 2 o más personas?
Obtén a tu equipo acceso a la plataforma DataCamp completa, incluidas todas las funciones.En las siguientes pistas
Desarrollador SQL Server
Ir a la pistaSQL Server para Administradores de Bases de Datos
Ir a la pista- 1
Introduction, Review and The Order of Things
GratuitoIn 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.
Introduction50 xpFormatting - player BMI100 xpCommenting - player BMI100 xpCommenting - how many Kiwis in the NBA?100 xpAliasing50 xpAmbiguous column names50 xpAliasing - team BMI100 xpQuery order50 xpProcessing order50 xpSyntax order - New Zealand earthquakes100 xpSyntax order - Japan earthquakes100 xpSyntax order - very large earthquakes100 xp - 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.
Filtering with WHERE50 xpColumn does not exist100 xpFunctions in WHERE100 xpTest your knowledge of WHERE50 xpFiltering with HAVING50 xpRow filtering with HAVING100 xpFiltering with WHERE and HAVING100 xpTest your knowledge of HAVING50 xpInterrogation after SELECT50 xpSELECT what you need100 xpLimit the rows with TOP100 xpShould I use ORDER BY?50 xpManaging duplicates50 xpRemove duplicates with DISTINCT()100 xpUNION and UNION ALL100 xpUNION or DISTINCT()?50 xp - 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.
Sub-queries50 xpUncorrelated sub-query100 xpCorrelated sub-query100 xpSub-query vs INNER JOIN100 xpPresence and absence50 xpINTERSECT100 xpEXCEPT100 xpInterrogating with INTERSECT100 xpAlternative methods 150 xpIN and EXISTS100 xpNOT IN and NOT EXISTS100 xpNOT IN with IS NOT NULL100 xpAlternative methods 250 xpINNER JOIN100 xpExclusive LEFT OUTER JOIN100 xpTest your knowledge50 xp - 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.
Time statistics50 xpSTATISTICS TIME in queries100 xpSTATISTICS TIME results50 xpPage read statistics50 xpSTATISTICS IO: Example 1100 xpSTATISTICS IO: Example 2100 xpSTATISTICS IO comparison50 xpIndexes50 xpTest your knowledge of indexes50 xpClustered index100 xpExecution plans50 xpSort operator in execution plans100 xpTest your knowledge of execution plans50 xpQuery performance tuning: final notes50 xp
¿Entrenar a 2 o más personas?
Obtén a tu equipo acceso a la plataforma DataCamp completa, incluidas todas las funciones.En las siguientes pistas
Desarrollador SQL Server
Ir a la pistaSQL Server para Administradores de Bases de Datos
Ir a la pistacolaboradores
requisitos previos
Intermediate SQL Server
¿Qué tienen que decir otros alumnos?
¡Únete a 15 millones de estudiantes y empieza Improving Query Performance in SQL Server hoy mismo!
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.