Data Engineering On Microsoft Azure DP203 | Microsoft Azure in Riga

Home

Courses

Microsoft Azure Certification

Data Engineering On Microsoft Azure DP-203 Certification

Riga

Expertise in designing and implementing Azure Data Solutions
Hands-on training with Azure data services in this Azure DP 203 Course
Certification to meet the demand for skilled data professionals

Dates & Prices Dates & Prices

Course information

Data Engineering on Microsoft Azure DP203 Course Outline

Module 1: Introduction to Data Engineering on Azure

Introduction
What Is Data Engineering?
Important Data Engineering Concepts
Data Engineering in Microsoft Azure

Module 2: Introduction to Azure Data Lake Storage Gen2

Introduction
Understand Azure Data Lake Storage Gen2
Enable Azure Data Lake Storage Gen2 in Azure Storage
Compare Azure Data Lake Store to Azure Blob Storage
Understand the Stages for Processing Big Data
Use Azure Data Lake Storage Gen2 in Data Analytics Workloads

Module 3: Introduction to Azure Synapse Analytics

Introduction
What is Azure Synapse Analytics?
How Azure Synapse Analytics Works?
When to Use Azure Synapse Analytics?
Exercise: Explore Azure Synapse Analytics

Module 4: Use Azure Synapse Serverless SQL Pool to Query Files in a Data Lake

Introduction
Understand Azure Synapse Serverless SQL Pool Capabilities and Use Cases
Query Files Using a Serverless SQL Pool
Create External Database Objects
Exercise: Query Files Using a Serverless SQL Pool

Module 5: Use Azure Synapse Serverless SQL Pools to Transform Data in a Data Lake

Introduction
Transform Data Files with the CREATE EXTERNAL TABLE AS SELECT Statement
Encapsulate Data Transformations in a Stored Procedure
Include a Data Transformation Stored Procedure in a Pipeline
Exercise: Transform Files Using a Serverless SQL Pool

Module 6: Create a Lake Database in Azure Synapse Analytics

Introduction
Understand Lake Database Concepts
Explore Database Templates
Create a Lake Database
Use a Lake Database
Exercise: Analyse Data in a Lake Database

Module 7: Analyse Data with Apache Spark in Azure Synapse Analytics

Introduction
Get to Know Apache Spark
Use Spark in Azure Synapse Analytics
Analyse Data with Spark
Visualise Data with Spark
Exercise: Analyse Data with Spark

Module 8: Transform Data with Spark in Azure Synapse Analytics

Introduction
Modify and Save Dataframes
Partition Data Files
Transform Data with SQL
Exercise: Transform Data with Spark in Azure Synapse Analytics

Module 9: Use Delta Lake in Azure Synapse Analytics

Introduction
Understand Delta Lake
Create Delta Lake Tables
Create Catalog Tables
Use Delta Lake with Streaming Data
Use Delta Lake in a SQL Pool
Exercise: Use Delta Lake in Azure Synapse Analytics

Module 10: Analyse Data in a Relational Data Warehouse

Introduction
Design a Data Warehouse Schema
Create Data Warehouse Tables
Load Data Warehouse Tables
Query a Data Warehouse
Exercise: Explore a Data Warehouse

Module 11: Load Data into a Relational Data Warehouse

Introduction
Load Staging Tables
Load Dimension Tables
Load Time Dimension Tables
Load Slowly Changing Dimensions
Load Fact Tables
Perform Post-Load Optimisation
Exercise: Load Data into a Relational Data Warehouse

Module 12: Build a Data Pipeline in Azure Synapse Analytics

Introduction
Understand Pipelines in Azure Synapse Analytics
Create a Pipeline in Azure Synapse Studio
Define Data Flows
Run a Pipeline
Exercise: Build a Data Pipeline in Azure Synapse Analytics

Module 13: Use Spark Notebooks in an Azure Synapse Pipeline

Introduction
Understand Synapse Notebooks and Pipelines
Use a Synapse Notebook Activity in a Pipeline
Use Parameters in a Notebook
Exercise: Use an Apache Spark Notebook in a Pipeline

Module 14: Plan Hybrid Transactional and Analytical Processing Using Azure Synapse Analytics

Introduction
Understand Hybrid Transactional and Analytical Processing Patterns
Describe Azure Synapse Link

Module 15: Implement Azure Synapse Link with Azure Cosmos DB

Introduction
Enable Cosmos DB Account to Use Azure Synapse Link
Create an Analytical Store Enabled Container
Create a Linked Service for Cosmos DB
Query Cosmos DB Data with Spark
Query Cosmos DB with Synapse SQL
Exercise: Implement Azure Synapse Link for Cosmos DB

Module 16: Implement Azure Synapse Link for SQL

Introduction
What Is Azure Synapse Link for SQL?
Configure Azure Synapse Link for Azure SQL Database
Configure Azure Synapse Link for SQL Server 2022
Exercise: Implement Azure Synapse Link for SQL

Module 17: Get Started with Azure Stream Analytics

Introduction
Understand Data Streams
Understand Event Processing
Understand Window Functions
Exercise: Get Started with Azure Stream Analytics

Module 18: Ingest Streaming Data Using Azure Stream Analytics and Azure Synapse Analytics

Introduction
Stream Ingestion Scenarios
Configure Inputs and Outputs
Define a Query to Select, Filter, and Aggregate Data
Run a Job to Ingest Data
Exercise: Ingest Streaming Data into Azure Synapse Analytics

Module 19: Visualize Real-Time Data with Azure Stream Analytics and Power BI

Introduction
Use a Power BI Output in Azure Stream Analytics
Create a Query for Real-Time Visualization
Create Real-Time Data Visualizations in Power BI
Exercise: Create a Real-Time Data Visualization

Module 20: Introduction to Microsoft Purview

Introduction
What Is Microsoft Purview?
How Microsoft Purview Works?
When to Use Microsoft Purview?

Module 21: Integrate Microsoft Purview and Azure Synapse Analytics

Introduction
Catalog Azure Synapse Analytics Data Assets in Microsoft Purview
Connect Microsoft Purview to an Azure Synapse Analytics Workspace
Search a Purview Catalog in Synapse Studio
Track Data Lineage in Pipelines
Exercise: Integrate Azure Synapse Analytics and Microsoft Purview

Module 22: Explore Azure Databricks

Introduction
Get Started with Azure Databricks
Identify Azure Databricks Workloads
Understand Key Concepts
Exercise: Explore Azure Databricks

Module 23: Use Apache Spark in Azure Databricks

Introduction
Get to Know Spark
Create a Spark Cluster
Use Spark in Notebooks
Use Spark to Work with Data Files
Visualise Data
Exercise: Use Spark in Azure Databricks

Module 24: Run Azure Databricks Notebooks with Azure Data Factory

Introduction
Understand Azure Databricks Notebooks and Pipelines
Create a Linked Service for Azure Databricks
Use a Notebook Activity in a Pipeline
Use Parameters in a Notebook
Exercise: Run an Azure Databricks Notebook with Azure Data Factory

Who should attend this Data Engineering on Microsoft Azure DP203 Training Course?

The Data Engineering on Microsoft Azure DP-203 Training Course is designed for individuals who want to learn how to design and implement data solutions using Microsoft Azure's data engineering services and tools. This Microsoft Training Course can be beneficial to a wide range of professionals, including:

Data Engineers
Database Administrators
Data Integration Specialists
Data Architects
Database Developers
Technical Consultants
BI (Business Intelligence) Developers

Prerequisites of the Data Engineering on Microsoft Azure DP203 Training Course

The required prerequisites for attending the Data Engineering on Microsoft Azure DP203 Training Course are to have a knowledge of cloud computing with core data concepts and professional experience with data solutions necessary and also completing AZ-900 Azure Fundamentals and DP-900 Microsoft Azure Data Fundamentals would be beneficial for the delegates.

Data Engineering on Microsoft Azure DP-203 Course Overview

This Data Engineering on Microsoft Azure DP-203 Training Course provides a comprehensive understanding of this vital discipline. With an emphasis on the power of Microsoft Azure, this course equips professionals with the knowledge and skills necessary to harness, process, and manage data effectively. As data becomes increasingly central to decision-making across various industries, this course serves as a gateway to harness the potential of Azure for Data Engineering solutions.

Proficiency in designing and implementing Microsoft Azure networking solutions is essential for professionals aspiring to excel in roles related to network architecture, cloud infrastructure, and IT management. This Microsoft Azure Certification Course is particularly beneficial for network engineers, cloud architects, IT managers, and system administrators. As organisations increasingly migrate to cloud-based solutions, this Azure Certification course becomes imperative.

The Knowledge Academy's 4-day training on Designing and Implementing Microsoft Azure Networking Solutions AZ700 offers an accelerated path to expertise in Azure networking. Delegates will engage in hands-on learning, gaining practical experience with Azure tools to design and implement effective networking solutions. This course serves as a key entry point for professionals seeking to leverage the power of Azure for networking solutions.

Course Objectives

To understand Azure data services and their role in Data Engineering
To design and implement data storage solutions using Azure Data Storage Services
To develop data processing solutions using Azure Data Factory
To implement data transformation and data integration techniques
To ensure data security and compliance within Azure data solutions
To optimise and monitor data pipelines for efficiency
To leverage Azure Databricks for Data Analytics and Machine Learning

After completing this Microsoft Azure Certification Course, delegates will gain the practical skills and knowledge to harness the power of Microsoft Azure for effective Data Engineering solutions.

What’s included in this Data Engineering on Microsoft Azure DP203 Training Course?

World-Class Training Sessions from Experienced Instructors
Data Engineering on Microsoft Azure DP203 Certificate
Digital Delegate Pack

Why choose us

Our Riga venue

Includes..

Free Wi-Fi

To make sure you’re always connected we offer completely free and easy to access wi-fi.

Air conditioned

To keep you comfortable during your course we offer a fully air conditioned environment.

Full IT support

IT support is on hand to sort out any unforseen issues that may arise.

Video equipment

This location has full video conferencing equipment.

Riga is the capital and biggest city in Latvia. It has an estimated population of around 640,000 people. It is home to more than a third of the country’s population. The unemployment rate of Latvia is around 9.8 percent as of the second quarter of 2015. This was a decrease from the first quarter when it stood at 10.2 percent. The average rate for 13 years before 2015 was around 11.75 percent. There are a number of higher education institutes in Riga. The oldest university in Latvia is the Riga Technical University that was founded in 1862. The school is best known as a business school but also offers courses in Architecture & Urban Planning, Building & Civil Engineering, Computer Science and Information Technology.

Address

4th & 5th floors,
14 Terbatas street,
Riga, LV-1011

T: +44 1344 203 999

Ways to take this course

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Data Engineering On Microsoft Azure DP203 | Microsoft Azure in Riga. Engage directly with expert instructors, mirroring the classroom schedule for a comprehensive learning journey. Enjoy the convenience of virtual learning without compromising on the quality of interaction.

Learn more in our FAQs

Unlock your potential with The Knowledge Academy's Data Engineering On Microsoft Azure DP203 | Microsoft Azure in Riga, accessible anytime, anywhere on any device. Enjoy 90 days of online course access, extendable upon request, and benefit from the support of our expert trainers. Elevate your skills at your own pace with our Online Self-paced sessions.

Learn more in our FAQs

Experience the most sought-after learning style with The Knowledge Academy's Data Engineering On Microsoft Azure DP203 | Microsoft Azure in Riga. Available in 490+ locations across 190+ countries, our hand-picked Classroom venues offer an invaluable human touch. Immerse yourself in a comprehensive, interactive experience with our expert-led Data Engineering On Microsoft Azure DP203 | Microsoft Azure in Riga sessions.

Highly experienced trainers

Boost your skills with our expert trainers, boasting 10+ years of real-world experience, ensuring an engaging and informative training experience

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

Small class sizes

Our Classroom courses with limited class sizes foster discussions and provide a personalised, interactive learning environment

Great value for money

Achieve certification without breaking the bank. Find a lower price elsewhere? We'll match it to guarantee you the best value

Learn more in our FAQs

Streamline large-scale training requirements with The Knowledge Academy's In-house/Onsite at your business premises. Experience expert-led classroom learning from the comfort of your workplace and engage professional development.

Tailored learning experience

Leverage benefits offered from a certification that fits your unique business or project needs

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

Team building opportunity

Our offers a unique chance for your team to bond and engage in discussions, enriching the learning experience beyond traditional classroom settings

Monitor employees progress

The course know-how will help you track and evaluate your employees' progression and performance with relative ease

Learn more in our FAQs

What our customers are saying

Trainer is really very frendly and clarified all the doubts in the lab session. Assisted being with us during the labs.

Narasimhan Aakur

Data Engineering On Microsoft Azure DP203 | Microsoft Azure in Riga FAQs

What is Microsoft Azure?

Microsoft Azure is a cloud computing platform and set of services provided by Microsoft, offering solutions for computing, storage, networking, databases, analytics, and more.

What are the prerequisites to taking Data Engineering on Microsoft Azure DP-203 Course?

Who should attend this Azure DP 203 Course?

This course is ideal for data engineers, data architects, database administrators, and IT professionals seeking to enhance their skills in designing and implementing data solutions on Microsoft Azure.

How will Data Engineering on Microsoft Azure DP-203 training course help me?

This training course will equip you with the knowledge and skills to design and implement data solutions using Microsoft Azure services, enabling you to leverage the power of the cloud for data management, processing, and analytics.

What is the duration of this Azure DP 203 Course?

The duration of this Azure DP 203 Course is 3 days.

What will I learn in this Data Engineering on Microsoft Azure DP-203 training course?

Participants will learn to design and implement data storage solutions, data processing solutions, and data security and compliance solutions on Microsoft Azure. The course covers various Azure services such as Azure Data Lake Storage, Azure Databricks, Azure Synapse Analytics, and more.

Is this Data Engineering on Microsoft Azure DP-203 training course accredited?

Yes, this training course is accredited and aligned with the objectives of the Microsoft DP-203 certification exam.

Are there any specific industries or sectors where Data Engineering on Microsoft Azure DP-203 Certification holds relevance?

Data Engineering on Microsoft Azure DP-203 Certification holds relevance across industries such as finance, healthcare, retail, manufacturing, and technology, where effective data management and analytics are critical for business success.

Can individuals with non-technical backgrounds benefit from the Data Engineering on Microsoft Azure DP-203 Certification in terms of career advancement?

Yes, individuals with non-technical backgrounds can benefit from this certification by gaining valuable skills in data engineering and cloud computing, opening up opportunities for career advancement in roles such as data analyst, business analyst, or project manager.

What are the career opportunities available after completing Data Engineering on Microsoft Azure DP-203 Course?

After completing the course and obtaining the DP-203 certification, career opportunities may include data engineer, data architect, cloud engineer, data scientist, or Azure solutions architect, with demand across industries for professionals skilled in designing and implementing data solutions on Microsoft Azure.

Why choose The Knowledge Academy in Riga over others?

The Knowledge Academy stands out as a prestigious training provider known for its extensive course offerings, expert instructors, adaptable learning formats, and industry recognition. It's a dependable option for those seeking Data Engineering on Microsoft Azure DP-203 Certification.

What is the cost/training fees for Data Engineering On Microsoft Azure DP-203 Certification in Riga?

The training fees for Data Engineering On Microsoft Azure DP-203 Certificationin Riga starts from €2895

Which is the best training institute/provider of Data Engineering On Microsoft Azure DP-203 Certification in Riga?

The Knowledge Academy is the Leading global training provider for Data Engineering On Microsoft Azure DP-203 Certification.

What are the best Microsoft Azure Certification courses in Riga?

Please see our Microsoft Azure Certification courses available in Riga

Why choose us

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Trusted & Approved

Microsoft Azure Training

Many delivery methods

Flexible delivery methods are available depending on your learning style.

High quality resources

Resources are included for a comprehensive learning experience.

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water