YoVDO

Azure SQL fundamentals

Offered By: Microsoft via Microsoft Learn

Tags

Microsoft Azure Courses SQL Courses Network Security Courses Data Management Courses High Availability Courses Data Classification Courses Azure SQL Courses

Course Description

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

Tags

Related Courses

An Introduction to Computer Networks
Stanford University via Independent Computer Networks
University of Washington via Coursera Computer Networking
Georgia Institute of Technology via Udacity Cybersecurity and Its Ten Domains
University System of Georgia via Coursera Model Building and Validation
AT&T via Udacity