Curso DP-700T00 Microsoft Fabric Data Engineer

  • Tableau Data Visualization

Curso DP-700T00 Microsoft Fabric Data Engineer

32 horas
Visão Geral

Este Curso DP-700T00 Engenheiro de Dados do Microsoft Fabric aborda métodos e práticas para implementar soluções de engenharia de dados usando o Microsoft Fabric. Os alunos aprenderão a projetar e desenvolver padrões eficazes de carregamento de dados, arquiteturas de dados e processos de orquestração. Os objetivos deste curso incluem a ingestão e transformação de dados, além de proteger, gerenciar e monitorar soluções de engenharia de dados. Este curso é voltado para profissionais de dados experientes em integração e orquestração de dados, como aqueles com a certificação DP-203: Azure Data Engineer.

DP-700T00 Engenheiro de Dados do Microsoft Fabric

Transforme suas habilidades de engenharia de dados com o Microsoft Fabric. No mundo acelerado da análise de dados, manter-se à frente significa dominar as ferramentas e metodologias mais recentes. O curso DP-700T00 oferece experiência prática com o Microsoft Fabric, capacitando você a projetar padrões de carregamento de dados eficientes, arquitetar soluções de dados robustas e orquestrar processos complexos com perfeição.

Ao se aprofundar na ingestão, transformação e segurança de dados, você estará preparado para lidar com análises em escala empresarial com confiança. Este curso é perfeito para profissionais de dados interessados ​​em aprimorar suas capacidades de integração e orquestração.

Principais benefícios:

  • Crie estratégias eficazes de carregamento de dados adaptadas a cenários do mundo real.
  • Crie soluções de dados escaláveis ​​que atendam às demandas organizacionais.
  • Implemente medidas de segurança robustas para proteger informações confidenciais.
Objetivo

Após realizar este Curso DP-700T00 - Microsoft Fabric Data Engineer, você será capaz de:

  • Ingira e transforme dados usando o Dataflows Gen2 no Microsoft Fabric.
  • Crie e monitore pipelines de dados para uma orquestração perfeita.
  • Capture, analise e visualize dados de eventos em tempo real com o Eventstreams.
  • Crie lakehouses e consulte dados com Spark e SQL.
  • Implementar arquitetura de medalhão para organização eficiente de dados.
  • Proteja o acesso aos dados e gerencie permissões no Microsoft Fabric.
  • Desenvolva painéis em tempo real para obter insights práticos.
  • Automatize implantações com CI/CD e monitore atividades usando o Monitoring Hub.
Publico Alvo
  • Engenheiros de dados;
  • Analistas de dados;
  • Arquitetos de dados;
  • Profissionais de BI;
  • Desenvolvedores que trabalham com dados;
  • Consultores e especialistas em soluções de dados baseadas na nuvem.
Pre-Requisitos
  • Não há pré-requisitos necessários para participar deste curso.
Materiais
Inglês/Português/Lab Prático
Conteúdo Programatico

Implement a data warehouse with Microsoft Fabric

  • Get started with data warehouses in Microsoft Fabric
    • Describe data warehouses in Fabric.
    • Understand a data warehouse vs a data Lakehouse.
    • Work with data warehouses in Fabric.
    • Create and manage fact tables and dimensions within a data warehouse.
    • Lab: Analyze data in a data warehouse
  • Load data into a Microsoft Fabric data warehouse
    • Learn different strategies to load data into a data warehouse in Microsoft Fabric.
    • Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
    • Learn how to load data in a warehouse using T-SQL.
    • Learn how to load and transform data with dataflow (Gen 2).
    • Lab: Load data into a warehouse in Microsoft Fabric
  • Query a data warehouse in Microsoft Fabric
    • Use SQL query editor to query a data warehouse.
    • Explore how visual query editor works.
    • Learn how to connect and query a data warehouse using SQL Server Management Studio.
    • Lab: Query a data warehouse in Microsoft Fabric
  • Monitor a Microsoft Fabric data warehouse
    • Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
    • Monitor current activity in the data warehouse with dynamic management views.
    • Monitor querying trends with query insights views.
    • Lab: Monitor a data warehouse in Microsoft Fabric
  • Secure a Microsoft Fabric data warehouse
    • Learn the concepts of securing a data warehouse in Microsoft Fabric.
    • Learn how to implement dynamic data masking to obscure sensitive information.
    • Learn how to configure row-level security to provide granular control.
    • Learn how to implement column-level security to protect sensitive data.
    • Learn how to configure granular permissions using T-SQL.
    • Lab: Secure a warehouse in Microsoft Fabric

Ingest data with Microsoft Fabric

  • Ingest Data with Dataflows Gen2 in Microsoft Fabric
    • Describe Dataflow capabilities in Microsoft Fabric
    • Create Dataflow solutions to ingest and transform data
    • Include a Dataflow in a pipeline
    • Lab: Create and use a Dataflow Gen2 in Microsoft Fabric
  • Orchestrate processes and data movement with Microsoft Fabric
    • Describe pipeline capabilities in Microsoft Fabric.
    • Use the Copy Data activity in a pipeline.
    • Create pipelines based on predefined templates.
    • Run and monitor pipelines.
    • Lab: Ingest data with a pipeline
  • Get started with Real-Time Intelligence in Microsoft Fabric
    • Microsoft Fabric includes Real-Time Intelligence capabilities that you can use to capture, analyze, visualize, and act on real-time streams of event data.
    • Lab: Explore Real-Time Intelligence in Fabric
  • Use real-time eventstreams in Microsoft Fabric
    • Establish source and destinations in Microsoft Fabric Eventstreams.
    • Capture, transform, and route data using Microsoft Fabric Eventstreams.
    • Lab: Ingest real-time data with Eventstream in Microsoft Fabric
  • Work with real-time data in a Microsoft Fabric eventhouse
    • Create an eventhouse in Microsoft Fabric
    • Query real-time data by using Kusto Query Language (KQL).
    • Create materialized views and stored functions in a KQL database.
    • Lab: Work with data in a Microsoft Fabric eventhouse

Implement a Lakehouse with Microsoft Fabric

  • Introduction to end-to-end analytics using Microsoft Fabric
    • Describe end-to-end analytics in Microsoft Fabric
  • Get started with lakehouses in Microsoft Fabric
    • Describe core features and capabilities of lakehouses in Microsoft Fabric.
    • Create a lakehouse.
    • Ingest data into files and tables in a lakehouse.
    • Query lakehouse tables with SQL.
    • Lab: Create a Microsoft Fabric lakehouse
  • Use Apache Spark in Microsoft Fabric
    • Configure Spark in a Microsoft Fabric workspace
    • Identify suitable scenarios for Spark notebooks and Spark jobs
    • Use Spark dataframes to analyze and transform data
    • Use Spark SQL to query data in tables and views
    • Visualize data in a Spark notebook
    • Lab: Analyze data with Apache Spark
  • Work with Delta Lake tables in Microsoft Fabric
    • Understand Delta Lake and delta tables in Microsoft Fabric
    • Create and manage delta tables using Spark
    • Optimize delta tables
    • Use Spark to query and transform data in delta tables
    • Use delta tables with Spark structured streaming
    • Lab: Use delta tables in Apache Spark
  • Ingest Data with Dataflows Gen2 in Microsoft Fabric
    • Describe Dataflow capabilities in Microsoft Fabric
    • Create Dataflow solutions to ingest and transform data
    • Include a Dataflow in a pipeline
    • Lab: Create and use a Dataflow Gen2 in Microsoft Fabric
  • Orchestrate processes and data movement with Microsoft Fabric
    • Describe pipeline capabilities in Microsoft Fabric.
    • Use the Copy Data activity in a pipeline.
    • Create pipelines based on predefined templates.
    • Run and monitor pipelines.
    • Lab: Ingest data with a pipeline
  • Organize a Fabric lakehouse using medallion architecture design
    • Describe the principles of using the medallion architecture in data management.
    • Apply the medallion architecture framework within the Microsoft Fabric environment.
    • Analyze data stored in the lakehouse using DirectLake in Power BI.
    • Describe best practices for ensuring the security and governance of data stored in the medallion architecture.
    • Lab: Organize your Fabric lakehouse using a medallion architecture

Implement Real-Time Intelligence with Microsoft Fabric

  • Get started with Real-Time Intelligence in Microsoft Fabric
    • Microsoft Fabric includes Real-Time Intelligence capabilities that you can use to capture, analyze, visualize, and act on real-time streams of event data.
    • Lab: Explore Real-Time Intelligence in Fabric
  • Use real-time eventstreams in Microsoft Fabric
    • Establish source and destinations in Microsoft Fabric Eventstreams.
    • Capture, transform, and route data using Microsoft Fabric Eventstreams.
    • Lab: Ingest real-time data with Eventstream in Microsoft Fabric
  • Work with real-time data in a Microsoft Fabric eventhouse
    • Create an eventhouse in Microsoft Fabric
    • Query real-time data by using Kusto Query Language (KQL).
    • Create materialized views and stored functions in a KQL database.
    • Lab: Work with data in a Microsoft Fabric eventhouse
  • Create Real-Time Dashboards with Microsoft Fabric
    • Create a real-time dashboard in Microsoft Fabric.
    • Use advanced feature of real-time dashboards.
    • Apply best practices for real-time dashboards.
    • Lab: Get started with real-time dashboards

Manage a Microsoft Fabric environment

  • Implement continuous integration and continuous delivery (CI/CD) in Microsoft Fabric
    • Define CI/CD and describe how it's implemented in Fabric.
    • Implement version control and Git integration.
    • Use deployment pipelines to automate the deployment process.
    • Lab: Implement deployment pipelines in Microsoft Fabricmate CI/CD using Fabric APIs.
  • Monitor activities in Microsoft Fabric
    • Apply monitoring concepts to Microsoft Fabric
    • Use Monitoring Hub in Microsoft Fabric
    • Trigger actions using Activator in Microsoft Fabric
    • Lab: Monitor Fabric activity in the Monitor hub
  • Secure data access in Microsoft Fabric
    • Describe the permissions model in Microsoft Fabric.
    • Configure workspace and item permissions.
    • Apply granular permissions.
    • Lab: Secure data access in Microsoft Fabric
  • Administer a Microsoft Fabric environment
    • Describe Fabric admin tasks
    • Navigate the admin center
    • Manage user access
    • Govern data in Fabric
TENHO INTERESSE

Cursos Relacionados

Curso Análise de Dados Com o Power BI - 20778B

24 horas

Curso Análise de dados Excel Com Power BI - 20779B

16 horas

Curso Talend Data Integration Foundation

16 horas

Curso Talend Data Integration Advanced

16 horas

Curso Advanced Data Analysis and Dashboard Reporting

28 horas