Introduction to Azure SQL Database

Learn to manage databases in Microsoft cloud, configure backups, implement security, and set up high-availability solutions in this Azure SQL Database course.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

Learn to manage databases in Microsoft cloud, configure backups, implement security, and set up high-availability solutions in this Azure SQL Database course.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course 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.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Introduction to Azure SQL Database - What you need to get started

Module 00 - Class Introduction 6 min.

Module 01A - Introduction to Azure SQL Database (Overview) 23 min.

Module 02A - Getting Started with Azure SQL Server (Creating an Azure SQL Server) 22 min.

Module 02B - Getting Started with Azure SQL Server (Securing an Azure SQL Server) 15 min.

Module 03A - Getting Started with Azure SQL Database (Overview) 13 min.

Module 03B - Getting Started with Azure SQL Database (Creating an Azure SQL Database) 22 min.

Module 03C - Getting Started with Azure SQL Database (Connecting to Azure SQL Database) 5 min.

Module 04A - Security (Role Based Access Control) 27 min.

Module 04B - Security (Database Permissions) 8 min.

Module 04B - Security (Server and Database Firewalls) 8 min.

Module 04C - Security (Transparent Data Encryption) 6 min.

Module 05A - Scaling Databases (Scaling a Database in the Azure Portal) 9 min.

Module 05B - Scaling Databases (Stored Procedures) 6 min.

Module 06A - Backup and Restore (Built-in Backups) 14 min.

Module 06B - Backup and Restore (Long Term Retention) 6 min.

Module 06C - Backup and Restore (Recovering a Deleted Database) 5 min.

Module 07A - Database Migrations 20 min.

Module 08A - Monitoring a Database (Database Alerts) 10 min.

Module 08B - Monitoring a Database (Auditing) 9 min.

Wrap-Up 4 min.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Austin Libal

Data Engineer (Azure) Trainer

Austin is a Jacksonville native who graduated from The Baptist College of Florida in 2012. He previously worked as a manager in the retail service industry. He enjoys spending time with his wife and two kids. His primary focus at Pragmatic Works is on Azure Synapse Analytics and teaching the best practices for data integration, enterprise data warehousing, and big data analytics. He also enjoys helping customers learn the ins and outs of Power BI and showing people new ways to grow their business with the Power Platform.

Learn More

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

- Microsoft Azure Account (Paid or Trial) - SQL Server Management Studio 17.5+ Need additional help installing the SQL Server tools? Check out our video series on installing these requirements [here](https://www.youtube.com/playlist?list=PLcwrIWK7WBcS6yAJb-FjYMndzWPxmbQ0_).

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

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

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion