Azure SQL and SQL Server Query Performance Tuning

Focused View

Hallam Webber

1:26:28

12 View

1. Course Introduction.mp4

01:19

2. Overview.mp4

02:44

3. Query Processing.mp4

08:07

4. Query Plans.mp4

08:38

5. Query the Query Store.mp4

05:07

6. DEMO- Hint at an Index.mp4

04:58

7. Index Types.mp4

14:30

8. Table Designs.mp4

12:34

9. Columnstore Index.mp4

04:56

10. Storage.mp4

13:02

11. Compression.mp4

07:02

12. Course Summary.mp4

03:31

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 lesson 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 lesson, please contact us at [email protected].

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 lesson 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 lesson, 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

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft Azure

Hallam Webber

Instructor's Courses

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.

Cloud Academy

View courses Cloud Academy

Join thousands of users in achieving your personal goals through Cloud Academy. Score job-ready tech skills that you can practice in a real environment, without the risk of extra costs or making mistakes. It’s simply the smartest way to gain certifications and get career-ready.