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

Course Modality

Instructor-led (classroom)

Course Level

Intermediate

Course Time

3 days

Course Language

English

Course 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

  • Experience working with databases
  • Experience using SQL

Intended Audience

Students for this course are just starting their Information Technology (IT) careers or want to change careers into Windows Server technologies. This fundamental knowledge and skills can be used by home computer users, small business owners, academic students, information workers, technical managers, help desk technicians, or students who want to cross-train from another technology.

This course is a first step in preparing for a job in IT or as a prerequisite training, before you start the Microsoft Certified System Administrator (MCSA) training and certification path.

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

After completing this course, students will be able to:

  •  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

Get In Touch

Course Curriculum

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 : 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

 

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

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

  • 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

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 : 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

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 : Create Microsoft Azure Data Processes using Python

  • 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

Reviews

TDTL-arrow
Ask Anything
AI Chatbot Avatar

Kindly fill out all the details..

[glt language="Arabic" label="Arabic" image="yes" text="yes" image_size="24"]
[glt language="English" label="English" image="yes" text="yes" image_size="24"]
[glt language="French" label="French" image="yes" text="yes" image_size="24"]
[glt language="German" label="German" image="yes" text="yes" image_size="24"]
[glt language="Hindi" label="Hindi" image="yes" text="yes" image_size="24"]
[glt language="Marathi" label="Marathi" image="yes" text="yes" image_size="24"]
[glt language="Spanish" label="Spanish" image="yes" text="yes" image_size="24"]

Microsoft Power Platform App Maker

Designing & Implementing Azure AI Solution

Microsoft Azure Administrator

Developing Solutions For Microsoft Azure

Microsoft Azure Architect Design Exam

Implementing Azure Data Solution

Administering Relational Databases On Microsoft Azure