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 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 21sUpon completion of this video, you will be able to describe SQL databases and their use. FREE ACCESS
-
3. Azure SQL Database4m 52sUpon completion of this video, you will be able to recognize when to use Azure SQL Database. FREE ACCESS
-
4. Azure SQL Database GUI Deployment5m 24sDuring this video, you will learn how to deploy an Azure SQL database using the GUI. FREE ACCESS
-
5. Azure SQL Database CLI Deployment4m 34sIn this video, learn how to deploy an Azure SQL database using the CLI. FREE ACCESS
-
6. Azure SQL Database PowerShell Deployment3m 2sIn this video, learn how to deploy an Azure SQL database using PowerShell. FREE ACCESS
-
7. Connect to Azure SQL Database2m 33sFind out how to manage an Azure SQL database from on-premises. FREE ACCESS
-
8. Azure Database Migration Service3m 1sUpon completion of this video, you will be able to describe how the SQL migration process works. FREE ACCESS
-
9. SQL Server Migration Assessment3m 56sIn this video, you will learn how to configure a SQL server assessment project. FREE ACCESS
-
10. Azure SQL Geo-Replication4m 15sIn this video, you will learn how to enable geo-replication for Azure SQL through the Azure portal. FREE ACCESS
-
11. NoSQL Overview2m 50sUpon completion of this video, you will be able to describe NoSQL databases and their use. FREE ACCESS
-
12. CosmosDB1m 56sUpon completion of this video, you will be able to recognize when to use CosmosDB. FREE ACCESS
-
13. Deploy CosmosDB4m 34sDuring this video, you will learn how to create an Azure CosmosDB database using the Azure portal. FREE ACCESS
-
14. Exercise: Choose Azure Database Solutions7m 10sLearn 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.
