DP-900: Azure Data Fundamentals

 

In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about modern data warehousing, real-time analytics, and data visualization. Microsoft Certified Azure Data Fundamentals

Audience Profile

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. DP-900: Azure Data Fundamentals

At Course Completion

After completing this course, students will be able to:

Describe core data concepts

Identify considerations for relational data on Azure

Describe considerations for working with non-relational data on Azure

Describe an analytics workload on Azure

 Course Outline

Module 1: Explore core data concepts

Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure.

Lesson

Core data concepts

Data roles and Services

After completing this module, students will be able to:

Identify how data is defined and stored

Identify characteristics of relational and non-relational data

Describe and differentiate data workloads

Describe and differentiate batch and streaming data

Identify common data professional roles

Identify common cloud services used by data professionals

Module 2: Explore fundamentals of relational data in Azure

Students will explore fundamental relational data concepts and relational database services in Azure.

Lesson

Explore relational data offerings in Azure

Explore Azure services for relational data

Lab : Provision Azure relational database services

After completing this module, students will be able to:

Identify characteristics of relational data

Define normalization

Identify types of SQL statement

Identify common relational database objects

Identify options for Azure SQL services

Identify options for open-source databases in Azure

Provision a database service on Azure

Module 3: Explore fundamentals of non-relational data in Azure

Students will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB.

Lesson

Fundamentals of Azure Storage

Fundamentals of Azure Cosmos DB

Lab : Explore Azure Storage

Lab : Explore Azure Cosmos DB

After completing this module, students will be able to:

Describe features and capabilities of Azure blob storage

Describe features and capabilities of Azure Data Lake Gen2

Describe features and capabilities of Azure file storage

Describe features and capabilities of Azure table storage

Provision and use an Azure Storage account

Describe key features and capabilities of Azure Cosmos DB

Identify the APIs supported in Azure Cosmos DB

Provision and use an Azure Cosmos DB instance

Module 4: Explore fundamentals of data analytics

Students will learn about modern data warehousing, real-time analytics, and data visualization.

Lesson

Modern data warehousing

Streaming and real-time analytics

Data visualization

Lab : Explore Azure Synapse Analytics

Lab : Analyze streaming data

Lab : Visualize data with Power BI

After completing this module, students will be able to:

Identify common elements of a modern data warehousing solution

Describe key features for data ingestion pipelines

Identify common types of analytical data store and related Azure services

Provision Azure Synapse Analytics and use it to ingest, process, and query data

Compare batch and stream processing

Describe common elements of streaming data solutions

Describe features and capabilities of Azure Stream Analytics

Describe features and capabilities of Spark Structured Streaming on Azure

Describe features and capabilities of Azure Synapse Data Explorer

Describe a high-level process for creating reporting solutions with Microsoft Power BI

Describe core principles of analytical data modeling

Identify common types of data visualization and their uses

Create an interactive report with Power BI Desktop

Comments

Post a Comment

Popular posts from this blog

Fundamentos de Microsoft Teams para negocios

  Hoy en día, el trabajo es más colaborativo, diverso y global que nunca. ¿Cómo reúnes a diferentes tipos de equipos, con diversos miembros del equipo de todo el mundo, y les permite trabajar juntos de manera efectiva? Microsoft Teams trae es la respuesta, la solución innovadora para las necesidades modernas de comunicación y colaboración. En este módulo se van a realizar los siguientes temas: Describir las necesidades de comunicación de la fuerza de trabajo moderna. Explicar cómo las reuniones, la voz y los dispositivos de Microsoft Teams pueden hacer que la comunicación y la colaboración sean más eficaces. Teams Usuario Obtenga información sobre cómo planear y administrar reuniones y conferencias de Microsoft Teams. Descubra cómo funcionan las conferencias de audio y los eventos en directo en los equipos. Al final de este módulo, usted debe ser capaz de: Planificar la implementación de reuniones y conferencias. Administrar las directivas y la configuración de la reunión. Gestio...
Read more

Getting A Helping Hand For Setting Up Your Restaurant Business In Dubai

Driven by a growing population, the United Arab Emirates has experienced an unparalleled hike in the food industry. As per the facts and figures suggested by Business Registration and Licensing (BRL), Dubai witnessed a total number of 11,813 restaurants and cafes in the year 2018. This has made it quite easy for the business holders to do business in the city with their favourite cuisines and business strategies influenced by the taste, population, interests, infrastructure or anything else. Opening a restaurant in Dubai isn’t that easy as it seems this is why Dubai Approvals Team is there to make the approval process easy for you. Structural Consultants in Dubai How to open a restaurant business in Dubai? For a rookie, setting up a restaurant business in Dubai may seem to be a quite daunting task. This is why you need professional assistance to strategize each and everything accordingly. If you don’t want to be in any legal trouble with the authorities, you should alway...
Read more

Find the best professionals for architecture!

This is why we at DAT strive to provide you the perfect mixture of contemporary architectural details combined with medieval strength to give you the structure that you always had dreamt of. Keeping in mind your customization and interests; we make structures that look nothing like the one made by mediocre architects. Starting from taking into consideration the basics of engineering and considering the external forces that your building has to bear to the effortlessly flawless designs, we take care of everything that you ever wanted in your structure. Engineering Consultant in Dubai Architectural Engineering Making an architectural delight to brag on From being a place that had nothing more to see than the extending hot scorching deserts to being a place that has seen some of the most astounding architectural developments in the history of men, Dubai has seen a fascinating era of changes in architecture. Be a part of this architectural revolution with DAT. Structural Enginee...
Read more