Azure SQL fundamentals
4.7 /5- Offered byMicrosoft
Azure SQL fundamentals at Microsoft Overview
Duration | 7 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Azure SQL fundamentals at Microsoft Highlights
- Learn key aspects of configuration, monitoring, and intelligent performance for Azure SQL
- Learn how to take the business scenario and determine the best resources and processes to satisfy requirements
- Get to work with SSMS, Azure Data Studio (including SQL notebooks), and the Azure CLI
Azure SQL fundamentals at Microsoft Course details
- Introduction to Azure SQL
- Deploy and configure servers, instances, and databases for Azure SQL
- Secure your data with Azure SQL
- Deliver consistent performance with Azure SQL
- Deploy highly available solutions by using Azure SQL
- Putting it all together with Azure SQL
- Understand how the role of a database administrator (DBA) or data professional stays the same
- Learn about the process of deploying and configuring Azure SQL
- Azure SQL has the capabilities and tools to allow you to deliver consistent performance for your application
Azure SQL fundamentals at Microsoft Curriculum
MODULE:1 Introduction to Azure SQL
Azure SQL history
Azure SQL deployment options
Purchasing models, service tiers, and hardware choices
Management interfaces for Azure SQL
MODULE:2 Deploy and configure servers, instances, and databases for Azure SQL
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
MODULE:3 Secure your data with Azure SQL
Security capabilities and tasks
Exercise - Configure auditing
Exercise - Secure your network
Exercise - Configure authentication
Protect your data
Manage your security
Exercise - Manage security and Azure Defender
Exercise - Data classification, dynamic data masking, and SQL audit
MODULE:4 Deliver consistent performance with Azure SQL
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
MODULE:5 Deploy highly available solutions by using Azure SQL
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
MODULE:6 Putting it all together with Azure SQL
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
Azure SQL fundamentals at Microsoft Entry Requirements
- Prerequisites: Experience working with, maintaining, and developing with SQL Server
- Experience with Azure, such as deploying and managing resources
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?