Course Overview:
In order to work with the Microsoft PaaS relational database options, as well as cloud, on-premises, and hybrid relational databases, students completing this course will have the knowledge and abilities necessary to operate a SQL Server database architecture. People that create apps that pull material from relational databases with a SQL foundation will also find it useful.
Prerequisite:
You should have subject matter expertise in building database solutions that are designed to support multiple workloads built with:
- SQL Server on-premises
- Azure SQL services
As a candidate for this certificate, you should have knowledge of and experience with:
- Azure SQL Database
- Azure SQL Managed Instance
- SQL Server on Azure Virtual Machines (Windows and Linux)
Audience:
A database administrator who manages on-premises and cloud databases built with SQL Server and Azure SQL services.
Topic 1: Data platform resources
- Azure SQL solutions
- Resources for scale and performance
- Migration strategy
Topic 2: Secure environment
- Database authentication and authorization
- Security for data at rest and data in transit
- Compliance controls for sensitive data
Topic 3: Database resources
- Resource activity and performance
- Query performance
- Database solutions for optimal performance
Topic 4: Automation of tasks
- SQL Server Agent jobs
- Deployment of database resources
- Database tasks in Azure
Topic 5: High availability and disaster recovery (HA/DR) environment
- HA/DR strategy for database solutions
- Backup and restore of a database
- HA/DR for database solutions
