Microsoft Azure – Implementing Infrastructure Solutions: Data Services

This course is included in our On-demand training solution.

Overview

Microsoft Azure SQL Database is a service that enables you to run SQL databases on the Azure cloud without having to manage the underlying OS or SQL Server software. In this course, you’ll learn about the creation, maintenance, and security configuration tasks in Microsoft Azure SQL Database. This course is one of a series in the Skillsoft learning path that covers the objectives for Microsoft exam 70-533: Implementing Microsoft Azure Infrastructure Solutions. This exam completes the requirement for Microsoft Specialist certification in Microsoft Azure.

Target Audience

Seasoned implementers of Azure infrastructure solutions with experience in implementation and monitoring of on- and off-premises solutions and lifecycle management

Prerequisites

None

Expected Duration

90 min.

Course Objectives

Course Introduction

Data Services in Azure

  • describe the options in Data Services in Microsoft Azure
  • Comparing Azure SQL Database and SQL Server

  • compare Microsoft SQL Server on-premises to Microsoft Azure SQL Database
  • Azure SQL Architecture

  • describe the architecture and tools for managing Azure SQL Database, and the processes for provisioning and migrating from Microsoft SQL Server on-premises
  • Creating an Azure SQL Database

  • create an Azure SQL Database on Microsoft Azure
  • Configuring the Firewall for Azure SQL Database

  • configure the firewall for Azure SQL Database on Microsoft Azure
  • Connecting to Azure SQL with SQL 2014 Management Studio

  • connect to Microsoft Azure SQL Database from Microsoft SQL 2014 Management Studio
  • Configuring a Connection String for Azure SQL Database

  • configure a connection string for a Microsoft Azure SQL Database
  • Azure SQL Database Security Overview

  • describe Microsoft Azure SQL Database levels and firewall rules
  • Managing Azure SQL Database Firewall Rules

  • manage Microsoft Azure SQL Database firewall rules
  • Managing Azure SQL Database Logins and Users

  • manage logins and users in the Microsoft Azure SQL database
  • Managing Azure SQL Database Roles and Permissions

  • manage Microsoft Azure SQL Database roles and permissions
  • Monitoring Azure SQL Database Metrics

  • monitor Microsoft Azure SQL Database metrics
  • Configure Azure SQL Database Alerts

  • configure Microsoft Azure SQL Database alerts
  • Configure Azure SQL Database Auditing

  • configure Microsoft Azure SQL Database auditing
  • Configuring Azure SQL Database Copy and Export

  • configure Microsoft Azure SQL Database copy and export
  • Restoring an Azure SQL Database

  • restore Microsoft Azure SQL Databases
  • Configuring Azure SQL Database Geo-Replication

  • configure Microsoft Azure SQL Database geo-replication
  • Exercise: Configuring Azure SQL Database

    SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?