
Discover how Azure SQL Database delivers a cloud-based relational database service with on-demand provisioning, global accessibility, and entity framework friendly development using familiar SQL Server features.
Create a logical server and database in Azure SQL Database, configure firewall for external access, and connect from management studio and a Visual Studio console app using the connection string.
Demonstrates three options to migrate an on premise sql server database to azure sql database: script-based migration, an open source tool, and cross-platform asset migration, with a visual studio demo.
Create and connect a code-first entity framework model and context to an azure sql database, enable migrations, and publish updates from local development to the cloud.
Plan azure sql deployment by evaluating workload and concurrency, selecting a suitable pricing tier, and using elastic pools or dedicated resources to optimize performance and cost.
Monitor azure sql database performance and set up alerting with metrics, graphs, and thresholds, including elastic pools and resource utilization.
Enable azure sql database auditing to track events and write them to a storage account, define categories, generate reports, and analyze for anomalies and security concerns.
Master Azure SQL Database continuity through backups, export, and point-in-time restores stored in a storage account. Enable automated incremental backups, retention, and promotion of multi-location secondaries to primary for uptime.
Explore Azure SQL Database as a cloud relational database service, compare it with on-premises SQL Server, and learn migration, backup and recovery, security, elastic pools, high availability, and pricing tiers.
Explore Azure SQL Database deployment options, high availability, elastic pools, backups, and geo replication for reliable data management.
This course provides a practical and structured guide to managing data in Azure SQL Database, focusing on real-world database administration and data management scenarios in Microsoft Azure.
You will begin with an introduction to Azure SQL Database, understanding what it is, how it works, and how it differs from on-premises SQL Server. The course then walks you through creating and connecting to Azure SQL Database, helping you understand deployment options and connectivity methods.
As the course progresses, you will learn how to migrate on-premises SQL Server databases to Azure SQL Database, gaining insight into cloud migration concepts and common challenges. You will also work with Entity Framework Code First to understand how applications interact with Azure SQL Database.
A key focus of this course is planning and deployment, where you will learn how to design Azure SQL Database solutions based on performance, scalability, and availability requirements. You will then explore monitoring and alerting, enabling you to track database performance and respond proactively to issues.
The course also covers Azure SQL Database auditing, helping you understand how to track database activities for compliance and security. In addition, you will learn about business continuity, including features that help protect data and ensure availability.
Each topic is explained through clear video lessons, supported by practice tests to help you validate your understanding. By the end of this course, you will have the confidence to manage Azure SQL Databases effectively in real-world environments.