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

IBM PureData System for Analytics Programming and Usage

This course is designed to give you an overview of the IBM PureData System for Analytics (PDA) N1001, N2001, and N3001 appliance architecture and provide a working knowledge and understanding of the PDA SQL and development features as well as development best practices. It includes content and labs on the features introduced in NPS 7 including full schema support. The lab environment is an N2002-005 physical appliance.

An on-demandï¿½version of this course is also available (2W585G).

Uncategorized

Oracle 11g Database Administration I

Through hands-on experience administering an Oracle 11g database, you will gain an understanding of the Oracle Server architecture, and you will learn how to expand the size of the database, implement security, and know why and how specific database administration tasks are performed.

Uncategorized

VMware vSphere: What’s New v5.5 to v6.7

In this three-day, hands-on training course, you will explore the new features and enhancements in VMware vCenter Serverï¿½ 6.7 and VMware ESXiï¿½ 6.7. Real-world use-case deployment scenarios, hands-on lab exercises, and lectures will teach you the skills that you need to effectively implement and configure VMware vSphereï¿½ 6.7. This course is recommended for customers who want to deploy vSphere 6.7 into their existing vSphere environment.

Uncategorized

IBM Spectrum Scale 4.1 Basic Administration for Linux

This course teaches IBM Spectrum Scale version 4.1.

The course is intended for IT professionals tasked with administering an IBM Spectrum Scale system on Linux and AIX environments. This course includes information on installing, configuring, and monitoring an IBM Spectrum Scale cluster. Many features are described and tested on lab activities including: Storage management, High availability options, cluster management, and information lifecycle management (ILM) tools.

Note: Although the lab is created to run on Linux, because the Spectrum Scale differences running on an AIX environment are minor, the skills intended to be acquired during the course include both Linux and AIX.