YoVDO

Plan and implement data platform resources

Offered By: Microsoft via Microsoft Learn

Tags

Microsoft SQL Server Courses MySQL Courses PostgreSQL Courses MariaDB Courses Disaster Recovery Courses High Availability Courses Azure SQL Database Courses Database Deployment Courses

Course Description

Overview

  • Module 1: Deploy SQL Server in a virtual machine

    • After completing this module, you will be able to:

    • Explore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering
    • Learn the available options for provisioning and deployment
    • Deploy SQL Server into an Azure Virtual Machine
  • Module 2: Deploy Azure SQL Database

    • After completing this module, you will be able to:

    • Gain an understanding SQL Server in a Platform as a Service (PaaS) offering
    • Understand PaaS provisioning and deployment options
    • Understand elastic pools
    • Examine Managed Instances
    • Configure a template for PaaS deployment
  • Module 3: Deploy MariaDB, MySQL, and PostgreSQL on Azure

    • After completing this module, you will be able to:

    • Understand the service tiers available for open source database platforms
    • Deploy MySQL, MariaDB, and PostgreSQL
    • Configure high availability option for MySQL and MariaDB
    • Configure Scale Out reads for MySQL and MariaDB
    • Describe the SSL Options for MySQL and MariaDB
  • Module 4: Evaluate strategies for migrating SQL Databases to Azure

    • After completing this module, you will be able to:

    • Evaluate different Azure migration options when moving your on-premises SQL environment to the cloud.
    • Understand how SQL Server compatibility level affects database behavior.
    • Understand the differences between private and public preview options.

Syllabus

  • Module 1: Deploy SQL Server in a virtual machine
    • Introduction
    • Explain IaaS options for deploying SQL Server in Azure
    • Describe Azure platform availability
    • Explain SQL Server high availability options
    • Explain SQL Server disaster recovery options
    • Provision and deploy SQL Server to Azure virtual machines
    • Exercise: Provision a SQL Server on an Azure virtual machine
    • Knowledge check
    • Summary
  • Module 2: Deploy Azure SQL Database
    • Introduction
    • Explain PaaS options for deploying SQL Server in Azure
    • Deploy single SQL database
    • Deploy SQL database elastic pool
    • Deploy SQL managed instance
    • Exercise: Deploy an Azure SQL Database
    • Knowledge check
    • Summary
  • Module 3: Deploy MariaDB, MySQL, and PostgreSQL on Azure
    • Introduction
    • Describe open source offerings
    • Explain how to deploy PostgreSQL to Azure
    • Deploy MySQL and MariaDB to Azure
    • Exercise: Deploy a PostgreSQL database server to Azure
    • Knowledge check
    • Summary
  • Module 4: Evaluate strategies for migrating SQL Databases to Azure
    • Introduction
    • Understand compatibility level
    • Understand Azure preview features
    • Describe Azure database migration options
    • Knowledge check
    • Summary

Tags

Related Courses

Managing Big Data with MySQL
Duke University via Coursera Database Management Essentials
University of Colorado System via Coursera Business Metrics for Data-Driven Companies
Duke University via Coursera Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique Базы данных (Databases)
Saint Petersburg State University via Coursera