We may earn an affiliate commission when you visit our partners.
SQL Server Performance Tuning Part 1
Raphael Asghar
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
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
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
Register for this course and see more details by visiting:
OpenCourser.com/course/splh3q/sql
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
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
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
DOWNLOAD APPLICATIONS
SQL Performance Tuning Part 1
CREATE A VIRTUAL MACHINE
CONFIGURING WINDOWS SERVER
INSTALLING SQL SERVER 2016 PART 1
INSTALLING SQL SERVER 2016 PART 2
INSTALLING SSMS
RESTORING DATABASE
WHAT IS SQL PERFORMANCE TUNING
HARDWARE
DETAIL KNOWLEDGE OF PARTS
AUTOGROWTH SETTING AND QUIZ 1
INDEXES
WHAT IS INDEXING
CREATE A CLUSTERED INDEX WITH PK
NON CLUSTERED INDEX
B TREE
B TREE NON CLUSTER INDEX
ANATOMY OF SQL PAGE
CAUSING A PAGE SPLIT
TYPES OF INDEXES
WHAT IS THE QUERY OPTIMIZER
OPERATORS
TABLE SCAN
NON CLUSTERED INDEX PART 1 AND QUIZ 2
NON CLUSTERED INDEX PART 2
ORDER OF COLUMN IN NON CLUSTERED INDEX
FILTER NON CLUSTERED INDEX
SORT OPERATOR
JOIN OPERATORS
STATISTICS
What is Locking?
What is blocking?
DEADLOCKS
WAIT STATISTICS
RECOMPILATIONS
TEMPDB AND QUIZ 3
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save SQL Server Performance Tuning Part 1 to your list so you can find it easily later:
Save
Save
Reviews summary
Positive reviews for sql server performance tuning part 1
According to students, SQL Server Performance Tuning Part 1 is a great course that builds knowledge on SQL Server performance tuning. Students enjoy this course and find the topic to be interesting.
Students find this course enjoyable and interesting.
"It was Great for me i build my knowledge, performance tuning is my favorite topic, thank you ."
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Review "SQL Performance Tuning" by Itzik Ben-Gan
Show steps
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
Show steps
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
Show steps
Connect with other professionals in the field and learn about the latest trends and best practices in SQL performance tuning.
Show steps
Show steps
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
Show steps
Enhance your SQL performance tuning skills by attending a workshop led by experienced professionals.
Show steps
Show steps
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
Show steps
Reinforce your understanding of indexing principles and SQL performance optimization by practicing and solving various exercises.
Show steps
Show steps
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
Show steps
Expand your knowledge of SQL performance tuning by following online tutorials provided by experts in the field.
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
Apply your knowledge of SQL performance tuning by creating a comprehensive plan to improve the performance of a real-world database.
Show steps
Show steps
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
Show steps
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
Show steps
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:
Database Developer
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.
Database 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.
Data Warehouse Architect
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.
Statistician
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.
Data 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.
Data Scientist
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.
Business Intelligence Analyst
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.
Software Engineer
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.
Systems Administrator
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.
IT Manager
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.
Database 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.
Network 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.
Information Security Analyst
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.
Project Manager
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.
Quality Assurance 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.
For more career information including salaries, visit:
OpenCourser.com/course/splh3q/sql
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.
By Gavin Powell valuable resource for gaining a deeper understanding of query optimization, wait statistics, and other important topics related to SQL Server performance.
If you want to delve deeper into the topic of SQL Server query performance tuning, this book by Aneel Kumar great choice.
Save
By Antje Baron helpful resource for understanding how to tune SQL Server for optimal performance.
Provides insights into performance monitoring and tuning techniques for SQL Server.
By Grant Fritchey provides a detailed examination of SQL Server execution plans.
Provides best practices for SQL Server administration and performance tuning.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/splh3q/sql
Share
Similar courses
Here are nine courses similar to
SQL Server Performance Tuning Part 1.
SQL Server Performance Tuning Part 2
OpenCourser.com/course/t69968/sql
SQL Server Performance Tuning Part 2
Most relevant
SQL Server Administration Part 2
OpenCourser.com/course/gzkdki/sql
SQL Server Administration Part 2
Most relevant
SQL Server Administration Part 3
OpenCourser.com/course/ser9ir/sql
SQL Server Administration Part 3
Most relevant
Effective Query Analysis with SQL Server Tools
OpenCourser.com/course/2g9ivm/effective
Effective Query Analysis with SQL Server Tools
Real-world Scenarios: SQL Server Query Tuning in Action
OpenCourser.com/course/1w9vm7/real
Real-world Scenarios: SQL Server Query Tuning in Action
Oracle SQL Performance Tuning
OpenCourser.com/course/pc1xx2/oracle
Oracle SQL Performance Tuning
SQL Server Performance: Indexing Basics
OpenCourser.com/course/er2xis/sql
SQL Server Performance: Indexing Basics
Data Engineering Essentials using SQL, Python, and PySpark
OpenCourser.com/course/t0sfb9/data
Data Engineering Essentials using SQL, Python, and PySpark
Advanced Query Optimization Techniques in SQL Server
OpenCourser.com/course/ycxpwt/advanced
Advanced Query Optimization Techniques in SQL Server
Effort
6 total hours
Via
Udemy
Instructor
Raphael Asghar
Language
English
Good to know
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
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