Official websites use .gov
A .gov website belongs to an official government organization in the United States.
Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.
Administering Microsoft Azure SQL Solutions
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.
Course Overview
Successful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies. Specifically:
- Working with, maintaining, and developing with SQL Server
- Experience with Azure, such as deploying and managing resources
At a minimum, you should know the information in the following online training before attending the course:
- AZ-900 Azure Fundamentals
- DP-900 Azure Data Fundamentals
8890 McGaw Road
Suite 200
Columbia, MD 21045
625 W Adams Street
Chicago, IL 60661
5908 Headquarters Drive
Suite 400
Plano, TX 75024
201 N Franklin St
Floor 37
Tampa, FL 33602
40 E. Rio Salado Parkway
Suite 200
Tempe, AZ 85281
- Providers
- Courses
- Course and Provider Quantity
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
The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):
Competency Areas
Feedback
If you would like to provide feedback on this course, please e-mail the NICCS team at NICCS@mail.cisa.dhs.gov. Please keep in mind that NICCS does not own this course or accept payment for course entry. If you have questions related to the details of this course, such as cost, prerequisites, how to register, etc., please contact the course training provider directly. You can find course training provider contact information by following the link that says “Visit course page for more information...” on this page.