Configure databases for optimal performance

Data Analyst
Data Engineer
Database Administrator
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


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