Prerequisite: None
Course Duration: 30 hours
5 days training
9am - 3pm
Course Schedule: Every Saturday
Every Sunday
Equipment: Real server computer
10k RPM SAs Drive
Fast internet
Inclusion (face-to-face training): Lunch Meal
Certificate of completion
Training handout
Review material for exam
Free flowing coffee
Inclusion (Online Training): Certificate of completion
Training handout (soft copy)
Review material for exam
Deploy a Microsoft Azure SQL database
•Choose a service tier
•Create servers and databases
•Create a sysadmin account
•Configure elastic pools
Plan for SQL Server installation
•Plan for an IaaS or on-premises deployment
•Select the appropriate size for a virtual machine
•Plan storage pools based on performance requirements
•Evaluate best practices for installation
•Design a storage layout for a SQL Server virtual machine
Deploy SQL Server instances
•Deploy a SQL Server instance in IaaS and on-premises
•Manually install SQL Server on an Azure virtual machine
•Provision an Azure virtual machine to host a SQL Server instance
•Automate the deployment of SQL Server databases
•Deploy SQL Server by using templates
Deploy SQL Server databases to Azure virtual machines
•Migrate an on-premises SQL Server database to an Azure virtual machine
•Generate benchmark data for performance needs
•Perform performance tuning on Azure IaaS
•Support availability sets in Azure
Configure secure access to Microsoft Azure SQL databases
•Configure firewall rules
•Configure Always Encrypted for Azure SQL Database
•Configure celllevel encryption
•Configure dynamic data masking
•Configure transparent data encryption (TDE)
Configure SQL Server performance settings
•Configure database performance settings
•Configure max server memory
•Configure the database scope
•Configure operators and alerts
Manage SQL Server instances
•Create databases
•Manage files and file groups
•Manage system database files
•Configure tempdb
Manage SQL Storage
•Manage SMB file shares
•Manage stretch databases
•Configure Azure storage
•Change service tiers
•Review wait statistics
•Manage storage pools
•Recover from failed storage
Perform database maintenance
•Monitor DMVs
•Maintain indexes
•Automate maintenance tasks
•Update statistics
•Verify database integrity
•Recover from database corruption