Curso DP-700T00 Microsoft Fabric Data Engineer
32 horasVisã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áticoConteú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