We may earn an affiliate commission when you visit our partners.
Course image
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.

Read more

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.

Enroll now

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

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

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
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
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
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
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
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
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

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Managers manage the human resources department of an organization. This course is not relevant to the role of a Human Resources Manager.

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.
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.
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.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Using Query Store in Azure.
Implement a Relational database in Azure SQL database
Query Data by Using Azure Synapse Analytics - DP-500
Kusto Query Language: Beginning Operators
Understanding Azure Stream Analytics
Improving Azure Data Lake Performance
Azure SQL Database: Diagnosing Performance Issues with...
Monitoring and Optimizing Queries in Databricks SQL
DP-203: Processing in Azure Using Streaming Solutions
Complex Retrieval Queries in MySQL Workbench
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