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
Business Intelligence Analytics
Gain insights into business intelligence tools and analytics techniques to optimize decision-making.
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.
Discovering Predictive Analytics with Alteryx
Explore predictive analytics techniques and tools using Alteryx to forecast future trends based on historical data.
Introduction to Data Analysis with Pandas and NumPy
Learn to use Pandas and NumPy libraries for data manipulation and analysis in Python.
Introduction to Data
Learn the fundamentals of data collection, analysis, and interpretation.
Real-Time Analytics with Apache Storm
Study the use of Apache Storm for processing real-time data streams and generating insights on-the-fly.
There are no reviews yet.