Overview
This three-day instructor-led course is intended for data professionals who want to design and implement database solutions in SQL Server and on Microsoft Azure. Security, Availability, Disaster Recovery, Scalability, Monitoring and Troubleshooting options will also be demonstrated.
Prerequisites
Students are required to have experience working with databases and using SQL.
Who Should Attend?
This course is intended for experienced data professionals who design and implement on-premises and Microsoft Azure data solutions.
Course Outline
This module explains how to design a database solution for SQL Server and Microsoft Azure databases.
- 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 PostgreSQL database solution
This module explains how to setup security for an on-premises or Azure database.
- Design and Implement SQL Server database security
- Design and Implement Azure SQL Database security
- Review
Lab: Manage, Design and Implement Database Security
- Implement SQL Server database security
- Implement Azure SQL Database security
This module explains how to configure database solutions for High-Availability, Disaster Recovery and Scalability.
- Design and Implement High-Availability Solutions
- Design and Implement Disaster Recovery Solutions
- Design and Implement Scalability Solutions
- Review
Lab: Create Microsoft Azure Data Objects using Python
- Implement a High-Availability Solution
- Implement a Disaster Recovery Solution
- Implement a Scalability Solution
This module explains how to monitor and troubleshoot database implementations.
- Monitor and Troubleshoot SQL Server VMs on Azure
- Monitor and Troubleshoot Azure SQL Databases
- Review
Lab: Create Microsoft Azure Data Processes using Python
- Monitor and Troubleshooting SQL Server
- Monitor and Troubleshoot Azure SQL Databases
