Introduction to Azure SQL Database

$95.00

Category:

Description

In the Azure SQL Database course you will learn the basics of configuring and managing a database in Microsoft’s cloud. This course will help you understand how to do common tasks like configuring database backups, implementing security and setting up highly available solutions.

Instructor

MITCHELL PEARSONMITCHELL PEARSON

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

 

What to Know Before the Class

This course assumes you have no prior knowledge of Azure SQL Database.


Duration: 7:37:03
In the Azure SQL Database course you will learn the basics of configuring and managing a database in Microsoft’s cloud. This course will help you understand how to do common tasks like configuring database backups, implementing security and setting up highly available solutions.
Introduction to Azure SQL Database - What you will need to get started
Module 00 - Class Introduction
05:09
Module 01A - Introduction to Azure SQL Database (Overview)
27:33
Module 01B - Introduction to Azure SQL Database (Navigating the Azure Portal)
10:36
Module 02A - Getting Started with Azure SQL Server (Creating an Azure SQL Server)
16:13
Module 02B - Getting Started with Azure SQL Server (Securing an Azure SQL Server)
07:47
Module 03A - Getting Started with Azure SQL Database (Overview)
23:22
Module 03B - Getting Started with Azure SQL Database (Creating an Azure SQL Database)
08:03
Module 03C - Getting Started with Azure SQL Database (Connecting to Azure SQL Database)
07:56
Module 04A - Security (Role Based Access Control)
16:40
Module 04B - Security (Server and Database Firewalls)
31:08
Module 04C - Security (Transparent Data Encryption)
10:28
Module 04D - Security (Database Permissions)
26:40
Module 05A -Scaling Databases and Elastic Pools (Scaling a Database in the Azure Portal)
19:37
Module 05B - Scaling Databases and Elastic Pools (Elastic Pools)
34:18
Module 06A - Backup and Restore (Built-in Backups)
21:37
Module 06B - Backup and Restore (Long Term Retention)
15:44
Module 06C - Backup and Restore (Recovering a Deleted Database)
10:14
Module 06D - Backup and Restore (Exporting and Importing a BACPAC)
35:56
Module 07 - Database Migrations
36:56
Module 08 - High Availability and Disaster Recovery
41:39
Module 09A - Monitoring a Database (Database Alerts)
16:16
Module 09B - Monitoring a Database (Auditing)
20:21
Module 10 - Limitations of Azure SQL Database
12:50
Class Survey

System Requirements

  • Microsoft Azure Account (Paid or Trial)
  • SQL Server Management Studio 17.5+