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
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 1: 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
Module 2: Designing and Implementing Database Solutions for SQL Server and Microsoft Azure
After completing this module, 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 3: Manage, Design and Implement Database Security
This module explains how to setup security for an on-premises or Azure database
Lessons
Design and Implement SQL Server database security
Design and Implement Azure SQL Database security
Review
Lab 1: Manage, Design and Implement Database Security
Implement SQL Server database security
Implement Azure SQL Database security
Module 4: Manage, Design and Implement Database Security
After completing this module, students will be able to:
Configure SQL Server database security
Configure Azure SQL Database security
Module 5: Design for High-Availability, Disaster Recovery and Scalability
This module explains how to configure database solutions for High-Availability, Disaster Recovery and Scalability.
Lessons
Design and Implement High-Availability Solutions
Design and Implement Disaster Recovery Solutions
Design and Implement Scalability Solutions
Review
Lab 1: Create Microsoft Azure Data Objects using Python
Implement a High-Availability Solution
Implement a Disaster Recovery Solution
Implement a Scalability Solution
After completing this module, students will be able to:
Configure a High-Availability solution
Configure a Disaster Recovery Solution
Configure a Scalability Solution
Module 6: Monitor and Troubleshoot Database Implementations in Azure
This module explains how to monitor and troubleshoot database implementations.
Lessons
Monitor and Troubleshoot SQL Server VMs on Azure
Monitor and Troubleshoot Azure SQL Databases
Review
Lab 1: Create Microsoft Azure Data Processes using Python
Monitor and Troubleshoot SQL Server
Monitor and Troubleshoot Azure SQL Databases
Module 7: Create Microsoft Azure Data Processes using Python
After completing this module, students will be able to:
Monitor and Troubleshoot SQL Servers
Monitor and Troubleshoot Azure SQL Databases