Course Description
Administering Microsoft Azure SQL Solutions provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises, and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
Learning Objectives
- Prepare to maintain SQL databases on Azure
- Deploy IaaS solutions with Azure SQL
- Deploy PaaS solutions with Azure SQL
- Evaluate strategies for migrating to Azure SQL
- Migrate SQL workloads to Azure SQL Databases
- Migrate SQL workloads to Azure Managed Instances
- Configure database authentication and authorization
- Protect data in transit and at rest
- Implement compliance controls for sensitive data
- Describe performance monitoring
- Configure SQL Server resources for optimal performance
- Configure databases for optimal performance
- Explore query performance optimization
- Evaluate performance improvements
- Explore performance-based design
- Automate deployment of database resources
- Create and manage SQL Agent jobs
- Manage Azure PaaS tasks using automation
- Describe high availability and disaster recovery strategies
- Explore IaaS and PaaS solutions for high availability and disaster recovery
- Back up and restore databases
Framework Connections
Feedback
If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.