Azure SQL Deep Dive
40mAdvanced2023-05-12
Authors
Jeremy Villeneuve
Founder of Halvanta, LLC, an IT consulting firm
Course details
If you’re a database or server administrator spending too much time administering SQL Server, Azure SQL may be just the tool you need. Azure SQL is a cost-effective way to run SQL Server databases in the cloud, providing global scaling, failover, redundant point-in-time backups, automatic upgrades, modern security, and more, all enabled by simply pressing a few checkboxes. In this course, Jeremy Villeneuve shows you how to plan a migration to Azure SQL. He provides a technical overview of the differences in administering these databases, and examines the advantages and challenges when transitioning to platform-as-a-service managed Azure SQL Databases.
Skills covered
AdvancedDatabase DevelopmentDatabase ManagementAzureNetwork AdministrationCloud PlatformsNetwork and System AdministrationCloud ComputingMicrosoftSoftware Development
Concepts
0. Introduction
- 01 - Move from MSSQL on-premise to Azure SQL
- 02 - What you should know
1. Azure SQL Deployment Options
- 03 - Hosting SQL Server databases in the cloud
- 04 - Azure shared responsibility for cloud computing
- 05 - Get more control with Azure SQL Managed Instances
2. Set up an Azure SQL Database Server
- 06 - User authentication with Azure SQL
- 07 - How many database transaction units do you need
- 08 - Create a new Azure SQL Database
- 09 - Securing connections into your Azure SQL Server
3. Migrate SQL Databases into Azure SQL
- 10 - Migration strategies for Azure SQL Databases
- 11 - Lift and shift existing SQL Server instances
4. Azure SQL Security
- 12 - Encrypting your data at rest
- 13 - Securing data that is moving in transit
5. Azure SQL High Availability and Disaster Recovery
- 14 - Backing up your Azure SQL Databases
- 15 - Replication services for a high uptime
6. Monitoring Azure SQL Databases
- 16 - Performance monitoring in Azure SQL portal
- 17 - Track down long-running queries in Azure SQL
Conclusion
- 18 - Clean up Azure resources
Related courses
- Azure Cosmos DB: SQL API Deep Dive
- Microsoft Azure Synapse for Developers: Scaling Configuration
- SQL Server 2016: Provision a Database
- Azure for Developers: Authenticating to Azure Services Using the Microsoft Identity Platform
- Learning SQL Server Development on Linux
- Implementing a Data Warehouse SQL Server 2019
- Complete Guide to Databricks for Data Engineering
- SQL Server Management Enabled by Azure Arc
Related learn paths
- Advancing Your Azure Developer Skills: Exploring Complex Application Development
- Optimizing Enterprise Security and Productivity Using Microsoft 365
- The Top Skills IT Professionals Have Right Now
- Explore AI for Data Engineering
- Explore a Career in IT Support
- Advance Your Data Skills in Apache Spark
- Mastering Executive-Level Data Analytics
- Prepare for the Azure Database Administrator Associate (DP-300) Certification