NILC Microsoft Certified: Azure Data Fundamentals

In a nutshell

In this course, delegates will learn the fundamentals of database concepts in a cloud environment, get basic skills in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure.

This course is available as part of a Personal Learning Account (PLA). PLA is an initiative from the Welsh Government which offers people the chance to access free, part-time courses with flexible and convenient learning that fits around their existing lifestyle (subject to eligibility).

This course is for...

..anyone over 19, living in Wales and in employment. The usual salary limit of £32,371 does not apply for this course.

Course content

This course is delivered by virtual classroom. Virtual classrooms are equivalent to face-to-face classroom courses, but delivered in an online environment.

Course Duration: 1 day

Module 1: Explore core data concepts

Students will learn the fundamentals of database concepts in a cloud environment, get basic skills in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Azure. Students will explore the roles, tasks, and responsibilities in the world of data.

Module 2: Explore relational data in Azure

Students will learn the fundamentals of database concepts in a cloud environment, get basic skills in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students 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

Students will learn the fundamentals of database concepts in a cloud environment, get basic skills in cloud data services, and build their foundational knowledge of cloud data services within Azure. Students 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

Students will learn the fundamentals of database concepts in a cloud environment, get basic skills in cloud data services, and build their foundational knowledge of cloud data services within Azure. Students will explore the processing options available for building data analytics solutions in Azure. Students will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.

After completing this course, delegates 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

Entry Requirements

This course has no formal prerequisites. It is intended for individuals who want to demonstrate foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services.

Additional information

The PLA programme intends to provide quality career advice and guidance to participants before, during and after their learning.

Prior to being enrolled onto your PLA funded course, a individual learning plan will be discussed with you to ensure that the right learning has been considered.

This will include a general discussion on the following topics:

• formal education or qualifications in related fields
• prior experience within the industry or field
• career aspirations
• dedication of time required
• access to internet, windows computer and webcam/microphone

This will also include specific discussion on the below areas for this course:

• any prior experience with cloud computing
• usage of any cloud platforms such as AWS, Google Cloud, or Azure
• interest in pursuing additional Azure qualifications