OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Udemy logo

SQL Server Performance Tuning Part 1

4.5 Filled star Filled star Filled star Filled star Half star
Based on 5,578 ratings
see reviews
Raphael Asghar

This course is designed for any student that is interestedin learning about how to fine tune their SQL Server and databases. Also, developers, SQL DBAs, IT staff and NetworkAdministration

At the end of this course, the student will have extensive knowledgein the following areas:

Indexes, wait stats, fill factor, fragmentation, data andlog file allocation, tempdb configuration, common performance issues, blocking,locking, database tuning advisor, execution plan, caching, virtualization andmuch more

Read more

This course is designed for any student that is interestedin learning about how to fine tune their SQL Server and databases. Also, developers, SQL DBAs, IT staff and NetworkAdministration

At the end of this course, the student will have extensive knowledgein the following areas:

Indexes, wait stats, fill factor, fragmentation, data andlog file allocation, tempdb configuration, common performance issues, blocking,locking, database tuning advisor, execution plan, caching, virtualization andmuch more

You should have a good understanding of SQL ServerAdministration. I would highly recommendthe following courses: Learn T-SQL from Scratch, SQL Administration part 1, SQLAdministration part 2, SQL Administration part 3

Enroll now

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Only 7 hours left!
24-Hour Flash Sale
Close your skills gaps with online courses and save big for a limited time.
Up to
85%
off
Get offer

What's inside

Learning objective

At the end of this course, the student will have extensive knowledge in the following areas: types of indexes that can affect performance, ability to read and understand the execution plans, determine the causes of wait stats, views deeply into statistics, comprehend the cause of the fill factor and page splits, view various execution modes and much much more

Syllabus

The following course SQL Performance Tuning part 1 of 2 will provide the students with the building blocks (knowledge) needed for tuning their databases and SQL Server. We will delve directly into wh
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Attractive to various audiences, including students, developers, SQL DBAs, IT staff, and NetworkAdministration
Builds a solid foundation for learners with fundamental knowledge of SQL Server Administration
Strengthens existing foundation for learners with intermediate knowledge of SQL Server Administration
Instructor Raphael Asghar is not well-known or established in the SQL Server industry
Course strongly recommends prerequisites, indicating that students need prior knowledge to fully benefit

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Sql server performance tuning primer

Based on the course syllabus, potential learners might find this course offers a strong foundation in SQL Server performance tuning fundamentals. The curriculum covers essential topics like indexes, execution plans, wait stats, locking, and TempDB configuration. Designed for IT professionals such as DBAs and developers, it appears structured to provide extensive knowledge in key tuning areas. It is noted that a good understanding of SQL Server Administration is recommended, suggesting it builds upon existing knowledge rather than starting from scratch.
Specific tuning topics are listed.
"The detailed syllabus gives a clear picture of what will be covered."
"I like that specific items like B-Tree indexes, page splits, and operators are listed."
"Knowing the course includes sections on hardware, autogrowth, and statistics is helpful."
Content targets DBAs, developers, IT.
"This course seems very relevant for my role as a SQL Server DBA or developer."
"The topics covered, like execution plans and wait stats, are key for IT professionals."
"It appears designed to help those working with SQL Server databases in a professional capacity."
Fundamentals of tuning are included.
"I expect this course to cover essential areas like indexes, execution plans, and wait stats."
"The syllabus details important topics like blocking, locking, and tempdb."
"It appears designed to give foundational knowledge in performance tuning."
Prior SQL Admin knowledge is advised.
"I understand that a good grasp of SQL Server Administration is highly recommended before starting."
"It sounds like this course builds on prior knowledge, not for absolute beginners."
"Having experience with T-SQL and basic administration seems crucial."

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 SQL Server Performance Tuning Part 1 with these activities:
Review "SQL Performance Tuning" by Itzik Ben-Gan
Review the classic book on SQL performance tuning to gain a deep understanding of the underlying concepts and best practices.
View T-SQL Fundamentals (Developer Reference) on Amazon
Show steps
  • Read the book thoroughly, taking notes and highlighting important concepts
  • Apply the knowledge gained from the book to your own SQL performance tuning tasks
  • Write a summary or review of the book, sharing your key takeaways
Attend virtual meetups or conferences on SQL performance tuning
Connect with other professionals in the field and learn about the latest trends and best practices in SQL performance tuning.
Show steps
  • Search for virtual meetups or conferences on SQL performance tuning
  • Register for the events that are relevant to your interests
  • Attend the events and participate in discussions, ask questions, and share your knowledge
Participate in an online workshop on SQL performance tuning
Enhance your SQL performance tuning skills by attending a workshop led by experienced professionals.
Show steps
  • Search for online workshops on SQL performance tuning
  • Select a workshop that aligns with your learning goals
  • Register for the workshop and actively participate in the sessions
Five other activities
Expand to see all activities and additional details
Show all eight activities
Practice indexing and query optimization
Reinforce your understanding of indexing principles and SQL performance optimization by practicing and solving various exercises.
Show steps
  • Complete the practice exercises provided in the course
  • Create your own sample database and table to experiment with different indexing strategies
  • Analyze the execution plans of your queries to identify potential performance bottlenecks
Follow online tutorials on advanced SQL performance tuning
Expand your knowledge of SQL performance tuning by following online tutorials provided by experts in the field.
Show steps
  • Search for online tutorials on advanced SQL performance tuning
  • Select tutorials that cover topics that are relevant to your current knowledge and skill level
  • Follow the tutorials step-by-step, taking notes and experimenting with the provided examples
Write a blog post or article on SQL performance tuning
Share your knowledge of SQL performance tuning by writing a blog post or article that explains key concepts and techniques to a broader audience.
Show steps
  • Choose a topic related to SQL performance tuning that you are knowledgeable about
  • Research the topic to gather information and examples
  • Write a draft of your blog post or article, explaining the concepts in a clear and concise way
  • Edit and proofread your content to ensure accuracy and clarity
  • Publish your blog post or article on a relevant platform
Develop a SQL performance tuning plan
Apply your knowledge of SQL performance tuning by creating a comprehensive plan to improve the performance of a real-world database.
Show steps
  • Identify a database that is experiencing performance issues
  • Gather data about the database's usage, workload, and performance metrics
  • Analyze the data to identify potential performance bottlenecks
  • Develop a plan to address the bottlenecks, including recommendations for indexing, query optimization, and hardware upgrades
  • Implement the plan and monitor the database's performance to verify improvements
Start a personal project to apply SQL performance tuning
Solidify your understanding of SQL performance tuning by working on a project where you can apply your skills to a real-world scenario.
Show steps
  • Choose a project idea that allows you to apply the principles of SQL performance tuning
  • Design and create a database schema for your project
  • Populate your database with sample data
  • Write SQL queries to interact with your database and test its performance
  • Apply SQL performance tuning techniques to improve the performance of your queries

Career center

Learners who complete SQL Server Performance Tuning Part 1 will develop knowledge and skills that may be useful to these careers:
Data Warehouse Architect
Data Warehouse Architects design and implement data warehouses that store and manage large volumes of data. This may include working with SQL Server or other database management systems. This course can help build a foundation for designing and implementing SQL Server data warehouses.
See salaries and explore the career path for Data Warehouse Architect
Database Architect
Database Architects design and implement database systems that meet the needs of an organization. This may include working with SQL Server or other database management systems. This course can help build a foundation for designing and implementing SQL Server databases.
See salaries and explore the career path for Database Architect
Database Developer
A Database Developer will design and develop database management systems for clients. This course will introduce you to the fundamentals of SQL Server, which may be necessary for this role.
See salaries and explore the career path for Database Developer
Business Intelligence Analyst
As a Business Intelligence Analyst, you will spend your day gathering, analyzing, and interpreting data to identify trends and patterns. This course can help build a foundation for the data analysis that is crucial to this role.
See salaries and explore the career path for Business Intelligence Analyst
Data Analyst
Working as a Data Analyst, you will spend your day collecting, cleaning, and analyzing data to help businesses make informed decisions. This course can help build a foundation for working with SQL, which is commonly used for data analysis.
See salaries and explore the career path for Data Analyst
Data Scientist
Data Scientists spend their day gathering, analyzing, and interpreting data to identify trends and patterns. This course can help build a foundation for the data analysis that is crucial to this role.
See salaries and explore the career path for Data Scientist
Statistician
Statisticians collect, analyze, and interpret data to provide insights into social, economic, or scientific issues. This course can help build a foundation for the data analysis that is crucial to this role.
See salaries and explore the career path for Statistician
Software Engineer
As a Software Engineer, you will spend your day designing, developing, and testing software applications. This course will introduce you to the fundamentals of SQL Server and help build a foundation for working with databases, which may be necessary to the software you will develop.
See salaries and explore the career path for Software Engineer
IT Manager
An IT Manager will plan, implement, and manage an organization’s IT systems and infrastructure. This can include working with SQL Server, as well as other software and hardware components. This course may be useful for giving you a broad understanding of SQL Server and its role in an organizational context.
See salaries and explore the career path for IT Manager
Systems Administrator
As a Systems Administrator, you will spend your day managing and maintaining an organization’s computer systems. This can include working with SQL Server, as well as other software and hardware components. This course may be useful for giving you a broad understanding of SQL Server and its role in an organizational context.
See salaries and explore the career path for Systems Administrator
Network Administrator
As a Network Administrator, you will spend your day managing and maintaining computer networks. This can include working with SQL Server, as well as other software and hardware components. This course may be useful for giving you a broad understanding of SQL Server and its role in an organizational context.
See salaries and explore the career path for Network Administrator
Database Administrator
As a Database Administrator, you will spend your day managing and maintaining an organization’s databases. This can include working with SQL Server, designing and implementing database systems, and providing technical support to users. This course may be useful for giving you a solid understanding of SQL Server’s capabilities and how to maintain it.
See salaries and explore the career path for Database Administrator
Information Security Analyst
Information Security Analysts protect an organization’s computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction. This course may be useful for giving you an understanding of SQL Server and its role in data security.
See salaries and explore the career path for Information Security Analyst
Quality Assurance Analyst
Quality Assurance Analysts develop and execute test plans to ensure that software products meet quality standards. This course may be useful for giving you an understanding of SQL Server and its role in data management.
See salaries and explore the career path for Quality Assurance Analyst
Project Manager
As a Project Manager, you will spend your day planning, organizing, and executing projects. This can include working with SQL Server, as well as other software and hardware components, to manage project data. This course may be useful for giving you an understanding of SQL Server and its role in data management.
See salaries and explore the career path for Project Manager

Reading list

We've selected six 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 SQL Server Performance Tuning Part 1.
Cover image
Business Financial Planning with Microsoft Excel
Save
By Gavin Powell valuable resource for gaining a deeper understanding of query optimization, wait statistics, and other important topics related to SQL Server performance.
Business Financial Planning with Microsoft Excel
Paperback
$$
Business Financial Planning with Microsoft Excel
Kindle Edition
$$
Cover image
SQL Server Query Performance Tuning Distilled
Save
If you want to delve deeper into the topic of SQL Server query performance tuning, this book by Aneel Kumar great choice.
SQL Server Query Performance Tuning Distilled...
Paperback
$$
SQL Server 2008 Query Performance Tuning Distilled...
Paperback
$$
SQL Server Query: Performance Tuning Distilled
Paperback
$$$
Cover image
The Art of SQL
Save
By Antje Baron helpful resource for understanding how to tune SQL Server for optimal performance.
The Art of SQL
Paperback
$$
The Art of SQL
Kindle Edition
$$
Cover image
IBM solidDB: Delivering Data with Extreme Speed
Save
Provides insights into performance monitoring and tuning techniques for SQL Server.
IBM SolidDB: Delivering Data with Extreme Speed
Paperback
$$
Cover image
Query Store for SQL Server 2019
Save
By Grant Fritchey provides a detailed examination of SQL Server execution plans.
Query Store for SQL Server 2019: Identify and Fix...
Paperback
$$
Query Store for SQL Server 2019: Identify and Fix...
Kindle Edition
$$
Cover image
Inside Microsoft SQL Server 2008 T-SQL Programming
Save
Provides best practices for SQL Server administration and performance tuning.
Inside Microsoft SQL Server 2008 T-SQL Programming...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to SQL Server Performance Tuning Part 1.
Choose Azure SQL Database Service Tier that Suits Your...
Most relevant
Build and Execute MySQL, PostgreSQL, and SQLServer to...
Most relevant
Hospital management database using SQL server
Most relevant
Database Architecture, Scale, and NoSQL with Elasticsearch
Most relevant
.NET Core Microservices - The Complete Guide (.NET 6 MVC)
Most relevant
Routines in SQL: Stored procedures in SQL Server
Most relevant
Microsoft SQL Server Development for Everyone
Most relevant
Microsoft SQL Server: Performance Tuning Essentials
Most relevant
Optimization of SQL query Tuning and Performance
Most relevant

Udemy Buyer Protection & Guarantee

Verified partner policies & purchase protections

Global Marketplace Leader
Free Trial & Audit

Free Lecture Previews

Free preview video lectures available for all courses; optional 7-day free trial on Personal Plan subscriptions (cancel before trial ends to avoid conversion).

Return & Refund Policy

30-Day Money-Back Guarantee

30-day money-back guarantee on all eligible individual course purchases (provided course content has not been substantially consumed or downloaded). Subscription fees are non-refundable once billed.

Buyer Protections

Verified Academic & Industry Partner

Lifetime access to purchased individual courses and future updates, verifiable certificate of completion, and direct student Q&A forums.

Key Purchase Protections
30-day 100% money-back guarantee on course purchases
Lifetime access on web, mobile, and offline
Certificate of completion included with purchase
Direct instructor Q&A and active student community
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Rating
4.5 Filled star Filled star Filled star Filled star Half star
Effort
6 total hours
Via
Udemy
Instructor
Raphael Asghar
Language
English
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Attractive to various audiences, including students, developers, SQL DBAs, IT staff, and NetworkAdministration
Builds a solid foundation for learners with fundamental knowledge of SQL Server Administration
Strengthens existing foundation for learners with intermediate knowledge of SQL Server Administration
Instructor Raphael Asghar is not well-known or established in the SQL Server industry
Course strongly recommends prerequisites, indicating that students need prior knowledge to fully benefit
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to SQL Server Performance Tuning Part 1.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
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 - 2025 OpenCourser