Azure Fundamentals: Database Solutions
Azure 2019
| Beginner
- 14 Videos | 53m 9s
- Includes Assessment
- Earns a Badge
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 userecognize when to use Azure SQL Databasedeploy Azure SQL database using the GUIdeploy Azure SQL database using the CLIdeploy Azure SQL database using PowerShellmanage an Azure SQL database from on-premisesdescribe how the SQL migration process works
-
configure a SQL server assessment projectenable geo-replication for Azure SQL through the portaldescribe NoSQL databases and their userecognize when to use CosmosDBcreate an Azure CosmosDB database using the Azure portalmap Azure database options to business needs
IN THIS COURSE
-
1.Course Overview1m 41sUP NEXT
-
2.SQL Overview3m 21s
-
3.Azure SQL Database4m 52s
-
4.Azure SQL Database GUI Deployment5m 24s
-
5.Azure SQL Database CLI Deployment4m 34s
-
6.Azure SQL Database PowerShell Deployment3m 2s
-
7.Connect to Azure SQL Database2m 33s
-
8.Azure Database Migration Service3m 1s
-
9.SQL Server Migration Assessment3m 56s
-
10.Azure SQL Geo-Replication4m 15s
-
11.NoSQL Overview2m 50s
-
12.CosmosDB1m 56s
-
13.Deploy CosmosDB4m 34s
-
14.Exercise: Choose Azure Database Solutions7m 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.