1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Azure SQL and SQL Server Query Performance Tuning

Azure SQL and SQL Server Query Performance Tuning

Contents

keyboard_tab
Introduction
1
Course Introduction
PREVIEW1m 19s
2
Overview
PREVIEW2m 43s
Storage & Compression
10
Storage
13m 2s
Summary
Course Introduction
Overview
Difficulty
Intermediate
Duration
1h 26m
Students
343
Ratings
5/5
starstarstarstarstar
Description

SQL is the language for interacting with databases, and like all computer languages, there are many ways to achieve the right result. And like other software languages, some ways will be better and more efficient than others. What sets SQL and database programming apart from most other computer programming is the vast amount of data that is regularly dealt with, and how other factors that are not immediately obvious can impact the SQL query code you write.

This course looks at ways that you can see how the SQL Server engine views your queries and how it intends to execute them. Using that information, we look at other factors like table and index design that can positively or negatively impact your query execution.

For any feedback relating to this course, please contact us at support@cloudacademy.com.

Learning Objectives

  • Understand what impacts query performance when using SQL
  • Learn how the SQL Server engine processes queries
  • Use execution plans to see how a query is executed
  • Instruct the query engine
  • Understand how different query types can be used
  • Learn how to design tables to make queries more efficient
  • Use database file configuration to improve performance
  • Understand how database compression can impact performance

Intended Audience

This course is aimed at database administrators, data engineers, or anyone who wants to learn how to improve database query execution.

Prerequisites

To get the most out of this course, you should be familiar with SQL query syntax, SQL data types, and SQL table structure.

Resources

https://github.com/cloudacademy/azure-sql-query-tuning-dp-300

 

Transcript

Hi and welcome to the Azure SQL query tuning course. As the course name suggests, we'll be looking at how to improve your databases' performance, particularly in the area of data retrieval using queries.

In this course, you will see that how a query is structured is important but is definitely not the most important factor in how quickly and efficiently it can pull requested data. The database and tables structure is of greater importance. No matter how clever or optimized your query is, if the underlying data is structured in an inefficient way, then there is no hope of obtaining the best possible data retrieval performance.

With that in mind, to get the most out of this course, not only should you be familiar with SQL query syntax, but also SQL data types and table structure. So, while this might not seem like a beginner's course, primarily due to the prerequisite knowledge, it is important to understand sooner rather than later how to build a database that is efficiently structured.

My name is Hallam Webber and I will be your instructor for this course. We welcome all comments and feedback, so please feel free to reach out to us at support@cloudacademy.com with any questions or comments. Let's get started.

About the Author
Avatar
Hallam Webber
Software Architect
Students
15460
Courses
28
Learning Paths
3

Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a  Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.