Skip to main content
Administering Microsoft Azure SQL Solutions
0%
Previous
Course data
Module 1: 1. Prepare to maintain SQL databases on Azure
1.1.1 Introduction: Prepare to maintain SQL databases on Azure
1.1.2 Describe Microsoft Intelligent Data Platform roles
1.1.3 Understand SQL Server in an Azure virtual machine
1.1.4 Design Azure SQL Database for cloud-native applications
1.1.5 Explore Azure SQL Database Managed Instance
Module 2 : 1. Deploy IaaS solutions with Azure SQL
2.1.1 Introduction to deploying SQL Server
2.1.2 Explain IaaS options to deploy SQL Server in Azure
2.1.3 Understand hybrid scenarios
2.1.4 Explore performance and security
2.1.5 Explain high availability and disaster recovery options
Module 2: 2.Deploy PaaS solutions with Azure SQL
2.2.1 Introduction
2.2.2 Explain PaaS options for deploying SQL Server in Azure
2.2.3 Explore single SQL database
2.2.4 Deploy SQL database elastic pool
2.2.5 Understand SQL database hyperscale
2.2.6 Examine SQL managed instance
2.2.7 Describe SQL Edge
Module 2: 3. Evaluate strategies for migrating to Azure SQL
2.3.1 Introduction
2.3.2 Understand compatibility level
2.3.3 Understand Azure preview features
2.3.4 Describe Azure database migration options
Module 2: 4. Migrate SQL Server workloads to Azure SQL Database
2.4.1 Introduction to migrating SQL Server workloads to Azure SQL Database.
2.4.2 Choose the right Azure SQL Database feature
2.4.3 Use Azure SQL migration extension to migrate to Azure SQL Database
2.4.4 Explore Data Migration Assistant to migrate to Azure SQL Database
2.4.5 Migrate to Azure SQL Database using BACPAC
2.4.6 Use an online method to migrate to Azure SQL Database
2.4.7 Move data to Azure SQL Database
Module 2: 5. Migrate SQL Server workloads to Azure SQL Managed Instance
2.5.1 Introduction Migrate SQL server workloads to Azure SQL
2.5.2 Evaluate Migration Scenarios
2.5.3 Introduction to Log Replay Service (LRS)
2.5.4 Introduction to Azure SQL Managed Instance Link Feature
2.5.5 Move Data to SQL Managed Instance
Module 3 : 1. Configure database authentication and authorization
3.1.1 Retrieving data. Wait a few seconds and try to cut or copy again.
3.1.2 Describe Active Directory and Microsoft Entra ID
3.1.3 Describe authentication and identities
3.1.4 Describe Security Principals
3.1.5 Describe database and object permissions
3.1.6 Identify authentication and authorization failures
Module 3: 2. Protect data in-transit and at rest
3.2.1 Protect data in-transit and at rest Introduction
3.2.2 Explore Transparent Data Encryption
3.2.3 Configure server and database firewall rules
3.2.4 Explain object encryption and secure enclaves
3.2.5 Enable encrypted connections
3.2.6 Describing SQL Injection
3.2.7 Understand Azure Key Vault
Module 3: - 3. Implement compliance controls for sensitive data
3.3.1 Introduction to implementing compliance controls for sensitive data
3.3.2 Explore data classification
3.3.3 Explore server and database audit
3.3.4 Implement Dynamic Data Masking
3.3.5 Understand Microsoft Defender for SQL
3.3.6 Explore Azure SQL Database Ledger
3.3.7 Implement Azure Purview.
Module 4: 1. Describe performance monitoring
4.1.1 Introduction to Performance Monitoring in Azure SQL
4.1.2 Performance Monitoring Tools in Azure
4.1.3 Critical Performance Metrics in Azure
4.1.4 Introduction to Baseline Metrics
4.1.5 Exploring Extended Events
4.1.6 Exploring Extended Events
4.1.7 Query Performance Insight in Azure SQL
Module 4: 2. Configure SQL Server resources for optimal performance
4.2.1 Introduction to Azure and SQL Server
4.2.2 Overview of Azure Storage Options
4.2.3 Virtual Machine Size Options
4.2.4 Optimize database storage
4.2.5 Resource Governor Overview
Module 4: 3. Configure databases for optimal performance
4.3.1 Introduction to intelligent query processing and performance maintenance in SQL Serven
4.3.2 Importance of Indexes and Statistics
4.3.3 Overview of Configuration Options
4.3.4 Introduction to Automatic Tuning
4.3.5 Introduction to Intelligent Query Processing
Module 5: 1. Explore query performance optimization
5.1.1 Exploring query performance optimization
5.1.2 Introduction to Query Optimizers
5.1.3 Understanding Estimated and Actual Plans
5.1.4 Dynamic Management Objects
5.1.5 Introduction to Query Store
5.1.6 Identifying the Problematic Query
5.1.7 Understanding Locking in SQL Server
Module 5: 2. Explore performance-based design
5.2.1 Introduction to Database Design
5.2.2 When to Use Denormalization
5.2.3 Importance of Choosing Appropriate Data Types
5.2.4 Understanding SQL Server Indexes
Module 5: 3. Evaluate performance improvements
5.3.1 Introduction to Intelligent Query Processing
5.3.2 Introduction to Wait Statistics
5.3.3 Index Tuning
5.3.4 Query Hints
Module 6: 1.Automate deployment of database resources
6.1.1 Introduction to Azure Deployment Models and Tools
6.1.2 Describe Deployment Models in Azure
6.1.3 Automate Deployment with Azure Resource Manager Templates and Bicep
6.1.4 Automate Deployment Using PowerShell
Module 6: 2. Create and manage SQL Agent jobs
6.2.1 Introduction to Database Maintenance in SQL Server and Azure
6.2.2 Create a SQL Server maintenance plan
6.2.3 Introduction to Task Status Notifications
Module 6: 3.Manage Azure Paas tasks using automation
6.3.1 Move Data to SQL Managed Instance
6.3.2 Introduction to Azure Automation
6.3.3 Introduction to Build an automation runbook
6.3.4 Introduction to Azure Logic Apps
6.3.5 Introduction to Monitor Automated Tasks
Module 7: - 1.High availability & disaster recovery strategies
7.1.1 Introduction to HADR Database Platform Solutions
7.1.2 Introduction to High Availability and Disaster Recovery Options for Azure VMS
7.1.3 Overview of High Availability Options
7.1.4 Introduction to PaaS Availability
7.1.5 Overview of SQL Server HADR Architectures
7.1.6 Introduction to Hybrid Solutions
Module 7: 2.Explore IaaS & PaaS solutions for high availability & disaster recovery
7.2.1 Introduction to IaaS Database Deployment in Azure
7.2.2 Introduction to Failover Clusters in Windows Server
7.2.3 Configuring Always-On Availability Groups
7.2.4 Introduction to Temporal Tables
7.2.5 What is Active Geo-RepIication?
7.2.6 Auto-Failover Groups
Module 7: 3.Back up & restore database
7.3.1 Introduction to Backup and Recovery
7.3.2 Back up a SQL Server Virtual Machine
7.3.3 Introduction to Azure SQL Database Backup and Restore
Next
Side panel
Categories
All categories
AI CERTs
AI CERTs - LAN
AICERTs - Extended E-Learni...
AICERTs - Extended E-Learni...
AI CERTs- Spanish
MS ELearning
Other Category
Other Category - LAN
AI Feature Course Cat
LAN - Extended E Learning 5...
Home
Search
Search
Search
Search
Close
Toggle search input
English (en)
Azərbaycanca (az)
English (en)
Español - Argentina (es_ar)
Español - Colombia (es_co)
Español - Internacional (es)
Español - México (es_mx_kids)
Español - México (es_mx)
Español - Venezuela (es_ve)
Español (es_wp)
Log in
Email
Email
Password
Password
Forgot your password?
Log in
Categories
Collapse
Expand
All categories
AI CERTs
AI CERTs - LAN
AICERTs - Extended E-Learni...
AICERTs - Extended E-Learni...
AI CERTs- Spanish
MS ELearning
Other Category
Other Category - LAN
AI Feature Course Cat
LAN - Extended E Learning 5...
Home
Course info
Course
Q&A
Administering Microsoft Azure SQL Solutions
