Course details

Azure Fundamentals: Database Solutions

Azure Fundamentals: Database Solutions


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
0.9

Lesson Objectives

Azure Fundamentals: Database Solutions

  • Course Overview
  • describe SQL databases and their use
  • recognize when to use Azure SQL Database
  • deploy Azure SQL database using the GUI
  • deploy Azure SQL database using the CLI
  • deploy Azure SQL database using PowerShell
  • manage an Azure SQL database from on-premises
  • describe how the SQL migration process works
  • configure a SQL server assessment project
  • enable geo-replication for Azure SQL through the portal
  • describe NoSQL databases and their use
  • recognize when to use CosmosDB
  • create an Azure CosmosDB database using the Azure portal
  • map Azure database options to business needs
  • Course Number:
    it_clazfd_06_enus

    Expertise Level
    Beginner