What Every Developer Should Know About SQL Server Performance

This course is designed to teach developers the fundamentals of SQL Server performance, showing you the tools you will need to troubleshoot and resolve SQL Server performance problems.
Course info
Rating
(197)
Level
Beginner
Updated
June 23, 2016
Duration
3h 21m
Table of contents
Getting Started
19m 47s
Description
Course info
Rating
(197)
Level
Beginner
Updated
June 23, 2016
Duration
3h 21m
Description

As a developer, SQL Server performance can be tricky. In this course, What Every Developer Should Know About SQL Server Performance, you will see how to diagnose what is happening with a slow running SQL statement and what strategies are available to make these statements run faster. First, you will be shown how developers should use database indexes throughout their database, including what columns should be indexed and how to make sure a SQL statement will use an index. Next, you'll go over how some built in diagnostic tools in SQL Server can help you find performance issues in your application, including how to identify the slowest running SQL in your application. Then, you will see how to trace all of the SQL that your application is generating inside of SQL Server and how to understand this data. Finally, you'll take a look at practices you can implement inside of your application to insure the best performance possible. By the end of this course, you as an application developer will have the tools you need to troubleshoot performance problems you may encounter when using SQL Server.

About the author
About the author

David Berry is a software engineer with over 15 years of experience developing applications in languages such as Java and C#. Throughout his career, he has worked extensively with enterprise database systems including Oracle and SQL Server.

More from the author
More courses by David Berry