We may earn an affiliate commission when you visit our partners.
Troubleshooting Your First Low-performing T-SQL Query
Jared Westover
Jared Westover
Perhaps you’re starting out or have been plagued by low performing T-SQL queries for years. Maybe you have been appointed the new SQL expert but your query tuning skills are lacking. In this course, Troubleshooting Your First Low-performing T-SQL Query, you...
Read more
Perhaps you’re starting out or have been plagued by low performing T-SQL queries for years. Maybe you have been appointed the new SQL expert but your query tuning skills are lacking. In this course, Troubleshooting Your First Low-performing T-SQL Query, you...
Read more
Perhaps you’re starting out or have been plagued by low performing T-SQL queries for years. Maybe you have been appointed the new SQL expert but your query tuning skills are lacking. In this course, Troubleshooting Your First Low-performing T-SQL Query, you will gain foundational knowledge of improving query performance. First, you will hear what vital questions can be asked about a query. Understanding the intent of what data your query is returning back is paramount in improving performance. Along the way, you will learn the internals of how SQL Server stores and retrieves data. Next, you will discover tools built into SQL Server Management Studio. These tools are vital for exploring the SQL Server internals. Finally, you will explore several low performing queries utilizing your newly acquired skills to improve performance. When you’re finished with this course, you will have the skills and knowledge necessary to consistently improve low performing queries.
Register for this course and see more details by visiting:
OpenCourser.com/course/26yq4i/troubleshooting
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Course targets T-SQL queries and introduces foundational concepts for performance improvement
Builds a foundation for understanding how SQL Server stores and retrieves data
Introduces SQL Server Management Studio tools for exploring SQL Server internals
Emphasizes practical application of acquired skills to improve query performance
Save this course
Save Troubleshooting Your First Low-performing T-SQL Query to your list so you can find it easily later:
Save
Save
Career center
Learners who complete Troubleshooting Your First Low-performing T-SQL Query will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
A Database Administrator can manage, monitor, and optimize the performance of databases. In the course Troubleshooting Your First Low-performing T-SQL Query, you will learn foundational knowledge of improving query performance. This knowledge can help inform the decisions you make as a Database Administrator.
Data Analyst
Data Analyst
A Data Analyst can collect, clean, and analyze data to identify trends and patterns. In the course Troubleshooting Your First Low-performing T-SQL Query, you will learn the internals of how SQL Server stores and retrieves data. This knowledge can help you better understand the data you are working with as a Data Analyst.
Business Intelligence Analyst
Business Intelligence Analyst
A Business Intelligence Analyst can use data to make informed decisions about a business. In the course Troubleshooting Your First Low-performing T-SQL Query, you will learn tools built into SQL Server Management Studio. These tools can help you explore the SQL Server internals which can aid you as a Business Intelligence Analyst.
Software Developer
Software Developer
A Software Developer can design, develop, and maintain software applications. In the course Troubleshooting Your First Low-performing T-SQL Query, you will learn several low performing queries utilizing your newly acquired skills to improve performance. This knowledge can help you improve the performance of the software applications you develop.
Data Scientist
Data Scientist
A Data Scientist can use data to solve complex problems. In the course Troubleshooting Your First Low-performing T-SQL Query, you will gain foundational knowledge of improving query performance. This knowledge can help you improve the performance of the data science models you develop.
Database Architect
Database Architect
A Database Architect can design and implement database systems. In the course Troubleshooting Your First Low-performing T-SQL Query, you will learn how to explore SQL Server internals. This knowledge can help you design and implement better performing database systems as a Database Architect.
Systems Analyst
Systems Analyst
A Systems Analyst can design and implement computer systems. In the course Troubleshooting Your First Low-performing T-SQL Query, you will learn tools built into SQL Server Management Studio. These tools can help you implement better performing computer systems.
Technical Writer
Technical Writer
A Technical Writer can write technical documentation. In the course Troubleshooting Your First Low-performing T-SQL Query, you will gain foundational knowledge of improving query performance. This knowledge can help you write better documentation for software that uses SQL Server.
Computer Programmer
Computer Programmer
A Computer Programmer can write code to solve problems. In the course Troubleshooting Your First Low-performing T-SQL Query, you will learn several low performing queries utilizing your newly acquired skills to improve performance. This knowledge can help you write better code as a Computer Programmer.
Network Engineer
Network Engineer
A Network Engineer can design and implement computer networks. In the course Troubleshooting Your First Low-performing T-SQL Query, you will learn tools built into SQL Server Management Studio. These tools can aid in designing and implementing better performing computer networks.
Help Desk Technician
Help Desk Technician
A Help Desk Technician can provide technical support to users. In the course Troubleshooting Your First Low-performing T-SQL Query, you will gain foundational knowledge of improving query performance. This knowledge can help you better assist users with SQL Server related issues.
Computer Systems Analyst
Computer Systems Analyst
A Computer Systems Analyst can analyze and design computer systems. In the course Troubleshooting Your First Low-performing T-SQL Query, you will learn the internals of how SQL Server stores and retrieves data. This knowledge can help you better analyze and design computer systems.
Software Engineer
Software Engineer
A Software Engineer can design and develop software applications. In the course Troubleshooting Your First Low-performing T-SQL Query, you will learn several low performing queries utilizing your newly acquired skills to improve performance. This knowledge can help you develop better performing software applications.
IT Consultant
IT Consultant
An IT Consultant can provide IT advice and support to businesses. In the course Troubleshooting Your First Low-performing T-SQL Query, you will gain foundational knowledge of improving query performance. This knowledge can help you better advise businesses on how to improve the performance of their SQL Server systems.
Information Technology Specialist
Information Technology Specialist
An Information Technology Specialist can provide technical support and maintenance for computer systems. In the course Troubleshooting Your First Low-performing T-SQL Query, you will learn tools built into SQL Server Management Studio. These tools can help you better maintain computer systems that use SQL Server.
For more career information including salaries, visit:
OpenCourser.com/course/26yq4i/troubleshooting
Reading list
We've selected five 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
Troubleshooting Your First Low-performing T-SQL Query.
Covers advanced techniques for optimizing query performance in SQL Server. Useful as a reference tool for in-depth performance tuning.
A practical guide to troubleshooting performance problems in SQL Server. Useful as a reference tool for resolving specific performance issues.
Provides a comprehensive overview of SQL Server execution plans. Valuable as a reference tool for understanding how SQL Server processes queries.
Focuses on practical techniques for improving the performance of SQL Server queries. Useful as a reference tool for specific performance tuning scenarios.
A comprehensive textbook that covers the fundamentals of database systems. Useful as a background resource for understanding the concepts behind SQL Server.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/26yq4i/troubleshooting
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Time
2 hours
Via
Pluralsight
Instructor
Jared Westover
Good to know
Course targets T-SQL queries and introduces foundational concepts for performance improvement
Builds a foundation for understanding how SQL Server stores and retrieves data
Introduces SQL Server Management Studio tools for exploring SQL Server internals
Emphasizes practical application of acquired skills to improve query performance
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