Skip to main content
Grzegorz Gąsiewski avatar

Grzegorz Gąsiewski has completed

Improving Query Performance in SQL Server

Start course For Free
4 hours
4,450 XP
Statement of Accomplishment Badge

Loved by learners at thousands of companies


Course Description

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.
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.
  1. 1

    Introduction, Review and The Order of Things

    Free

    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.

    Play Chapter Now
    Introduction
    50 xp
    Formatting - player BMI
    100 xp
    Commenting - player BMI
    100 xp
    Commenting - how many Kiwis in the NBA?
    100 xp
    Aliasing
    50 xp
    Ambiguous column names
    50 xp
    Aliasing - team BMI
    100 xp
    Query order
    50 xp
    Processing order
    50 xp
    Syntax order - New Zealand earthquakes
    100 xp
    Syntax order - Japan earthquakes
    100 xp
    Syntax order - very large earthquakes
    100 xp
  2. 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.

    Play Chapter Now
  3. 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.

    Play Chapter Now
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

datasets

Orders datasetNBAPlayers datasetNBATeams datasetNBAPlayersStatistics dataset

collaborators

Collaborator's avatar
Mona Khalil
Collaborator's avatar
Becca Robins
Collaborator's avatar
Marianna Lamnina
Dean Smith HeadshotDean Smith

Founder, Atamai Analytics

Dean Smith is geoscientist specializing in information management systems for mining and mineral exploration. He has more than ten years of experience working with SQL Server and data visualization. Dean is the founder of Atamai Analytics, which provides information management and data analytics consulting services to the mining and mineral exploration communities.
See More

Join over 14 million learners and start Improving Query Performance in SQL Server today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.