Plan and Implement Data Platform Resources-Course Introduction and Working with Azure Virtual Machines
Course Outline
Week Outline
Course Introduction
()
The different database offerings on Azure
()
Lab - Deploying an Azure virtual machine
()
Lab - Installing Microsoft SQL Server on the virtual machine
()
Lab - Connecting to Microsoft SQL Server
()
Lab - Using Azure Marketplace - SQL Server
()
Plan and Implement Data Platform Resources-The Azure SQL Database
The Azure SQL Database offering
()
Azure SQL Database - Pricing tiers
()
Lab - Deploying Azure SQL Database
()
Lab - Deploying a sample additional Azure SQL database
()
Scalability for different database offerings
()
Lab - Azure SQL Database Managed Instances - Setup
()
Lab - Azure SQL Database Managed Instances - Connecting to the Instance
()
Lab - Azure SQL Elastic Pool- Part 1
()
Lab - Azure SQL Elastic Pool- Part 2
()
SQL Server on Azure VM - Design for Performance
()
Database Partitioning Techniques
()
Plan and Implement Data Platform Resources-Azure SQL Data Sync and Database Migration
Patches for IaaS deployments
()
Hybrid deployments for SQL Databases
()
Lab - Azure SQL Data Sync
()
Lab - Database Migration - Evaluate requirements
()
Lab - Database Migration - Offline Migration
()
Database Migration - Online Migration
()
Implement a secure environment-Azure Active Directory
Week Outline
Azure Active Directory
()
Lab - Configuring Azure AD Authentication
()
Lab - Creating Azure AD Users in Azure SQL database
()
Implement a secure environment-Configuring SQL Security
Lab - Configuring security for SQL users
()
Azure SQL Database - Transparent Data Encryption
()
Lab - Azure SQL Database - Dynamic data masking
()
Lab - Azure key vault
()
Lab - Azure SQL Database - Encryption
()
Lab - Virtual Machine disk encryption
()
Lab - Azure SQL Database Firewalls
()
Lab - Azure SQL - Vulnerability Assessment
()
Lab - Azure SQL - Database classification
()
Lab - Azure SQL Database - Auditing
()
Monitor and optimize operational resources in Azure SQL-Azure Monitor
Week Outline
Lab - Azure Monitor - Azure SQL Database Metrics
()
Lab - Azure Monitor - Set up alerts
()
Monitor and optimize operational resources in Azure SQL-Implement a secure environment
Lab - Azure SQL Database - Intelligent Insights
()
Azure SQL Database - Automatic Tuning
()
Lab - Elastic Job Agent - Setup
()
Lab - Elastic Job Agent - Implementation
()
Lab - Using the Query Store
()
Using Resource Governance
()
Lab - Understanding the Execution Plan
()
Monitor and optimize operational resources in Azure SQL-Database Normalization and Table Indexes
Database Normalization
()
Tables Indexes
()
Lab - Using Tables Indexes
()
Monitor and optimize operational resources in Azure SQL-Data Compression
Lab - Data Compression - Setup
()
Lab - Data Compression - Implementation
()
Lab - Dynamic Management Views
()
Plan Task Automation, Implement High Availability and Disaster Recovery (HA/DR) Environment-Perform automation of tasks
Week outline
Lab - SQL Server on Azure VM - SQL Server Agent jobs- Part 1
()
Lab - SQL Server on Azure VM - SQL Server Agent jobs-Part 2
()
Lab - SQL Server on Azure VM - SQL Server Agent alerts
()
Lab - Azure Policies
()
Lab - Azure Resource Manager templates-Part 1
()
Lab - Azure Resource Manager templates-Part 2
()
Plan Task Automation, Implement High Availability and Disaster Recovery (HA/DR) Environment-Plan and Implement a High Availability and Disaster Recovery (HA/DR) Environment
High Availability and Disaster Recovery
()
Azure SQL Database backups
()
Lab - Azure SQL Database - Point in time restore
()
Azure SQL Database - Long term retention
()
Lab - Azure SQL Database - Replication
()
Lab - Azure SQL Database - Auto-Failover Groups
()
Lab - Availability Groups - Setup
()
Lab - Availability Groups - Implementation
()
Perform Administration by Using T-SQL-Understanding database backups
Week Outline
Understanding database backups
()
Lab - SQL Database - Full backups and restore
()
Lab - SQL Database - Transaction Log Backups
()
Perform Administration by Using T-SQL-Database Consistency checks and Database Roles
Lab - SQL Database - Database Consistency checks
()
Lab - SQL Database - Database Roles
()
SQL Database - Database Growth
()
Key Takeaways of the Course