Azure SQL fundamentals

Go to class
Write Review

Free Online Course: Azure SQL fundamentals provided by Microsoft Learn is a comprehensive online course, which lasts for 7-8 hours worth of material. The course is taught in English and is free of charge.

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