Designing and Implementing Cloud Data Platform Solutions (M55247)

COURSE OUTLINE:

Description

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.

Audience

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ï¿½

Learning Objectives

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

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

RELATED COURSES

Uncategorized

Perform Cloud Data Science with Azure Machine Learning (M20774)

The main purpose of the course is to give students the ability to analyze and present data by using Azure Machine Learning, and to provide an introduction to the use of machine learning with big data tools such as HDInsight and R Services.

Uncategorized

IBM InfoSphere Advanced QualityStage V11.5

In this course, you will be introduced to the QualityStage data cleansing process. You will transform an unstructured data source into a format suitable for loading into an existing data target. You will cleanse the source data by building a customer rule set. You will build a reference match to relate the cleansed source data to the existing target data.

Uncategorized

Leading Continuous Change

There is no shortage of research suggesting the majority of change initiatives fail. Factors such as the lack of a clear vision, misalignment of leaders, inadequate communication, and failure to hold people accountable all negatively impact the results of organizational change initiatives.ï¿½

The challenge is that there is no sign of the pace and amount of change slowing. In todayï¿½s digitally disrupted world, continuous change is the new normal. To be successful, you must be able to prioritize and manage multiple change initiatives, avoid change fatigue, and ensure individuals and teams remain committed and connected to the direction of the organization.

Uncategorized

InfoSphere MDM Domain v11.4

This course is designed for anyone who wants to get an understanding of the Data Domains for the InfoSphere Master Data Management Physical Module. This course takes a comprehensive look at the three core data domains of InfoSphere MDM: Party, Account, and Product. For each of the domains spanned by InfoSphere MDM, participants will be exposed to the data model, services, and rules associated with the main entities of that domain. Heavy emphasis is put on exercises and activities so that the participants can apply the knowledge that they learn after course conclusion.