Black Friday 2024: 25+ Ways to Save on Online Learning

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

Go to class Write review

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Grab it
  • 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

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Azure SQL fundamentals

  • Profile image for Aman Kumar
    Aman Kumar
    The Azure SQL Fundamentals course is an excellent resource for anyone looking to gain a solid understanding of Azure SQL and its core concepts. The course provides a comprehensive overview of Azure SQL Database, its features, deployment options, and security considerations. The content is well-structured, making it easy to follow along and grasp the key concepts. The hands-on labs and real-world examples provide practical experience, enhancing the learning process. Overall, the course is concise, informative, and suitable for beginners, equipping them with the essential knowledge to leverage Azure SQL effectively for their data storage and management needs.

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.