Azure Fundamentals: Database Solutions

Azure 2019
  • 14 Videos | 59m 9s
  • Includes Assessment
  • Earns a Badge
Likes 226 Likes 226
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

  • Playable
    1. 
    Course Overview
    1m 41s
    UP NEXT
  • Playable
    2. 
    SQL Overview
    3m 21s
  • Locked
    3. 
    Azure SQL Database
    4m 52s
  • Locked
    4. 
    Azure SQL Database GUI Deployment
    5m 24s
  • Locked
    5. 
    Azure SQL Database CLI Deployment
    4m 34s
  • Locked
    6. 
    Azure SQL Database PowerShell Deployment
    3m 2s
  • Locked
    7. 
    Connect to Azure SQL Database
    2m 33s
  • Locked
    8. 
    Azure Database Migration Service
    3m 1s
  • Locked
    9. 
    SQL Server Migration Assessment
    3m 56s
  • Locked
    10. 
    Azure SQL Geo-Replication
    4m 15s
  • Locked
    11. 
    NoSQL Overview
    2m 50s
  • Locked
    12. 
    CosmosDB
    1m 56s
  • Locked
    13. 
    Deploy CosmosDB
    4m 34s
  • Locked
    14. 
    Exercise: Choose Azure Database Solutions
    7m 10s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 194 Likes 194  
Likes 965 Likes 965  
Likes 476 Likes 476