Azure Fundamentals: Database Solutions

Azure    |    Beginner
  • 14 videos | 53m 9s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 119 users Rating 4.6 of 119 users (119)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 1m 41s
  • 3m 21s
    Upon completion of this video, you will be able to describe SQL databases and their use. FREE ACCESS
  • Locked
    3.  Azure SQL Database
    4m 52s
    Upon completion of this video, you will be able to recognize when to use Azure SQL Database. FREE ACCESS
  • Locked
    4.  Azure SQL Database GUI Deployment
    5m 24s
    During this video, you will learn how to deploy an Azure SQL database using the GUI. FREE ACCESS
  • Locked
    5.  Azure SQL Database CLI Deployment
    4m 34s
    In this video, learn how to deploy an Azure SQL database using the CLI. FREE ACCESS
  • Locked
    6.  Azure SQL Database PowerShell Deployment
    3m 2s
    In this video, learn how to deploy an Azure SQL database using PowerShell. FREE ACCESS
  • Locked
    7.  Connect to Azure SQL Database
    2m 33s
    Find out how to manage an Azure SQL database from on-premises. FREE ACCESS
  • Locked
    8.  Azure Database Migration Service
    3m 1s
    Upon completion of this video, you will be able to describe how the SQL migration process works. FREE ACCESS
  • Locked
    9.  SQL Server Migration Assessment
    3m 56s
    In this video, you will learn how to configure a SQL server assessment project. FREE ACCESS
  • Locked
    10.  Azure SQL Geo-Replication
    4m 15s
    In this video, you will learn how to enable geo-replication for Azure SQL through the Azure portal. FREE ACCESS
  • Locked
    11.  NoSQL Overview
    2m 50s
    Upon completion of this video, you will be able to describe NoSQL databases and their use. FREE ACCESS
  • Locked
    12.  CosmosDB
    1m 56s
    Upon completion of this video, you will be able to recognize when to use CosmosDB. FREE ACCESS
  • Locked
    13.  Deploy CosmosDB
    4m 34s
    During this video, you will learn how to create an Azure CosmosDB database using the Azure portal. FREE ACCESS
  • Locked
    14.  Exercise: Choose Azure Database Solutions
    7m 10s
    Learn how to map business needs to Azure database options. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Microsoft Azure Fundamentals: Azure Cloud Computing
Rating 4.6 of 1713 users Rating 4.6 of 1713 users (1713)
Journey Working with Microsoft Azure SQL
Rating 4.6 of 5 users Rating 4.6 of 5 users (5)
Course Microsoft Azure Fundamentals: Migrating to Azure
Rating 4.6 of 215 users Rating 4.6 of 215 users (215)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Azure Fundamentals: Network Components
Rating 4.6 of 146 users Rating 4.6 of 146 users (146)
Course Advancing Meaningful Diversity In The Workplace: Session Replay
Rating 4.6 of 706 users Rating 4.6 of 706 users (706)
Course Azure Fundamentals: The Ecosystem
Rating 4.5 of 432 users Rating 4.5 of 432 users (432)