ICT 903 - Microsoft Azure Data Fundamentals

Course Description

This course is designed for learners trying to learn the fundamentals of data platform concepts in a cloud environment. It is intended for those with minimal technical background, who are looking to get basic skilling in cloud data services and are looking to build their foundational knowledge of cloud data services within Microsoft Azure. Learners will be able to identify and describe core data concepts such as relational, non-relational, big data and analytics, and how this technology is implemented, through cloud data-solutions with Microsoft Azure.

This course can be taken as an optional first step in learning about cloud data services with Microsoft Azure, before taking further Microsoft Azure or data related role-based certifications.

This course covers the objectives for Microsoft Exam DP-900: Microsoft Azure Fundamentals. This exam is required to fulfil the requirements of the Microsoft Certified: Azure Data Fundamentals professional certification. Each learner enrolled in this course will be eligible for one attempt to write the Microsoft Azure Data Fundamentals Certification Exam (DP-900) before January 29, 2022

This course is funded by the Canada Skills initiative, and is delivered in collaboration with Microsoft Canada.

Course Details

Learning Outcomes

By completion of this course, successful students will be able to:

• Describe core data concepts in Azure.
• Explain concepts of relational data in Azure.
• Explain concepts of non-relational data in Azure.
• Identify components of a modern data warehouse in Azure.

Topics

Module 1 - Explore Core Data Concepts
In this module, you will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure.

Module 2 - Explore Relational Data in Azure
In this module, you will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Azure.

Module 3 - Explore Non-relational Data in Azure
In this module, you will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure.

Module 4 - Explore Modern Data Warehouse Analytics in Azure
In this module, you will you will explore the processing options available for building data analytics solutions in Azure. You will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. You'll Learn what Power BI is, including its building blocks and how they work together.

Who is this course for?

The Azure Data Fundamentals course is designed for anyone interested in foundational-level knowledge of cloud data, and how cloud data services are provided with Microsoft Azure.

This course can be used to prepare candidates for other Azure role-based certifications like Designing and Implementing a Data Science Solution on Azure and Administering Relational Databases on Microsoft Azure. It designed for those who wish to pursue future careers like:

• Database Administrator
• Data Engineer
• Data Analyst

Notes

Software Requirements (Optional)

The lab activities are optional. To complete the labs in this course, you will need:

• Microsoft Azure Subscription (Trial / Student / Pay-as-you-go)
• Visit https://azure.microsoft.com/en-ca/free for more information