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

Azure SQL fundamentals

Microsoft via Microsoft Learn

Go to class Write review

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

united states

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Azure SQL fundamentals

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.