We may earn an affiliate commission when you visit our partners.
David Berry

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.

Read more

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.

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.

Enroll now

Here's a deal for you

We found an offer that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

What's inside

Syllabus

Getting Started
Analyzing SQL Statements for Performance
Building Effective Indexes
Finding Performance Bottlenecks in SQL Server
Read more
Capturing What Your Application is Doing Inside SQL Server
Applying Common Performance Practices

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Explores practical ways to improve SQL Server database performance, ranging from setting up efficient indexes to tracing SQL queries
Taught by David Berry, a recognized authority in SQL Server performance optimization
Designed for developers who want to enhance the performance of their applications that utilize SQL Server
Covers essential concepts like indexing strategies, performance monitoring tools, and best practices for optimizing SQL queries
Provides hands-on guidance through real-world examples and demonstrations

Save this course

Save What Every Developer Should Know About SQL Server Performance to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in What Every Developer Should Know About SQL Server Performance with these activities:
Read "SQL Server Performance Tuning" by Itzik Ben-Gan
Gain in-depth knowledge of SQL Server performance tuning techniques.
Show steps
Learn about SQL Server indexes
Build effective indexes to improve performance and reduce the execution time of SQL statements.
Show steps
  • Understand different types of indexes (clustered, non-clustered, unique, etc.) and their impact on performance.
  • Identify which columns should be indexed based on query patterns and data distribution.
  • Use tools like SQL Server Management Studio or Azure Data Studio to create and manage indexes.
Show all two activities

Career center

Learners who complete What Every Developer Should Know About SQL Server Performance will develop knowledge and skills that may be useful to these careers:
Software Engineer
As a Software Engineer, you will be tasked with designing, developing, and maintaining software applications. Understanding SQL Server performance is crucial in this role, as it will enable you to create efficient and scalable applications that can handle large volumes of data and complex queries. This course covers the fundamentals of SQL Server performance, providing you with the tools and techniques to diagnose and resolve performance bottlenecks, ensuring the optimal performance of your software applications.
Database Administrator
Database Administrator is responsible for managing and maintaining database systems, ensuring their availability, performance, and security. This course aligns perfectly with this role, as it provides a comprehensive understanding of SQL Server performance. You will learn how to identify and resolve performance issues, implement effective indexing strategies, and monitor and tune SQL Server to achieve optimal performance, ensuring the smooth functioning of the database systems you manage.
Data Analyst
As a Data Analyst, you will be involved in collecting, cleaning, and analyzing data to extract meaningful insights and inform decision-making. This course is highly relevant, as it equips you with the skills to understand how SQL Server performance impacts data retrieval and analysis. You will learn how to optimize SQL queries for faster data retrieval, ensuring efficient and timely data analysis, leading to more accurate and actionable insights.
Business Intelligence Analyst
Business Intelligence Analyst plays a crucial role in transforming raw data into actionable insights that drive business decisions. This course aligns well with this role, as it provides a solid understanding of SQL Server performance, a key factor in ensuring efficient data retrieval and analysis. By optimizing SQL queries and addressing performance issues, you can significantly improve the accuracy and timeliness of your insights, leading to more informed decision-making and better business outcomes.
Data Scientist
As a Data Scientist, you will work with large and complex datasets, using statistical and machine learning techniques to uncover patterns and make predictions. This course may be useful to you, as it provides a foundation in SQL Server performance, which is essential for efficient data retrieval and analysis. By understanding how to optimize SQL queries and troubleshoot performance issues, you can improve the accuracy and efficiency of your data analysis, leading to more valuable insights and better predictive models.
Solutions Architect
Solutions Architect designs and implements IT solutions that meet the specific needs of an organization. This course may be useful to you, as it provides a foundation in SQL Server performance, a critical consideration in designing and implementing scalable and efficient data solutions. By understanding how to optimize SQL queries and troubleshoot performance issues, you can ensure that the solutions you design and implement meet the performance requirements of the organization.
Systems Analyst
Systems Analyst analyzes and designs computer systems, working closely with end-users to understand their needs and develop solutions that meet those needs. This course may be useful to you, as it provides a foundation in SQL Server performance, a key factor in designing and implementing efficient and responsive systems. By understanding how to optimize SQL queries and troubleshoot performance issues, you can ensure that the systems you design and implement meet the performance expectations of the end-users.
Software Developer
Software Developer designs, develops, and maintains software applications. This course may be useful to you, as it provides a foundation in SQL Server performance, a key consideration in developing scalable and efficient software applications. By understanding how to optimize SQL queries and troubleshoot performance issues, you can ensure that the applications you develop meet the performance requirements of the end-users.
IT Manager
IT Manager plans, organizes, and directs the activities of an organization's IT department. This course may be useful to you, as it provides a foundation in SQL Server performance, a key factor in ensuring the smooth and efficient operation of IT systems and applications. By understanding how to optimize SQL queries and troubleshoot performance issues, you can ensure that the IT systems and applications meet the performance requirements of the organization.
Database Developer
Database Developer designs and develops database systems, working closely with database administrators to ensure the efficient and reliable storage and management of data. This course may be useful to you, as it provides a foundation in SQL Server performance, a key factor in designing and implementing scalable and efficient database systems. By understanding how to optimize SQL queries and troubleshoot performance issues, you can ensure that the database systems you design and develop meet the performance requirements of the organization.
Technical Support Specialist
Technical Support Specialist provides technical support to users of computer systems and applications. This course may be useful to you, as it provides a foundation in SQL Server performance, a key factor in troubleshooting and resolving performance issues experienced by users. By understanding how to optimize SQL queries and troubleshoot performance issues, you can more effectively assist users in resolving performance-related problems, improving their overall satisfaction and productivity.
Project Manager
Project Manager plans, organizes, and executes projects, ensuring their successful completion within the specified time, budget, and scope constraints. This course may be useful to you, as it provides a foundation in SQL Server performance, a key factor in managing and executing projects that involve the use of SQL Server. By understanding how to optimize SQL queries and troubleshoot performance issues, you can ensure that the projects you manage are completed on time, within budget, and meet the performance expectations of the stakeholders.
Quality Assurance Analyst
Quality Assurance Analyst tests and evaluates software applications to ensure they meet the specified requirements and quality standards. This course may be useful to you, as it provides a foundation in SQL Server performance, a key factor in ensuring the performance and reliability of software applications. By understanding how to optimize SQL queries and troubleshoot performance issues, you can more effectively test and evaluate software applications, ensuring their quality and fitness for purpose.
Data Warehouse Architect
Data Warehouse Architect designs and implements data warehouse systems, ensuring the efficient and reliable storage and management of large volumes of data. This course may be useful to you, as it provides a foundation in SQL Server performance, a key factor in designing and implementing scalable and efficient data warehouse systems. By understanding how to optimize SQL queries and troubleshoot performance issues, you can ensure that the data warehouse systems you design and implement meet the performance requirements of the organization.
Database Designer
Database Designer designs and develops database schemas, ensuring the efficient and reliable storage and management of data. This course may be useful to you, as it provides a foundation in SQL Server performance, a key factor in designing and implementing scalable and efficient database schemas. By understanding how to optimize SQL queries and troubleshoot performance issues, you can ensure that the database schemas you design and develop meet the performance requirements of the organization.

Reading list

We've selected nine books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in What Every Developer Should Know About SQL Server Performance.
SQL Server Performance Tuning teaches the most current techniques for analyzing and tuning any SQL Server database - from the single-machine small business environment to the multi-processor, multi-terabyte enterprise data center.
Provides practical advice on identifying and resolving SQL Server performance issues.
Contains a collection of performance counter metrics relevant to SQL Server performance.
Offers practical guidance on performance tuning techniques for SQL Server.
Specifically designed for developers, this book focuses on performance tuning techniques that can be implemented by application developers.
Provides detailed guidance on troubleshooting and resolving SQL Server performance problems.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to What Every Developer Should Know About SQL Server Performance.
Managing SQL Server Database Performance
Most relevant
Managing SQL Server Database Maintenance
Most relevant
SQL Server Application Development Best Practices
Most relevant
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL...
Most relevant
MySQL for Beginners
Most relevant
Microsoft SQL Server Integration Services (SSIS) Training
Most relevant
SQL Server: Installing and Configuring SQL Server 2016
SQL Server 2017: Diagnosing Performance Issues with DMVs
Getting Started with SQL Server Transactions
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser