Skip to content
ictcLogo
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Menu
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Microsoft

Course 55247-A: Designing and Implementing Cloud Data Platform Solutions

  • Duration: 3 days
  • Job Role: Developer

Course 55247-A: Designing and Implementing Cloud Data Platform Solutions

Share This Learning Path

Need more info? Contact us

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.

Audience Profile

This course is intended for experienced data professionals who design and implement on-premises and Microsoft Azure data solutions.

Prerequisites

  • Experience working with databases.
  • Experience using SQL.

Course outline

Module 1: Designing and Implementing Database Solutions for SQL Server and Microsoft Azure

Module Overview

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 Sessions

Designing and Implementing Database Solutions for SQL Server and Microsoft Azure

Lab Lessons

Implement a Hybrid SQL Server solution
Implement an Azure SQL Database solution
Implement a MySQL database solution
Implement a PostgreSQL database solution

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 2: Manage, Design and Implement Database Security

Module Overview

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 Sessions

Manage, Design and Implement Database Security

Lab Lessons

Implement SQL Server database security
Implement Azure SQL Database security

After completing this module, 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

Module Overview

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 Sessions

Create Microsoft Azure Data Objects using Python

Lab Lessons

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 4: Monitor and Troubleshoot Database Implementations in Azure

Module Overview

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 Sessions

Create Microsoft Azure Data Processes using Python

Lab Lessons

Monitor and Troubleshoot SQL Server
Monitor and Troubleshoot Azure SQL Databases

After completing this module, students will be able to:

Monitor and Troubleshoot SQL Servers.
Monitor and Troubleshoot Azure SQL Databases.

Book Your Seat​

Find Learning Paths​

  • Search Paths

  • Vendors

Latest Learning Paths​

Microsoft

Course MB-920T00-A: Microsoft Dynamics 365 Fundamentals (ERP)

  • Dynamics-365
  • Beginner

Microsoft

Course PL-600T00-A: Power Platform Solution Architect

  • Power-Platform
  • Advanced

Microsoft

Course 20703-1-B: Administering System Center Configuration Manager

  • Windows
  • Advanced

Join our community of certified professionals

Sign Up to our newsletter, and stay always up to date with latest IT certifications

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Facebook Linkedin

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Explore

Contact Us

  • +30 211 500 29 00
  • info@ictc.gr
  • Lagoumitzi 24, Kallithea
ictcLogo

International Computer Training Center

  • Copyright reserved to ICTC
  • Proudly Crafted by GTP Works

Copyright reserved to ICTC. Proudly Crafted by GTP Works

Choose how to get more info...

Give as a call

211 500 2 900

Let us, call you

Send us an email