Training: Data Engineering on Microsoft Azure (Exam: DP-203)
Data Visualisatie
42 uur
Engels (US)

Training: Data Engineering on Microsoft Azure (Exam: DP-203)

Vanaf € 422,29 € 349,00

Vanaf € 422,29 € 349,00

Extra opties

1 x Training: Data Engineering on Microsoft Azure (Exam: DP-203)   + € 422,29 € 349,00
€ 349,00
Incl. BTW

Snel navigeren naar:

  • Informatie
  • Inhoud
  • Kenmerken
  • Meer informatie
  • Reviews
  • FAQ

Productinformatie

In deze online training maak jij kennis met data engineering in Microsoft Azure. Je leert uitgebreid gebruikmaken van dataplatform technologieën voor bedrijfskundige en technische processen. Het gebruik van relational en no-SQL data komt aan bod.
Deze training bereidt je tevens voor op het DP-203 Data Engineering on Microsoft Azure examen. Wanneer je dit examen hebt behaald, ben je gecertificeerd voor de rol van Microsoft Azure Data Engineer Associate. Azure Data Engineers integreren, transformeren en consolideren gegevens van verschillende gestructureerde en ongestructureerde gegevenssystemen tot structuren die geschikt zijn voor het bouwen van analyseoplossingen.

De volgende trainingen komen in deze training aan

bod:

  • Opslag accounts (Microsoft Azure Blob storage, Data Lake Storage Gen2)
  • Ontwerpen van structuren voor data-opslag
  • Strategieën voor data partitioning
  • Ontwerpen van serving layers
  • Fysieke data-opslag structuren (Azure SQL databases, Azure Synapse Analytics)
  • Logische datastructuren
  • Serving layer
  • Databeleid en standaarden
  • Beveiligen van data en de toegang tot data (Azure Key Vault, token-based authentication
  • Data Lake opslag
  • Data Flow transformaties
  • Data Factory
  • Data Bricks
  • Stream Analytics en Synapse Analytics
  • Monitoren en optimaliseren van data-opslag en dataverwerking

Inhoud van de training

Data Engineering on Microsoft Azure (Exam: DP-203)

42 uur

DP-203 - Data Engineering on Microsoft Azure: Storage Accounts

  • Microsoft Azure Blob storage is a container system for storing a

  • variety of file types. In this course, you'll learn about the
  • capabilities of blob storage and how to architect a deployment for
  • optimal performance and scalability. Then, you'll explore the
  • options for redundancy and how to recover from disasters. You'll
  • discover where Azure Data Lake Storage Gen2, a feature set within
  • blob storage, can be utilized for big data operations. You'll also
  • learn how to plan for a data lake deployment, examine best
  • practices, and explore how to deploy a Data Lake Gen2 account on
  • Azure. This course is one in a collection that prepares learners
  • for the Microsoft Data Engineering on Microsoft Azure (DP-203)
  • exam.

DP-203 - Data Engineering on Microsoft Azure: Designing Data Storage Structures

  • Planning the structure for data storage is integral to

  • performance in big data operations. In this course, you'll learn
  • about key considerations for data lakes and how to determine which
  • file type and file format are the most appropriate for your use
  • case. Then, you'll explore how to define how to design table
  • storage for efficient querying and how data pruning can remove
  • unnecessary data to accelerate transactions. You'll examine folder
  • structures and data lake zones for organizing data effectively.
  • Finally, you'll learn how to define storage tiers and how to manage
  • the life cycle of data. This course is one in a collection that
  • prepares learners for the Microsoft Data Engineering on Microsoft
  • Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Data Partitioning

  • Partitioning data is key to ensuring efficient processing. In

  • this course, you'll explore what data partitioning is and the
  • strategies for implementation. You'll learn about transactional and
  • analytical workloads and how to determine the best strategy for
  • your files and table storage. Then, you'll examine design patterns
  • for efficiency and performance. You'll learn about partitioning
  • dedicated SQL pools in Azure Synapse Analytics and partitioning
  • data lakes. Finally, you'll learn how data sharding across multiple
  • data stores can be used for improving transaction performance. This
  • course is one in a collection that prepares learners for the
  • Microsoft Data Engineering on Microsoft Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Designing the Serving Layer

  • The serving layer is where data is stored for consumption by

  • processing services. In this course, you'll explore dimensional
  • data modeling and hierarchies. You'll learn how to define slowly
  • changing dimensions and temporal design within databases. Then,
  • you'll learn about the differences between the star and snowflake
  • schemas as well as how to design a star schema. Next, you'll
  • examine incremental data loading for stream processing and the
  • options for analytical data stores. Finally, you'll learn about
  • options for creating metastores for use by Azure Databricks and
  • Azure Synapse Analytics. This course is one in a collection that
  • prepares learners for the Microsoft Data Engineering on Microsoft
  • Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Physical Data Storage Structures

  • An effective storage structure is critical to big data

  • implementation success. In this course, you'll explore data
  • compression in databases and file storage. Then, you'll discover
  • how partitioning and sharding are implemented in the database.
  • Next, you'll explore designing tables in an Azure Synapse Analytics
  • dedicated SQL pool, and implement geo-replication for redundancy in
  • both databases and Azure Blob storage. You'll also discover
  • implementing distribution schemes in Azure Synapse Analytics.
  • Finally, you'll discover data archiving and long-term retention
  • policies for Azure Blob storage and Azure SQL Databases. This
  • course is one in a collection that prepares learners for the
  • Microsoft Data Engineering on Microsoft Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Logical Data Structures

  • Logical data structures, also called entity-relationship models,
  • are models used to define a high-level model of data and the
  • relationships contained within. In this course, you'll learn about
  • the stages of data lake maturity. You'll explore temporal database
  • tables and how to manage them. You'll also learn how to define
  • slowly changing dimensions and how to implement them. You'll then
  • move on to explore logical file and folder structures for data
  • ingestion. You'll discover how PolyBase can be used to connect to
  • external tables. Finally, you'll explore the best practices for
  • accelerating queries. This course is one in a collection that
  • prepares learners for the Data Engineering on Microsoft Azure
  • (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: The Serving Layer

  • Implementing an effective serving layer requires consideration

  • for the design, methods, and tools. In this course, you'll learn
  • how traditional relational models can be replaced by the star
  • schema and how to design a star schema. Then, you'll explore the
  • purpose and structure of Parquet files used by Azure Databricks.
  • You'll learn how to design and query a dimensional hierarchy.
  • You'll move on to examine Azure Synapse Analytics, including
  • deploying dedicated SQL pools and Apache Spark clusters. Finally
  • you'll learn how to create shared metadata tables between Spark
  • clusters. This course is one in a collection that prepares learners
  • for the Microsoft Data Engineering on Microsoft Azure (DP-203)
  • exam.

DP-203 - Data Engineering on Microsoft Azure: Data Policies & Standards

  • Data policies and standards help to ensure a repeatable security

  • standard is maintained. In this course, you'll learn about data
  • encryption scenarios and best practices. You'll explore how Azure
  • Transparent Database Encryption and Always Encrypted can be used to
  • ensure data at rest is protected. Next, you'll examine how data
  • classification and data masking can protect data being viewed.
  • You'll learn to configure data retention and purging to ensure data
  • is retained or removed. You'll also explore the various means of
  • controlling access to Azure Data Lake Storage Gen2. Finally, you'll
  • learn how to plan a data auditing strategy and how to limit access
  • to data at the row level in a database. This course is one in a
  • collection that prepares learners for the Microsoft Data
  • Engineering on Microsoft Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Securing Data Access

  • Securing access to data is a fundamental part of any security

  • strategy. In this course, you'll explore how Azure Key Vault can be
  • used to store and manage keys and secrets for accessing data.
  • You'll discover how to connect to Azure resources through private
  • and service endpoints and managed virtual networks and how to use
  • Azure managed identities for connections between Azure resources.
  • Next, you'll learn how to utilize access control lists and Azure
  • role-based access control to provide only the necessary permissions
  • to users to access your data. You'll also learn how token-based
  • authentication works in Azure Databricks. Finally, you'll examine
  • how to audit an Azure SQL Database to monitor for unauthorized
  • access. This course is one in a collection that prepares learners
  • for the Microsoft Data Engineering on Microsoft Azure (DP-203)
  • exam.

Data Engineering on Microsoft Azure: Securing Data

The final line of defense for protecting against a data breach is securing the data itself. With today's cloud environments, data is often in transit, duplicated, and stored in various data centers around the world, making effective data protection a challenge.

In this course, you'll explore the various methods available for encrypting data stored in SQL databases. You'll examine how to use DataFrames in Databricks, as well as how to implement Advanced Threat Protection and dynamic data masking in Azure databases. Finally, you'll learn how immutable blobs can be used to manage sensitive information.

This course is one in a collection that prepares learners for the Microsoft Data Engineering on Microsoft Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Data Lake Storage

  • Azure Data Lake Storage Gen2 provides features to work with big
  • data analytics using Azure Blob Storage. Azure Blob Storage systems
  • provide performance, management, and security functionality. In
  • this course, you'll learn about the features of the Azure Data Lake
  • Storage Gen2 and when to use this storage type. You'll explore
  • features and methods for securing data for the Azure Data Lake
  • Storage Gen2 service and data at rest. You'll examine methods for
  • processing big data using the Azure Data Lake Storage Gen2 service
  • and monitoring Azure Blob Storage. You'll learn how to manage
  • directories, files, and Access Control Lists in Azure Data Lake
  • Storage Gen2 using the .NET framework, as well as how to perform
  • extract, transform, and load operations using Azure Databricks from
  • Azure Data Lake Storage Gen2. Finally, you'll learn how to access
  • Azure Data Lake Storage Gen2 data using Azure Databricks and Spark.
  • This course is one in a collection that prepares learners for the
  • Microsoft Data Engineering on Microsoft Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Data Flow Transformations

  • One of the key components of the Azure Cloud platform is the

  • ability to store and process large amounts of data. Azure Data Flow
  • Transformations can be used to ingest and transform data. In this
  • course, you'll learn about the types of Azure Data Flow
  • transformations that are available. You'll explore how to
  • transform, split, and flatten data, as well as handle duplicate
  • data, using Azure Data Mapping Data Flows. Next, you'll examine the
  • types of expression functions available in Azure Data Flow and how
  • to perform error handling for data rows that would truncate data.
  • Finally, you'll learn how to transform and use derived columns to
  • normalize data values, and how to ingest and transform data using
  • Azure Spark and Scala. This course is one in a collection that
  • prepares learners for the Microsoft Data Engineering on Microsoft
  • Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Data Factory

  • Once you have data in storage, you'll need to have some

  • mechanism for transforming the data into a usable format. Azure
  • Data Factory is a data integration service that is used to create
  • automated data pipelines that can be used to copy and transform
  • data. In this course, you'll learn about the Azure Data Factory and
  • the Integration Runtime. You'll explore the features of the Azure
  • Data Factory such as linked services and datasets, pipelines and
  • activities, and triggers. Finally, you'll learn how to create an
  • Azure Data Factory using the Azure portal, create Azure Data
  • Factory linked services and datasets, create Azure Data Factory
  • pipelines and activities, and trigger the pipeline manually or
  • using a schedule. This course is one in a collection that prepares
  • learners for the Microsoft Data Engineering on Microsoft Azure
  • (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Databricks

  • When working with big data, there needs to be a mechanism to

  • process and transform this data quickly and efficiently. Azure
  • Databricks is a service that provides the latest version of Apache
  • Spark, which provides functionality for machine learning and data
  • warehousing. In this course, you'll learn about the features of
  • Azure Databricks such as clusters, notebooks, and jobs. Next,
  • you'll learn about autoscaling local storage when configuring
  • clusters. Next, you'll explore how to create, manage, and configure
  • Azure Databricks clusters, as well as how to create, open, use, and
  • delete notebooks. Finally, you'll learn how to create, open, use,
  • and delete jobs. This course is one in a collection that prepares
  • learners for the Microsoft Data Engineering on Microsoft Azure
  • (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Databrick Processing

  • When working with big data there needs to be a mechanism to
  • process and transform this data quickly and efficiently. Azure
  • Databricks is a service that provides the latest version of Apache
  • Spark that provides functionality processing data from Azure
  • Storage. In this course, you will learn about the types of
  • processing that can be performed with Azure Databricks such as
  • stream, batch, image and parallel processing. Next, you'll learn
  • how to create an Azure Databricks workspace using an Apache Spark
  • cluster, run jobs in the Azure Databricks Workspace jobs using a
  • service principal and query data in SQL server using an Azure
  • Databricks notebook. Next, you'll learn how to retrieve data from
  • an Azure Blob Storage using Azure Databricks and the Azure Key
  • Vault, implement a Cosmos DB service endpoint for Azure Databricks,
  • and extract, transform, and load data using Azure Databricks.
  • Finally, you'll learn how to stream data into Azure Databricks by
  • using Event Hubs and perform sentiment analysis for steam data by
  • making use of Azure Databricks. This course is one in a collection
  • that prepares learners for the Microsoft Data Engineering on
  • Microsoft Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Stream Analytics

  • Azure Stream Analytics is a complex, serverless, and highly

  • scalable processing engine that can be used to perform real-time
  • analytics on multiple data streams. Alerts can be configured to
  • forecast trends, trigger workflows, and detect irregularities. In
  • this course, you'll learn to use Azure Stream Analytics to process
  • streaming data. You'll examine how to implement security, create
  • user-defined functions, and optimize jobs for Azure Stream
  • Analytics, as well as explore the available inputs and outputs.
  • Finally, you'll learn how to create an Azure Stream Analytics job,
  • create an Azure Stream Analytics dedicated cluster, run Azure
  • Functions from Azure Stream Analytics jobs, and monitor Azure
  • Stream Analytics jobs. This course is one in a collection that
  • prepares learners for the Microsoft Data Engineering on Microsoft
  • Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Synapse Analytics

  • Azure Synapse Analytics is an analytics service that provides

  • functionality for data integration, enterprise data warehousing,
  • and big data analytics. Services provided include ingesting,
  • exploring, preparing, managing, and serving data for BI and machine
  • learning needs. In this course, you'll learn about the Azure
  • Synapse Analytics platform and how it is used for data warehousing
  • and big data analytics. Next, you'll learn how to create a Synapse
  • Workspace, a dedicated SQL pool, and a serverless Apache Spark
  • pool. You'll move on to explore how to analyze data using a
  • dedicated SQL pool, Apache Spark for Azure Synapse, Serverless SQL
  • Pools, and a Spark database, as well as how to analyze data that is
  • in a storage account. You'll learn how to integrate pipelines using
  • Synapse Studio, visualize data using a Power BI workspace, and
  • monitor a Synapse Workspace. Finally, you'll learn about the
  • Synapse Knowledge Center and the features of Azure Synapse
  • Analytics and PolyBase. This course is one in a collection that
  • prepares learners for the Microsoft Data Engineering on Microsoft
  • Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Data Storage Monitoring

  • Being able to monitor data storage systems to ensure they are

  • operational and working correctly is a crucial part of running your
  • business. Azure provides the Azure Monitor service and the Azure
  • Log Analytics service to perform this function. In this course,
  • you'll learn about the features of Azure Log Analytics, as well as
  • the Azure Monitor service and how it can be used to monitor storage
  • data and monitor Azure Blob storage. Next, you'll explore how to
  • access diagnostic logs to monitor Data Lake Storage Gen2, monitor
  • the Azure Synapse Analytics jobs and the adaptive cache, and
  • monitor Azure Cosmos DB using the portal and resource logs.
  • Finally, you'll examine how to configure, manage, and view metric
  • alerts using the Azure Monitor and activity log alerts using the
  • Azure Monitor. This course is one in a collection that prepares
  • learners for the Microsoft Data Engineering on Microsoft Azure
  • (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Data Process Monitoring

  • Being able to monitor data processes to ensure they are

  • operational and working correctly is a crucial part of running your
  • business. Azure provides the Azure Monitor service and the Azure
  • Log Analytics service to perform this function. In this course,
  • you'll learn about the features of the Azure Monitor tools and the
  • concepts of continuous monitoring and visualization. Next, you'll
  • examine how to create metric charts using the Azure Monitor, as
  • well as how to collect and analyze Azure resource log data and
  • perform queries against the Azure Monitor logs. You'll explore how
  • to create and share dashboards that display data from Log
  • Analytics, create Azure Monitor alerts, and use the Azure Data
  • Factory Analytics solution to monitor pipelines. You'll learn how
  • to send the Azure Databricks logs to the Azure Monitor and use the
  • dashboard to analyze the Azure Databricks metrics. Finally, you'll
  • learn how to enable monitoring for Azure Stream Analytics and
  • configure alerts, and also query Azure Log Analytics and filter,
  • sort, and group query results. This course is one in a collection
  • that prepares learners for the Microsoft Data Engineering on
  • Microsoft Azure (DP-203) exam.

DP-203 - Data Engineering on Microsoft Azure: Data Solution Optimization

  • Ensuring that data storage and processing systems are operating

  • efficiently will allow your organization to save both time and
  • money. There are several tips and tricks that can be used to
  • optimize both Azure Data Storage service and processes. In this
  • course, you'll learn about cloud optimization, as well as some best
  • practices for optimizing data using data partitions, Azure Data
  • Lake Storage tuning, Azure Synapse Analytics tuning, and Azure
  • Databricks auto-optimizing. Next, you'll learn about strategies for
  • partitioning data using Azure-based storage solutions. You'll learn
  • about the stages of the Azure Blob lifecycle management and how to
  • optimize Azure Data Lake Storage Gen2, Azure Stream Analytics, and
  • Azure Synapse Analytics. Finally, you'll explore how to optimize
  • Azure Data Storage services such Azure Cosmos DB using indexing and
  • partitioning, as well as Azure Blob Storage and Azure Databricks.
  • This course is one in a collection that prepares learners for the
  • Microsoft Data Engineering on Microsoft Azure (DP-203) exam.

Kenmerken

Engels (US)
42 uur
Data Visualisatie
180 dagen online toegang
HBO

Meer informatie

Extra product informatie 0
Doelgroep Data-analist
Voorkennis

Je beschikt over kennis van Microsoft Azure Data Fundamentals (DP-900) of gelijkaardige kennis.

resultaat

Na succesvolle afronding van deze training kun jij verschillende dataplatform technologieën implementeren gericht op data-opslag, dataverwerking en databeveiliging. Daarnaast ben je optimaal voorbereid op het DP-203 Data Engineering on Microsoft Azure examen.


Positieve reacties van cursisten

Training: Leidinggeven aan de AI transformatie

Al jaren is icttrainingen.nl onze trouwe partner op het gebied van kennisontwikkeling voor onze IT-ers. Wij zijn blij dat wij door het platform van icttrainingen.nl maatwerk en een groot aanbod aan opleidingen kunnen bieden aan ons personeel.

- Loranne, Teamlead bij Inwork

Ontwikkel je tot data analist

Service is echt heel goed. Snel, klantvriendelijk, weten waar ze over praten en denken met je mee met oplossingen. Daarnaast hebben ze ook een goed leerplatform om je studie te volgen en na elke module een korte toets om te zien hoeveel je ervan heb begrepen en je kan de status zien hoeveel tijd je hebt besteed aan je studie. Ik waardeer ze enorm en ik raad elke ICT'er aan om met hen in zee te gaan om je studie te volgen.

- Emilio Jones

Training: Introduction to SQL

Eén training geprobeerd en deze naar tevredenheid gevolgd. Een module werkte in eerste instantie niet, maar na contact opgenomen te hebben met klantenservice kreeg ik snel antwoord met een oplossing.

- Lars van der Spek

Training: Certified Ethical Hacker (CEHv12) - incl. examen

Eerste keer dat ik een online training heb gedaan en zou zo weer een training volgen via icttrainingen.nl

- Jerry Jialal

Training: Microsoft Managing Modern Desktops (exam MD-101)

Het resultaat van de groep is absoluut bevredigend. Ik ga in ieder geval geen ander meer bellen.

- Antoine Evertze, Sales Engineer bij Chubb

Training: PRINCE2® 6e editie Foundation- incl. examen

Als er wat is staan ze altijd voor me klaar. Ik word meteen geholpen als ik bel.

- E. Zeijlmans, P&O adviseur bij Parnassia Groep

Training: ITIL® 4 Foundation - incl. examen

Wij zijn gebaat bij mensen die bijblijven in hun vakgebied en continu getriggerd worden.

- W. van Uijthoven, IT manager bij gemeente Arnhem

Training: Excel 2013 Compleet

Ik heb al eens eerder een training gehad via icttrainingen.nl en dat was een erg leerzame, leuke ervaring. Nu heb ik via het werk een online cursus en deze lijkt tot nu toe ook erg leerzaam.

- Michelle Brierley

Hoe gaat het te werk?

1

Training bestellen

Nadat je de training hebt besteld krijg je bevestiging per e-mail.

2

Toegang leerplatform

In de e-mail staat een link waarmee je toegang krijgt tot ons leerplatform.

3

Direct beginnen

Je kunt direct van start. Studeer vanaf nu waar en wanneer jij wilt.

4

Training afronden

Rond de training succesvol af en ontvang van ons een certificaat!

Veelgestelde vragen

Veelgestelde vragen

Op welke manieren kan ik betalen?

Je kunt bij ons betalen met iDEAL, PayPal, Creditcard, Bancontact en op factuur. Betaal je op factuur, dan kun je met de training starten zodra de betaling binnen is.

Hoe lang heb ik toegang tot de training?

Dit verschilt per training, maar meestal 180 dagen. Je kunt dit vinden onder het kopje ‘Kenmerken’.

Waar kan ik terecht als ik vragen heb?

Je kunt onze Learning & Development collega’s tijdens kantoortijden altijd bereiken via support@icttrainingen.nl of telefonisch via 026-8402941.

Background Frame
Background Frame

Onbeperkt leren

Met ons Unlimited concept kun je onbeperkt gebruikmaken van de trainingen op de website voor een vast bedrag per maand.

Bekijk de voordelen

Heb je nog twijfels?

Of gewoon een vraag over de training? Blijf er vooral niet mee zitten. We helpen je graag verder. Daar zijn we voor!

Contactopties