Software Development Basics
Fundamental principles and concepts
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.
Pluralsight Teams₹4,166.75 per user/month, billed annually
₹50,004
CompleteBilled Monthly
₹2,370/mo
Why choose Core Tech?
verifiedGet this course for free with the Coursera Plus subscription.
✓ Compare courses before making a decision
Check Latest Price →Price may vary. Check latest price on provider site.
Course Insight
Suitable for beginner learners. This course serves as an entry point into Software Development, building foundational knowledge before moving on to advanced frameworks or specialized paths.
Beginner FriendlySelf-Paced Learning
SKILLS TO
MASTER
Practical ApplicationTrending
Real-world project implementationBest Practices
Industry standard workflows and guidelinesCareers:Relevant for professionals pursuing roles within Software Development.
Quick Facts
Below sections are verified from last major sync. For real-time updates and today's latest lectures, Check official page here.
What You’ll Learn
- Getting Started : 20mins.
- Analyzing SQL Statements for Performance : 37mins.
- Building Effective Indexes : 47mins.
- Finding Performance Bottlenecks in SQL Server : 26mins.
- Capturing What Your Application is Doing Inside SQL Server : 49mins.
- Applying Common Performance Practices : 21mins.
See side-by-side differences in what you’ll learn
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.
See how this course compares with alternatives
FAQs
Top Alternatives
Highly-rated courses worth your attention
⭐ 5(358+ learners)