Azure Fundamentals: Database Solutions

Azure 2019    |    Beginner
  • 14 Videos | 53m 9s
  • Includes Assessment
  • Earns a Badge
Likes 288 Likes 288
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
    FREE ACCESS
  • Locked
    4. 
    Azure SQL Database GUI Deployment
    5m 24s
    FREE ACCESS
  • Locked
    5. 
    Azure SQL Database CLI Deployment
    4m 34s
    FREE ACCESS
  • Locked
    6. 
    Azure SQL Database PowerShell Deployment
    3m 2s
    FREE ACCESS
  • Locked
    7. 
    Connect to Azure SQL Database
    2m 33s
    FREE ACCESS
  • Locked
    8. 
    Azure Database Migration Service
    3m 1s
    FREE ACCESS
  • Locked
    9. 
    SQL Server Migration Assessment
    3m 56s
    FREE ACCESS
  • Locked
    10. 
    Azure SQL Geo-Replication
    4m 15s
    FREE ACCESS
  • Locked
    11. 
    NoSQL Overview
    2m 50s
    FREE ACCESS
  • Locked
    12. 
    CosmosDB
    1m 56s
    FREE ACCESS
  • Locked
    13. 
    Deploy CosmosDB
    4m 34s
    FREE ACCESS
  • Locked
    14. 
    Exercise: Choose Azure Database Solutions
    7m 10s
    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 of this course, 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: Software Development
Likes 212 Likes 212  
COURSE Azure Data Scientist Associate: Azure Data Platform Services
Likes 24 Likes 24  
COURSE Azure Data Scientist Associate: Machine Learning Data Stores & Compute

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Azure Fundamentals: Azure Data Privacy
Likes 281 Likes 281  
COURSE Azure Fundamentals: Monitoring the Azure Environment
Likes 247 Likes 247  
COURSE Microsoft Azure Fundamentals: Cloud Computing
Likes 861 Likes 861