Azure SQL Fundamentals

Introduction to Azure SQL

Azure SQL history

Launch of Windows Azure

Evolution of database services on Azure

Azure SQL deployment options

SQL Server on Azure Virtual Machines

IaaS vs. PaaS

Versionless database services

SQL Managed Instance

SQL Database

Elastic database pool

Azure SQL deployment options

Purchasing models, service tiers, and hardware choices

Management interfaces for Azure SQL

Secure your data with Azure SQL

Security capabilities and tasks

Network security

Azure SQL Database

Allow access to Azure services

Firewall rules

Virtual network rules

Private Link for an Azure SQL Database instance

An Azure SQL managed instance

Identity and access

Role-based access control

Authentication

Deliver consistent performance with Azure SQL

Performance capabilities

Configure and maintain performance

Monitor and troubleshoot performance

Deploy highly available solutions by using Azure SQL

Backup and restore

Point in time restore (PITR)

Long-term retention (LTR)

High availability by service tier

Availability Zones

Availability and consistency

Configure and monitor the availability

Putting it all together with Azure SQL

Architect global scale and secure access

An application running on an Azure VM

Mission-critical application

Opportunities in Azure