Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Azure SQL fundamentals

Microsoft via Microsoft Learn

Overview

  • Module 1: This module introduces Azure SQL. Learn about various deployment options and service tiers and what to use for your organization.
  • In this module, you'll learn how to:

    • Describe the evolution of SQL Server in Azure.
    • Determine which deployment option is best for workloads in your organization.
    • Select the purchasing models, service tiers, and hardware that best fit a workload.
  • Module 2: Deploy and configure servers, instances, and databases for Azure SQL
  • In this module, you'll learn how to:

    • Plan for a deployment of Azure SQL
    • Deploy and verify Azure SQL by using common tools and interfaces
    • Configure Azure SQL after deployment
    • Load data into Azure SQL
  • Module 3: Secure your data with Azure SQL
  • In this module, you will learn how to:

    • Make an informed decision about securing your network.
    • Manage and deliver access management and authorization.
    • Protect, encrypt, and mask data.
    • Manage and monitor security for your Azure SQL Database instance and Azure SQL managed instance.
  • Module 4: Deliver consistent performance with Azure SQL
  • In this module, you will:

    • Identify the performance capabilities of Azure SQL
    • Configure and maintain the performance features of Azure SQL
    • Monitor and troubleshoot performance in Azure SQL
    • Improve performance with intelligent insights
  • Module 5: In this module, you'll learn how to deploy highly available solutions by using Azure SQL. You'll also look at architectures and how they affect availability.
  • In this module, you'll learn how to:

    • Create a backup and restore strategy for your organization
    • Evaluate the architectures associated with each service tier
    • Compare options for getting higher availability
    • Describe how availability and consistency apply to Azure SQL
    • Configure and monitor availability
  • Module 6: Putting it all together with Azure SQL
  • In this module, you will:

    • Apply your Azure SQL knowledge to any scenario and determine what to use when
    • Build a solution that involves Azure SQL
    • Understand the other cloud opportunities that become available after you're using Azure SQL
    • Use the resources to go deeper

Syllabus

  • Module 1: Introduction to Azure SQL
    • Introduction
    • Azure SQL history
    • Azure SQL deployment options
    • Purchasing models, service tiers, and hardware choices
    • Management interfaces for Azure SQL
    • Summary
  • Module 2: Deploy and configure servers, instances, and databases for Azure SQL
    • Introduction
    • Plan, deploy, and verify Azure SQL
    • Exercise - Deploy Azure SQL Database
    • Exercise - Verify Azure SQL Database
    • Configure Azure SQL Database and Azure SQL Managed Instance
    • Exercise - Configure Azure SQL Database
    • Load data into Azure SQL
    • Exercise - Load data into Azure SQL Database
    • Summary
  • Module 3: Secure your data with Azure SQL
    • Introduction
    • Security capabilities and tasks
    • Exercise - Configure auditing
    • Exercise - Secure your network
    • Exercise - Configure authentication
    • Protect your data
    • Manage your security
    • Exercise - Manage security and Microsoft Defender for Cloud
    • Exercise - Data classification, dynamic data masking, and SQL audit
    • Summary
  • Module 4: Deliver consistent performance with Azure SQL
    • Introduction
    • Performance capabilities
    • Configure and maintain performance
    • Monitor and troubleshoot performance
    • Exercise - Monitor and troubleshoot performance
    • Accelerate and tune performance
    • Exercise - Scale the performance of your workload
    • Exercise - Optimize application performance
    • Intelligent performance
    • Summary
  • Module 5: Deploy highly available solutions by using Azure SQL
    • Introduction
    • Backup and restore
    • Exercise - Restore to a point in time
    • High availability by service tier
    • Exercise - General purpose high availability
    • Exercise - Business critical high availability
    • Going further with availability
    • Exercise - Geo-distributed auto-failover groups with read-scale
    • Availability and consistency
    • Configure and monitor availability
    • Summary
  • Module 6: Putting it all together with Azure SQL
    • Introduction
    • Scenario 1 - Architect global scale and secure access
    • Scenario 1 solution - Architect global scale and secure access
    • Scenario 2 - Mission-critical application
    • Scenario 2 solution - Mission-critical application
    • Opportunities in Azure
    • Summary

Reviews

Start your review of Azure SQL fundamentals

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.