Designing and Implementing Cloud Data Platform Solutions (M55247)
Designing and Implementing Cloud Data Platform Solutions (M55247) Course Details:
This 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.
Call (919) 283-1674 to get a class scheduled online or in your area!
Module 1: Designing and Implementing Database Solutions for SQL Server and Microsoft Azure
- 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
Module 2: Manage, Design and Implement Database Security
- Design and Implement SQL Server database security
- Design and Implement Azure SQL Database security
- Review
Module 3: Design 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
Module 4: Monitor and Troubleshoot Database Implementations in Azure
- Monitor and Troubleshoot SQL Server VMs on Azure
- Monitor and Troubleshoot Azure SQL Databases
- Review
*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
- 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
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
Lab 2: Manage, Design and Implement Database Security
- Implement SQL Server database security
- Implement Azure SQL Database security
Lab 3: Create Microsoft Azure Data Objects using Python
- Implement a High-Availability Solution
- Implement a Disaster Recovery Solution
- Implement a Scalability Solution
Lab 4: Create Microsoft Azure Data Processes using Python
- Monitor and Troubleshoot SQL Server
- Monitor and Troubleshoot Azure SQL Databases
- Experience working with databases
- Experience using SQL
This course is intended for experienced data professionals who design and implement on-premises and Microsoft Azure data solutions.