Configure databases for optimal performance

  • Module
  • 8 Units
Intermediate
Data Analyst
Data Engineer
Database Administrator
Azure
Azure SQL Database
SQL Server

Implement tasks for both IaaS and PaaS to maintain indexes, and statistics. Explore the automatic tuning features of Azure SQL Database. Control database-level configuration options. Explore Intelligent Query Processing.

Learning objectives

After completing this module, you will be able to:

  • Understand database scoped configuration options
  • Understand maintenance tasks related to indexing and statistics
  • Understand the features of Intelligent Query Processing (IQP)
  • Explore the automatic tuning feature in Azure

Prerequisites

  • Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
  • Experience creating and configuring resources using the Azure portal.
  • Basic understanding of structure and usage of SQL Server indexes.

Get started with Azure

Choose the Azure account that's right for you. Pay as you go or try Azure free for up to 30 days. Sign up.