Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Faster SQL Mastery
Rating: 4.3 out of 5(22 ratings)
125 students

Faster SQL Mastery

Strategies for Optimizing Performance with MS SQL Server
Created byJonathan Szeto
Last updated 4/2021
English

What you'll learn

  • Students will learn how to analyze SQL performance issues and strategies to optimize performance

Course content

1 section • 6 lectures • 4h 51m total length

  • Performance Optimization Strategies49:08
  • Query Optimization35:49
  • Set-Based Programming36:18
  • Indexes33:01

    Indexes help query performance, but too many indexes can hurt overall performance. In this lesson, we will cover the different types of indexes, as well as tools for maintaining them.

  • Table Locking1:13:59
  • Execution Plans1:03:37

Requirements

  • Students must be proficient in SQL and MS SQL Server.

Description

  • Are you having trouble with slow SQL queries?

  • Do you frequently encounter deadlock errors?

  • Are you frustrated with the overall performance of your database?

If the answer to any of these questions is "yes", then Faster SQL Mastery is the course for you!

Faster SQL Mastery teaches you how to improve the performance of your queries in Microsoft SQL Server. You'll learn the following topics in this course:

  • How the data model affects performance.

  • What set-based programming actually means, and common pitfalls novice developers fall into.

  • How to resolve certain scenarios where row-by-row processing seems almost inevitable.

  • Why locking is essential, and how to prevent it from slowing down your queries.

  • How to read execution plans to find performance bottlenecks.

I am a senior SQL database architect with over fifteen years of experience working with MS SQL Server. Let me share with you the strategies, approaches, and tricks that I have learned to improve the performance of slow SQL code and make it run faster than before. You will get some real-world experience on how to analyze and improve SQL database performance.

If you are an intermediate SQL developer or junior DBA with only a few years of experience, this course is perfect for elevating your SQL skills to expert levels. Enroll today to enhance your SQL expertise!

Who this course is for:

  • SQL developers working with MSSQL who struggle with slow performance.

Report abuse