Configure databases for optimal performance
|
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.
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.
User Reviews
Be the first to review “Configure databases for optimal performance”
Related Products
Data Scientist: Inference Specialist
Inference Data Scientists run A/B tests, do root-cause analysis, and conduct experiments. They use Python, SQL, and R to analyze data.
Analyze Data with R
Use R to process, analyze, and visualize data.
Introduction to Data Analytics
Get introduced to data analytics methods for extracting insights from data.
Data Scientist: Analytics Specialist
Data Analysts and Analytics Data Scientists use Python and SQL to query, analyze, and visualize data — and communicate findings.
Data Science Foundations
Learn to clean, analyze, and visualize data with Python and SQL.
Data Analysis with R
Learn how to analyze data using R programming, including statistical modeling and visualization techniques.
There are no reviews yet.