Back to catalogue

Microsoft Azure Data Fundamentals (DP-900T00)

Learn the fundamental concepts of databases in a cloud environment and gain skills in the Microsoft Azure data services.
Microsoft Partner
Private session

This training is available in a private or personalized format. It can be provided in one of our training centres or at your offices. Call one of our consultants of submit a request online.

Call now at 1 877 624.2344

  • Duration: 1 day
  • Regular price: On request

Course outline

Duration : 1 jour

In this course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling 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. They will explore the roles, tasks, and responsibilities in the world of data. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. They will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure. Students will explore the processing options available for building data analytics solutions in Azure. They 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.

Audience

The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.

Objectives

  • 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

Contents

Module 1: Explore core data concepts

Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling 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.

Lessons

  • Explore core data concepts
  • Explore roles and responsiblities in the world of data
  • Describe concepts of relational data
  • Explore concepts of non-relational data
  • Explore concepts of data analytics

After completing this module, students will be able to:

  • Show foundational knowledge of cloud data services within Azure
  • Identify and describe core data concepts such as relational, non-relational, big data, and analytics
  • Explain how this technology is implemented with Azure

Module 2: Explore relational data in Azure

Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling 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.

Lessons

  • Explore relational data offerings in Azure
  • Explore provisioning and deploying relational database offerings in Azure
  • Query relational data in Azure

After completing this module, students will be able to:

  • Describe relational data offerings on Azure
  • Explain provisioning and deploying relational databases on Azure
  • Query relational data through cloud data solutions in Azure

Module 3: Explore non-relational data in Azure

Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling 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.

Lessons

  • Explore non-relational data offerings in Azure
  • Explore provisioning and deploying non-relational data services on Azure
  • Manage non-relational data stores in Azure

After completing this module, students will be able to:

  • Describe non-relational data offerings on Azure
  • Explain provisioning and deploying non-relational databases on Azure
  • Decribe non-relational data stores on Azure

Module 4: Explore modern data warehouse analytics in Azure

Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling 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.

Lessons

  • Examine components of a modern data warehouse
  • Explore data ingestion in Azure
  • Explore data storage and processing in Azure
  • Get started building with Power BI

After completing this module, students will be able to:

  • Describe processing options available for building data analytics solutions in Azure
  • Describe Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
  • Explain what Microsoft Power BI is, including its building blocks and how they work together

Surround yourself with the best

Charles Bourgon
Trainer
Frédéric Paradis
Frédéric Paradis
Certified Trainer and Cloud Architect
As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.
Marc Maisonneuve
Marc Maisonneuve
Training program director
Marc Maisonneuve has acted as a Training Program Director, professional effectiveness trainer and user tools practice leader at AFI for several years. Mr. Maisonneuve is known for his analytical skills, his legendary calm and his undeniable desire to encourage people to develop their skills. He has the ability to present technological solutions in a natural way and to adapt them to the concrete needs of the workplace.
Vicky Moreau
Vicky Moreau
Trainer
Vicky Moreau is a passionate freelancer and professional in the area of office automation. She holds a college diploma in office automation, most of her solid experience with the Office Suite was acquired while being an autodidact. In fact, she has successfully completed an MOS (Microsoft Office Specialist) Excel certification.