Hands-On : Azure Tenant and SQL Database deployment

Learn to leverage the power of Azure SQL Database, Microsoft's robust Platform as a Service (PaaS) for Relational Database Management Systems (RDBMS). This hands-on course guides you through the step-by-step creation of essential Azure components: Azure Tenant, Subscription, Azure SQL Server, and Azure SQL Database.

Gain practical experience connecting to your Azure SQL Database using SQL Server Management Studio (SSMS) and manipulating data with fundamental CRUD (Create, Read, Update, Delete) operations.

Explore the different deployment options available with Azure SQL:

• Azure SQL Database: This is the core focus of the course. As a Platform as a Service, Azure SQL Database allows you to quickly deploy and scale your relational databases. You manage the database layer, benefiting from high scalability and elastic options.
• SQL Managed Instance: Another PaaS offering, SQL Managed Instance provides compatibility with on-premise SQL Server. Enjoy features like SQL Server Agent, SQL Server Profiler, Log Shipping, Replication, and Cross Database Query – capabilities not available in Azure SQL Database.
• SQL Virtual Machines: SQL Virtual Machines offer a deployment very similar to on-premise SQL Server, with the key difference being Azure's management of the underlying hardware. You create Azure resources using virtual machines.

This course provides the skills to choose the right Azure SQL deployment option for your specific needs and effectively manage your relational databases in the cloud.