Module 1: Designing and Implementing Database Solutions for SQL Server and Microsoft Azure
This module explains how to design a database solution for SQL Server and Microsoft Azure databases.
Lessons for module 1
- Design and Implement Hybrid SQL Server solutions
- Design and Implement Azure SQL Database solutions
- Design and Implement MySQL and PostgreSQL database solutions in Azure
- Review
Lab : Designing and Implementing Database Solutions for SQL Server and Microsoft Azure
- Implement a Hybrid SQL Server solution
- Implement an Azure SQL Database solution
- Implement a MySQL database solution
- Implement a PostgreSQL database solution
After completing module 1, students will be able to:
- Install and configure SQL Server on an Azure VM
- Install and configure Azure databases
- Install and configure MySQL and PostgreSQL databases
Module 2: Manage, Design and Implement Database Security
This module explains how to setup security for an on-premises or Azure database.
Lessons for module 2
- Design and Implement SQL Server database security
- Design and Implement Azure SQL Database security
Lab : Manage, Design and Implement Database Security
- Implement SQL Server database security
- Implement Azure SQL Database security
After completing module 2, students will be able to:
- Configure SQL Server database security
- Configure Azure SQL Database security
Module 3: Design for High-Availability, Disaster Recovery and Scalability
This module explains how to configure database solutions for High-Availability, Disaster Recovery and Scalability.
Lessons for module 3
- Design and Implement High-Availability Solutions
- Design and Implement Disaster Recovery Solutions
- Design and Implement Scalability Solutions
Lab : Create Microsoft Azure Data Objects using Python
- Implement a High-Availability Solution
- Implement a Disaster Recovery Solution
- Implement a Scalability Solution
After completing module 3, students will be able to:
- Configure a High-Availability solution
- Configure a Disaster Recovery Solution
- Configure a Scalability Solution
Module 4: Monitor and Troubleshoot Database Implementations in Azure
This module explains how to monitor and troubleshoot database implementations.
Lessons for module 4
- Monitor and Troubleshoot SQL Server VMs on Azure
- Monitor and Troubleshoot Azure SQL Databases
Lab : Create Microsoft Azure Data Processes using Python
- Monitor and Troubleshoot SQL Server
After completing module 4, students will be able to:
- Monitor and Troubleshoot SQL Servers
Additional Reading
- Courses 552241A and 552242A
