Improving Query Performance in SQL Server Data Camp

Overview

Context

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 Improving Query Performance in SQL Server course offered by Data Camp 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.

What you will learn during this course:

• You will learn how SQL code formatting, commenting, and aliasing is used to make queries accesible Students will also be introduced to query processing order in the database versus the order of the SQL syntax in a query.
• You will be introduced to 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.
• You will be introduced to sub-queries and their potential impacts on query performance. You will also examine the different methods used to determine if the data in one table is present, or absent, in a related table.