Skip to main content
HomeSQL

course

Improving Query Performance in SQL Server

Intermediate
4.2+
14 reviews
Updated 12/2024
In this course, students will learn to write queries that are both efficient and easy to read and understand.
Start course for free

Included for FreePremium or Teams

SQLSoftware Development4 hours16 videos58 exercises4,450 XP21,912Statement of Accomplishment

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.
Group

Training 2 or more people?

Try DataCamp for Business

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.

Prerequisites

Intermediate SQL Server
1

Introduction, Review and The Order of Things

Start Chapter
2

Filtering and Data Interrogation

Start Chapter
3

Sub-queries and presence or absence

Start Chapter
4

Query performance tuning

Start Chapter
Improving Query Performance in SQL Server
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Enroll now

Don’t just take our word for it

*4.2
from 14 reviews
57%
14%
29%
0%
0%
  • Lyndon H.
    11 months

    An excellent presentation showing that good practices can result in more efficient queries and maintainable for the future.

  • Julie L.
    about 1 year

    Nice

  • Melvin A.
    over 1 year

    Right to the point. I was expecting something like that.

  • Jānis Š.
    over 1 year

    Got to know many new things.

  • Emilio F.
    almost 2 years

    This course clearly teaches how queries are executed, how we can see each step of the query and how much each step costs in performance, how and what to look for when trying to optimize queries.

"An excellent presentation showing that good practices can result in more efficient queries and maintainable for the future."

Lyndon H.

"Nice"

Julie L.

"Right to the point. I was expecting something like that."

Melvin A.

Join over 15 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.