Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Designing and Implementing Cloud Data Platform Solutions (M55247)

Designing and Implementing Database Solutions in SQL Server and on Microsoft Azure

GK# 9885

Course Overview

TOP

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.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • 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

Outline

TOP
Viewing outline for:

Virtual Classroom Live Outline

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

Labs

TOP
Viewing labs for:

Virtual Classroom Live Labs

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

Lab 2: Manage, Design and Implement Database Security

  • Implement SQL Server database security
  • Implement Azure SQL Database security

Lab 3: Create Microsoft Azure Data Objects using Python

  • Implement a High-Availability Solution
  • Implement a Disaster Recovery Solution
  • Implement a Scalability Solution

Lab 4: Create Microsoft Azure Data Processes using Python

  • Monitor and Troubleshoot SQL Server
  • Monitor and Troubleshoot Azure SQL Databases

Prerequisites

TOP
  • Experience working with databases
  • Experience using SQL 

Who Should Attend

TOP

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

Vendor Credits

TOP

SATV Redemption

Redeeming your Microsoft Software Assurance Training Vouchers:

  • 3 Day SATV for a Classroom Live session
  • 3 Day SATV for a Virtual Classroom Live session
Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 3 day

Request this course in a different delivery format.
Enroll