Azure Fundamentals: Database Solutions

In this 14-video course learners are shown how to distinguish between SQL (structured query language) and NoSQL Azure databases including databases such as Azure SQL and Cosmos DB. The course begins by discussing some SQL basics and then explores Azure SQL databases in-depth including Azure SQL database graphical user interface (GUI) deployment deployment through the command-line interface (CLI) and using PowerShell cmdlets (lightweight commands). Next watch a demonstration of how to connect to Azure SQL Database and how the SQL migration process works to bring data from on-premises into the Azure cloud. Explore the process of Azure database migration. Finally you will learn how to describe options for using NoSQL solutions in Azure such as CosmosDB. The concluding exercise directs learners to draw a comparison between SQL compliant databases and NoSQL database solutions then use the Azure Portal to deploy Azure SQL Database; connect to Azure SQL Database from on-premises by using a tool such as Microsoft SQL Server Management Studio; and finally to deploy CosmosDB. This is one of a series of courses to help learners prepare for the AZ-900: Azure Fundamentals certification exam.