55247 Designing a Data Platform Solution
This three-day instructor-led course is intended for data professionals who want to design and implement Microsoft Azure solutions for SQL Server, Azure SQL Database, MySQL and PostgreSQL. Microsoft Azure subscriptions will be issued to each student so they can practice migration, security, availability, disaster Recovery, scalability, monitoring and troubleshooting solutions
Utbildningsformer
Remote
Längd
3 dagar
Pris
26950 kr
Audience Profile
This course is intended for experienced data professionals who design and implement on-premises and Microsoft Azure data solutions.
At Course Completion
Create SQL Server and Microsoft Azure data solutions
Create Security solutions for on-premises and cloud databases
Configure High-Availability, Disaster Recovery and Scalability options for databases
Monitor, Manage and Automate database solutions
Course Outline: Designing a Data Platform Solution
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
- 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
- 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
- Implement a High-Availability Solution
- Implement a Disaster Recovery Solution
- Implement a Scalability Solution
- 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
- 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