Microsoft Azure Fundamentals: Databases & Data Analytics

Azure    |    Beginner
  • 11 videos | 1h 3m 35s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 200 users Rating 4.6 of 200 users (200)
Databases can be migrated or deployed into Azure as a managed service. Data analytic solutions are provisioned more quickly and easily than they would be on-premises. In this course, you'll learn how to deploy various managed SQL solutions, such as Microsoft SQL Server, MySQL, and PostgreSQL. You'll explore how to deploy SQL Managed Instance. Next, you'll examine how on-premises database solutions can be migrated to Azure, followed by how to deploy NoSQL solutions such as Cosmos DB. Lastly, you'll examine when data analytic solutions such as Synapse, HDInsight, Databricks and Cognitive Services should be used. This course is one of a collection of courses that prepares learners for the AZ-900 Microsoft Azure Fundamentals certification.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Deploy azure database for mysql
    Deploy azure sql database
    Identify the purpose of sql managed instance
    Deploy sql managed instance
    Describe how the sql migration process works
  • Recognize when to use cosmos db
    Deploy a azure cosmos db database using the portal
    Recognize when to use synapse analytics
    Recognize when to use hdinsight
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 34s
    In this video, you will learn about your instructor. You will also learn more about the course. This entry-level course introduces you to Microsoft Azure. You'll learn Azure's service offerings, such as storage, databases, virtual machines, and database solutions.  FREE ACCESS
  • 9m 17s
    In this video, you will learn about Azure and MySQL. You will learn how to deploy the Azure database from MySQL. The instructor leads you through step-by-step instructions for deployment.  FREE ACCESS
  • Locked
    3.  Deploying Azure Database for Microsoft SQL Server
    9m 24s
    In this video, you will learn how to deploy the Azure database for Microsoft SQL server. You'll see how to deploy this managed service as the instructor leads you through the steps.  FREE ACCESS
  • Locked
    4.  SQL Managed Instance
    6m 35s
    In this video, you will learn about SQL managed instance. This is Microsoft's SQL server. You'll see how it is a platform as a service that offers you configurations in the SQL managed instance itself. You will learn the features and benefits of this managed instance, including its security and ease of connection. FREE ACCESS
  • Locked
    5.  Deploying SQL Managed Instance
    6m 6s
    In this video, you will learn how to deploy Azure SQL managed instance. This is a platform as a service, so you don't have to worry about deploying a virtual machine. The video talks about the features and benefits and offers you step-by-step instructions to get Azure SQL managed instance up and running.  FREE ACCESS
  • Locked
    6.  Azure Database Migration Service
    6m 26s
    In this video, you will learn how to use Azure database migration tool. The video teaches you how to use Azure's database components. Explore Azure's migration services and learn the benefits and features of each.  You will also learn how to use the Azure data migration assistant. The video also explains how the Azure data migration service works. and provides examples.  FREE ACCESS
  • Locked
    7.  Cosmos DB
    4m 53s
    In this video, you will learn how Azure Cosmos DB works. Azure Cosmos DB is a managed, NoSQL database. The video explains the value and benefits of this feature.  FREE ACCESS
  • Locked
    8.  Deploying Cosmos DB
    7m 4s
    In this video, you will learn how to deploy Azure Cosmos DB. The video talks more about what a NoSQL database is, and takes you step-by-step through deployment using the portal.  FREE ACCESS
  • Locked
    9.  Azure Synapse Analytics
    6m 9s
    In this video, you will learn about Azure Synapse Analytics. This is a managed service in the Azure cloud that is used for data analytics. It integrates with BI, or business intelligence. You'll learn how tool allows users to create their own visualizations based on complex datasets.  The video also explains how Synapse analyzes data as well as how it provisions data. You will also learn how to create a Synapse workspace and add a Spark Pool. In addition, the video explains how to use the Azure Synapse Studio.  FREE ACCESS
  • Locked
    10.  Azure HDInsight
    4m 5s
    In this video, you will learn about Azure HDInsight. This is an analytics service. You will learn the differences between Azure HDInsight and Azure Databricks. The video also explains Azure Cognitive Services and what it is used for.  FREE ACCESS
  • Locked
    11.  Course Summary
    1m 1s
    This video sums up the course. You've learned how to use Azure database and its data analysis service offerings. You've learned about Azure database for MySQL, SQL managed instance, and Cosmos DB. You also learned about HDInsights, Databricks, Azure machine learning, and cognitive learning.   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 Working with Google Cloud SQL: An Introduction to Cloud SQL
Rating 4.7 of 37 users Rating 4.7 of 37 users (37)
Journey Working with Microsoft Azure SQL
Rating 4.6 of 5 users Rating 4.6 of 5 users (5)
Course Microsoft Azure Fundamentals: Cloud Computing
Rating 5.0 of 3 users Rating 5.0 of 3 users (3)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Microsoft Azure Fundamentals: App Services
Rating 4.6 of 272 users Rating 4.6 of 272 users (272)
Course Microsoft Azure Infrastructure Solutions: Data Solutions
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Course Azure Data Scientist Associate: Azure Data Factory
Rating 4.8 of 53 users Rating 4.8 of 53 users (53)