• Online, Self-Paced
Course Description

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.

Learning Objectives

Azure Data Services

  • start the course
  • describe the options in Data Services in Microsoft Azure
  • compare Microsoft SQL Server on-premises to Microsoft Azure SQL Database
  • describe the architecture and tools for managing Azure SQL Database, and the processes for provisioning and migrating from Microsoft SQL Server on-premises
  • create an Azure SQL Database on Microsoft Azure
  • configure the firewall for Azure SQL Database on Microsoft Azure
  • connect to Microsoft Azure SQL Database from Microsoft SQL 2014 Management Studio
  • configure a connection string for a Microsoft Azure SQL Database

Azure SQL Database Security

  • describe Microsoft Azure SQL Database levels and firewall rules
  • manage Microsoft Azure SQL Database firewall rules
  • manage logins and users in the Microsoft Azure SQL database
  • manage Microsoft Azure SQL Database roles and permissions

Monitoring Azure SQL Database

  • monitor Microsoft Azure SQL Database metrics
  • configure Microsoft Azure SQL Database alerts
  • configure Microsoft Azure SQL Database auditing

Managing Azure SQL Database Continuity

  • configure Microsoft Azure SQL Database copy and export
  • restore Microsoft Azure SQL Databases
  • configure Microsoft Azure SQL Database geo-replication

Practice: Azure SQL Databases

  • create and configure an Azure SQL Database

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.