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
What's inside
Syllabus
Project Overview
Here you will describe what the project is about. It should give an overview of what the learner will achieve by completing this project.
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save Using Query Store in Azure to your list so you can find it easily later:
Save
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 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
Here are nine courses similar to
Using Query Store in Azure.
Implement a Relational database in Azure SQL database
OpenCourser.com/course/shomd5/implement
Implement a Relational database in Azure SQL database
Query Data by Using Azure Synapse Analytics - DP-500
OpenCourser.com/course/31djx1/query
Query Data by Using Azure Synapse Analytics - DP-500
Kusto Query Language: Beginning Operators
OpenCourser.com/course/3fazm8/kusto
Kusto Query Language: Beginning Operators
Understanding Azure Stream Analytics
OpenCourser.com/course/y4mm6o/understanding
Understanding Azure Stream Analytics
Improving Azure Data Lake Performance
OpenCourser.com/course/f1irbo/improving
Improving Azure Data Lake Performance
Azure SQL Database: Diagnosing Performance Issues with DMVs
OpenCourser.com/course/qdy137/azure
Azure SQL Database: Diagnosing Performance Issues with...
Monitoring and Optimizing Queries in Databricks SQL
OpenCourser.com/course/4ol0s1/monitoring
Monitoring and Optimizing Queries in Databricks SQL
DP-203: Processing in Azure Using Streaming Solutions
OpenCourser.com/course/53e3se/dp
DP-203: Processing in Azure Using Streaming Solutions
Complex Retrieval Queries in MySQL Workbench
OpenCourser.com/course/u2amoi/complex
Complex Retrieval Queries in MySQL Workbench
Effort
1 hour
Level
Intermediate
Via
Coursera
Institution
Coursera Project Network
Instructor
Dean Savovic
Language
English
Good to know
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
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