Description

This course is designed for data professionals interested in designing and implementing database solutions in SQL Server and on Microsoft Azure. Options like Disaster Recovery, Security, Scalability, Availability, Monitoring and Troubleshooting will also be demonstrated.

 

 

Radiant Techlearning offers Designing and Implementing Cloud Data Platform Solutions training program in Classroom & Virtual Instructor Led / online mode.

 

 

Duration: 3 Days 

 

 

Learning Objectives

This course will help professionals in:

  • Creating SQL Server and Microsoft Azure data solutions
  • Creating Security solutions for on-premises and cloud databases
  • Configuring High-Availability, Disaster Recovery and Scalability options for databases
  • Monitoring, Managing and Automating database solutions

Pre-requisites

  • Experience working with databases
  • Experience using SQL

 

Audience profile

This course is designed for data professionals who are experienced in designing and implementing on-premises and Microsoft Azure data solutions.

Course Content

Module 1: Design and Implement Database Solutions for Microsoft Azure and SQL Server

This section discusses about 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

 

  • This module will enable professionals 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

This section discusses about 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

 

  • This module will enable professionals to:
    • Configure SQL Server database security
    • Configure Azure SQL Database security

 

Module 3: High-Availability, Disaster Recovery and Scalability Design

This section discusses about 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 : Using Python for creation of Microsoft Azure Data Objects
    • Implement a High-Availability Solution
    • Implement a Disaster Recovery Solution
    • Implement a Scalability Solution

 

  • This module will enable professionals to:
    • Configure a High-Availability solution
    • Configure a Disaster Recovery Solution
    • Configure a Scalability Solution

 

Module 4: Database Implementations in Azure: Monitor and Troubleshoot 

This section discusses about 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

 

  • This module will enable professionals to:
    • Monitor and Troubleshoot SQL Servers
    • Monitor and Troubleshoot Azure SQL Databases

FAQs

Q: What is a cloud data platform?

 

A: Designing Cloud Data Platforms lays out the principles of a well-designed platform that uses the scalable resources of the public cloud to manage all of an organization’s data, and present it as useful business insights.

 

Q: What is Enterprise Data Cloud?

 

A: It delivers powerful, self-service analytics across hybrid and multi-cloud environments with the granular security and governance policies that IT leaders demand. CDP is basically a new approach to enterprise data which mainly delivers a full range of analytic capabilities from the Edge to AI.

 

Q: What is a modern data platform?

 

A: A modern data platform should transparently orchestrate and automate the lifecycle, copy management, compliance and governance of data across infrastructures, application types, formats, containers, locations, even SaaS. A data platform is mainly a natural software layer which is used to control the underlying storage resources it uses.

 

Q: How do I build a data analytics platform?

 

A: If you want to build a high-performing Big Data Analytics platform in the cloud, start with assessing the expectations of the business users. Identify who all need access to the data, how quickly do they expect their insights, and what tools do they prefer to use for analytics.

 

Q: What is the schedule of the training program?

 

A: Radiant Techlearning offers training program on the weekday, weekend and a combination of weekdays and weekends. You can always choose the schedule that best suits to your need. 

 

Q: When the training would be conducted?

 

A: Once we receive your enrollment request, we will share the enrollment details with you to  select and complete the enrollment process. 

You can always email us on the below email address (whichever applicable) to know the upcoming schedule for a specific technology training program. 

Individual:  training@radianttechlearning.com  

Corporate: Corporate@radiantechlearning.com 

 

Q: Will I get course completion certificate?

 

A: The course completion certification would be awarded to all the professionals, who have completed the training program and the project assignment given by your instructor. 

You can use the certificate in your future job interviews will surely help you to land in your dream job.

 

Q: What is the infrastructure required to attend your training program?

 

A: To attend the training session you should have an operational Desktops or Laptops with required specification along with good internet connection to access the labs. 

 

Unble To Find a Batch..?

Request a Batch