Configure databases for performance

Configure databases for performance

Control database-level configuration options. Explore Intelligent Query Processing. Configure Open Source databases for optimum performance.

Data Analyst
Database Administrator
Data Engineer
Azure
SQL Server
SQL Database

Module Objectives

After completing this module, you will be able to:

  • Configure Database Scoped Configuration Options
  • Understand the features of Intelligent Query Processing
  • Explore performance monitoring options in Azure Database for PostgreSQL and MySQL

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.
  • Ability to set options for a SQL Server database.