We may earn an affiliate commission when you visit our partners.
Dean Savovic
In this 1-hour long project-based course, you will learn how to (create Azure SQL Server database from Azure portal and with Data Migration Assistant, recognize regressed queries using Query Store and determine top resource consuming queries, get query wait statistics and queries with high variation). Try to limit this to 400-500 characters.
Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.
Register for this course and see more details by visiting:
OpenCourser.com/course/gt16sf/using
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.
Get offer
What's inside
Syllabus
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Provides hands-on training in Azure portal and Data Migration Assistant, in demand in the job market
Imparts skills in identifying regressed queries using Query Store and optimizing resource consumption
Covers essential topics for database professionals, including query optimization and performance analysis
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Practical azure query store fundamentals
According to students, this 1-hour project-based course offers a highly practical and concise introduction to Query Store in Azure SQL. Learners frequently praise the clear instruction and the hands-on approach , enabling them to quickly apply new skills to their work, particularly in identifying and troubleshooting regressed or high-resource queries . While the course is ideal for busy professionals needing specific skills without a major time commitment, a few students note that some prior Azure experience can ease the initial setup. More advanced users might find the content a solid review rather than a deep dive .
Serves as a solid introduction, not an advanced deep dive.
"Good introductory course... for an hour-long project, it's very solid."
"If you're already familiar with Query Store from on-prem SQL Server, much of this might be a review... Perhaps better for those completely new to Query Store or Azure SQL."
"Solid introduction to Query Store for Azure... Could have a bit more on advanced tuning, but it's great for its stated scope."
Instructor provides clear explanations and maintains good pace.
"The instructor clearly explained how to set up Azure SQL Database..."
"The instructor is knowledgeable and presents the material clearly."
"The instructor's pace was perfect, and the hands-on exercises cemented my understanding."
Offers a quick, targeted learning experience for professionals.
"This project was incredibly useful and straight to the point... Highly recommend for anyone working with Azure SQL performance."
"Excellent concise course! I was able to apply what I learned to my work almost immediately. It's perfect for database professionals..."
"Exactly what I needed to quickly get up to speed on Query Store in Azure... This course is a hidden gem for quick learning."
Provides practical, project-based experience.
"The instructor clearly explained how to set up Azure SQL Database and immediately jumped into practical scenarios for Query Store. I loved the hands-on approach..."
"In just an hour, I learned practical steps to use Query Store effectively. The lab environment was well-prepared, and the instructions were easy to follow."
"This is ideal for busy professionals who need to learn a specific skill without a huge time commitment. The hands-on exercises cemented my understanding."
May require some prior Azure experience for smooth setup.
"Beginners without any prior Azure exposure might find the initial setup a little fast-paced, but the core Query Store content is well-explained."
"The content on Query Store was good, but I struggled a bit with the Azure environment setup. The instructions assumed a bit more familiarity than I had..."
"My only minor feedback is that it could benefit from a bit more troubleshooting examples or deeper dives into specific Query Store views..."
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 Using Query Store in Azure with these
activities:
Review SQL Basics
Show steps
Warming up on basic database and SQL concepts will help in retaining information.
Browse courses on
SQL
Show steps
-
Review tutorial on basic SQL syntax
-
Write practice queries to create, select, update, and delete data
Set up Azure SQL Server Database
Show steps
Creating and populating an Azure SQL Server database will provide a hands-on understanding of the concepts learned in the course.
Show steps
-
Create an Azure SQL Server instance
-
Create a database in the instance
-
Import data into the database using Data Migration Assistant
Write a summary of Query Store and its benefits
Show steps
Reflecting on the benefits and concepts of Query Store will reinforce understanding.
Browse courses on
Query Store
Show steps
-
Identify the key concepts of Query Store
-
Summarize the benefits of using Query Store
Three other activities
Expand to see all activities and additional details
Show all six activities
Follow a tutorial on creating a performance dashboard using Azure Data Studio
Show steps
Building a performance dashboard using Azure Data Studio will provide practical experience in applying the course concepts.
Browse courses on
Azure Data Studio
Show steps
-
Find a tutorial on creating a performance dashboard in Azure Data Studio
-
Follow the tutorial steps to create a dashboard
Attend a workshop on optimizing SQL Server performance
Show steps
Attending a workshop will provide additional insights and expertise on optimizing SQL Server performance, complementing the course material.
Browse courses on
Performance Tuning
Show steps
-
Research and identify a relevant workshop
-
Register and attend the workshop
Contribute to an open-source project related to SQL Server performance tuning
Show steps
Contributing to an open-source project will provide hands-on experience in practical applications of performance tuning.
Show steps
-
Identify an open-source project focused on SQL Server performance tuning
-
Review the project documentation and identify areas for contribution
-
Make code or documentation contributions to the project
Review SQL Basics
Show steps
Warming up on basic database and SQL concepts will help in retaining information.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review tutorial on basic SQL syntax
- Write practice queries to create, select, update, and delete data
Set up Azure SQL Server Database
Show steps
Creating and populating an Azure SQL Server database will provide a hands-on understanding of the concepts learned in the course.
Show steps
Show steps
Show steps
- Create an Azure SQL Server instance
- Create a database in the instance
- Import data into the database using Data Migration Assistant
Write a summary of Query Store and its benefits
Show steps
Reflecting on the benefits and concepts of Query Store will reinforce understanding.
Browse courses on
Query Store
Show steps
Show steps
Show steps
- Identify the key concepts of Query Store
- Summarize the benefits of using Query Store
Three other activities
Expand to see all activities and additional details
Show all six activities
Follow a tutorial on creating a performance dashboard using Azure Data Studio
Show steps
Building a performance dashboard using Azure Data Studio will provide practical experience in applying the course concepts.
Browse courses on
Azure Data Studio
Show steps
Show steps
Show steps
- Find a tutorial on creating a performance dashboard in Azure Data Studio
- Follow the tutorial steps to create a dashboard
Attend a workshop on optimizing SQL Server performance
Show steps
Attending a workshop will provide additional insights and expertise on optimizing SQL Server performance, complementing the course material.
Browse courses on
Performance Tuning
Show steps
Show steps
Show steps
- Research and identify a relevant workshop
- Register and attend the workshop
Contribute to an open-source project related to SQL Server performance tuning
Show steps
Contributing to an open-source project will provide hands-on experience in practical applications of performance tuning.
Show steps
Show steps
Show steps
- Identify an open-source project focused on SQL Server performance tuning
- Review the project documentation and identify areas for contribution
- Make code or documentation contributions to the project
Career center
Learners who complete Using Query Store in Azure will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
Database Administrators monitor, maintain, and troubleshoot database systems. This course can help you build a foundation in database management and optimization by teaching you how to use Azure SQL Server Query Store to identify and resolve performance issues. This course is especially relevant for Database Administrators who want to improve their skills in database performance tuning.
Data Analyst
Data Analyst
Data Analysts collect, analyze, and interpret data to help businesses make informed decisions. This course can help you build a foundation in data analysis by teaching you how to use Azure SQL Server Query Store to identify and resolve performance issues. This course is especially relevant for Data Analysts who want to improve their skills in data performance tuning.
Data Scientist
Data Scientist
Data Scientists develop and apply statistical and machine learning models to solve business problems. This course can help you build a foundation in data science by teaching you how to use Azure SQL Server Query Store to identify and resolve performance issues. This course is especially relevant for Data Scientists who want to improve their skills in data performance tuning.
Data Engineer
Data Engineer
Data Engineers design, build, and maintain data pipelines. This course can help you build a foundation in data engineering by teaching you how to use Azure SQL Server Query Store to identify and resolve performance issues. This course is especially relevant for Data Engineers who want to improve their skills in data performance tuning.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications. This course can help you build a foundation in software engineering by teaching you how to use Azure SQL Server Query Store to identify and resolve performance issues. This course is especially relevant for Software Engineers who want to improve their skills in database performance tuning.
Cloud Architect
Cloud Architect
Cloud Architects design and manage cloud computing solutions. This course can help you build a foundation in cloud architecture by teaching you how to use Azure SQL Server Query Store to identify and resolve performance issues. This course is especially relevant for Cloud Architects who want to improve their skills in database performance tuning.
IT Manager
IT Manager
IT Managers plan, implement, and manage IT systems. This course can help you build a foundation in IT management by teaching you how to use Azure SQL Server Query Store to identify and resolve performance issues. This course is especially relevant for IT Managers who want to improve their skills in database performance tuning.
Database Developer
Database Developer
Database Developers design and develop database systems. This course can help you build a foundation in database development by teaching you how to use Azure SQL Server Query Store to identify and resolve performance issues. This course is especially relevant for Database Developers who want to improve their skills in database performance tuning.
Business Analyst
Business Analyst
Business Analysts analyze business processes and recommend solutions to improve efficiency and effectiveness. This course can help you build a foundation in business analysis by teaching you how to use Azure SQL Server Query Store to identify and resolve performance issues. This course is especially relevant for Business Analysts who want to improve their skills in data performance tuning.
Project Manager
Project Manager
Project Managers plan, execute, and close projects. This course can help you build a foundation in project management by teaching you how to use Azure SQL Server Query Store to identify and resolve performance issues. This course is especially relevant for Project Managers who want to improve their skills in data performance tuning.
Product Manager
Product Manager
Product Managers manage the development and launch of products. This course can help you build a foundation in product management by teaching you how to use Azure SQL Server Query Store to identify and resolve performance issues. This course is especially relevant for Product Managers who want to improve their skills in data performance tuning.
Sales Manager
Sales Manager
Sales Managers lead and manage sales teams. This course may be useful for Sales Managers who want to improve their understanding of data performance tuning, but it is not directly relevant to the role.
Marketing Manager
Marketing Manager
Marketing Managers plan and execute marketing campaigns. This course may be useful for Marketing Managers who want to improve their understanding of data performance tuning, but it is not directly relevant to the role.
Financial Analyst
Financial Analyst
Financial Analysts analyze financial data to make investment recommendations. This course may be useful for Financial Analysts who want to improve their understanding of data performance tuning, but it is not directly relevant to the role.
Human Resources Manager
Human Resources Manager
Human Resources Managers manage the human resources department of an organization. This course is not relevant to the role of a Human Resources Manager.
For more career information including salaries, visit:
OpenCourser.com/course/gt16sf/using
Reading list
We've selected ten 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
Using Query Store in Azure.
Save
Comprehensive guide to using Azure SQL Query Store. It covers everything from how to create and configure Query Store to how to use it to identify and resolve performance issues.
Offers a comprehensive review of SQL performance and optimization that augments the specific Query Store topics discussed in this course.
Offers an in-depth look at Azure SQL Database, providing additional context and insights that can enhance your understanding of Query Store functionality.
Comprehensive guide to performance tuning for relational databases. It covers a wide range of topics, including query optimization, hardware optimization, and database design.
Comprehensive textbook on database systems. It covers a wide range of topics, including relational databases, query processing, and database design.
Provides a comprehensive overview of SQL performance. It covers a wide range of topics, including query optimization, performance monitoring, and best practices.
Provides a comprehensive guide to dimensional modeling for data warehousing. It covers a wide range of topics, including datawarehouse design. and performance tuning.
Provides a comprehensive guide to advanced SQL techniques. It covers a wide range of topics, including query optimization, data warehousing, and best practices.
Provides a comprehensive guide to database modeling and design. It covers a wide range of topics, including data modeling, database normalization, and best practices.
Provides a comprehensive guide to performance tuning for MySQL. It covers a wide range of topics, including performance monitoring, query optimization, and best practices.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/gt16sf/using
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
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