Azure Data Engineer Associate – DP 200 & 201

  • Duration – 15 hour

 

Expected Outcomes

After this course:

  • Microsoft Azure SQL Server – You will be able to identify the right Azure SQL Server deployment option, purchasing model and service tier according to requirements and will be able to deploy it in the cloud. You will be able to set up a security configuration to secure your database.

  • Microsoft Azure SQL Data Warehouse – You will able to deploy Azure Synapse Analytics (formerly known as Azure SQL Data warehouse) in Azure Cloud environment. You will have good internal MPP architecture understanding, and so you will be able to analyze your on-premises data warehouse and migrate data to Azure Data Warehouse.

  • Microsoft Azure Data Lake – You will be able to create Azure Data Lake Gen1 storage account, populate it will data and analyze it using U-SQL Language.

  • Microsoft Azure Data Factory – You will understand Azure Data Factory’s key components and advantages. You will be able to create, schedule and monitor simple pipelines.

  • Hadoop Basics – You will learn the fundamental understanding of the Hadoop Ecosystem and 3 main building blocks. This module will prepare you to start learning Big Data in Azure Cloud using HDInsight.

  • Microsoft Azure HDInsight – We will understand how HDInsight makes Hadoop easy, and we will go through simple demo where we’ll fetch data from Data Lake, process it through Hive and later will store data in SQL Server.

ALL AZURE COURSES BUNDLE

$200

Microsoft Azure Data Engineer-Associate DP-200 and DP-201 Certification

 

Introduction to Azure Cloud Computing

 

Introduction

 

Create Azure free subscription

 

Azure Portal overview

 

Azure Services Overview

 

Managed and Unmanaged Service

 

Resource Groups

 

Resource Provider

 

Tagging

 

Access Control

 

Demo – Create Azure SQL Database service

 

Delete resources and set budget

 

Conclusion

 

 

Introduction to Data Engineer Profile

 

Introduction

 

How did Data Engineer profile evolve?

 

Data Engineer role and responsibility

 

Introduction to Data Engineer technologies

 

Conclusion

 

 

Azure SQL Database Service for DBA and Developers

 

Introduction

 

Why choosing SQL Server in Azure

 

Azure IaaS vs PaaS database offerings

 

SQL Server PaaS deployment options

 

Further References from Microsoft Docs

 

 

Azure SQL Server in Virtual Machine (IaaS)

 

Introduction

 

SQL Server in Azure Virtual Machine

 

Demo – SQL Server in Azure Virtual Machine

 

 

Further References from Microsoft Docs

 

 

Azure Single Database

 

Introduction

 

Demo – Azure Single Database

 

Purchasing models and Service Tier

 

Azure Database vs Azure Data warehouse

 

Further References from Microsoft Docs

 

 

Elastic Database Pool

 

Introduction

 

Azure Elastic Database

 

Demo – Azure Elastic Database

 

Further References from Microsoft Docs

 

 

Managed Instance Database

 

Introduction

 

Azure Managed Instance Database

 

Difference between on-premises and Managed Instance

 

Migration options for Managed Instance

 

Service tiers for Managed Instance

 

Management operations

 

Demo – Managed Instance

 

Further References from Microsoft Docs

 

 

Azure Database Security

 

Introduction

 

Azure Database Security options

 

Azure Managed Instance advance security

 

Further References from Microsoft Docs

 

 

Data Warehouse – crash course

 

Module Introduction

 

Module Resources

 

 

Introduction to Azure Synapse Analytics Service

 

Introduction

 

Why warehousing in cloud

 

Traditional vs Modern Warehouse architecture

 

Azure Synapse a Game changer

 

Azure Synapse Benefits

 

Modern vs Azure Synapse Architecture

 

Demo Azure Synapse Analytics

 

Azure Synapse Studio

 

Synpase unified experience

 

 

Azure Synapse Internal and Architecture

 

Introduction

 

Azure Synapse MPP Architecture

 

Storage and Sharding patterns

 

Data Distribution and Distributing Keys

 

Data Types and Table Types

 

Partitioning

 

Best Practices for Fact and Dimension tables

 

Demo – Analyse data distribution before migration to azure

 

Summary

 

 

Data Migration to Azure Synapse Data Warehouse

 

Introduction

 

 best practices for Data Load

 

DIfferent loading methods

 

Loading with SSIS vs PolyBase

 

Demo – Loading with SSIS

 

Demo – Loading with Polybase

 

Demo – Loading with Data Factory

 

Summary

 

 

Security layers in Azure Synapse Service

 

Introduction

 

Advance Data Security

 

Auditing

 

Network Security

 

Transparent data encryption

 

Dynamic Data Masking

 

Access Management

 

Summary

 

 

Configuring and Optimizing Azure Synapse Service

 

Introduction

 

Configuration Options

 

Performing other tasks

 

Backup and Restore

 

Price Optimization

 

Managing Workloads

 

Monitoring

 

Support and Troubleshooting

 

Delete Resources

 

Summary

 

Introduction to Azure Data Lake

 

Problem statement

 

How Data Lake can solve this problem?

 

Data Lake vs SSIS vs Hadoop vs DW

 

Advantages of Data Lake

 

Data Lake Storage vs Analytics

 

 

Demo – Data Lake

 

Requirement

 

Create Data Lake Accounts

 

How to upload data in Data Lake

 

Write U-SQL Script to transform data

 

Schedule a job in Data Lake

 

Summary

 

 

Introduction to Azure Data Factory

 

Data Life Cycle

 

Azure Solutions

 

What is Azure Data Factory

 

Key components of Data Factory

 

Pipeline workflow –  steps

 

 

Demo – Data Factory

 

Module Introduction

 

Create Azure Data Lake Storage Gen  Account

 

Deploy Azure SQL Data Warehouse

 

Deploy Data Factory

 

Getting familiar with Azure Data Factory UI

 

ETL Operation

 

Permissions

 

Data Factory Monitoring

 

 

HDInsight 

 

Hadoop – crash course

 

HDInsight overview

 

 

Introduction to HDInsight

 

Why Hadoop is Hard

 

How HDInsight make Hadoop Easy

 

Important aspects of HDInsight

 

HDInsight cluster types

 

HDInsight Architecture

 

 

Demo – HDInsight

 

Demo overview

 

Create Azure Data Lake Storage Gen  (source) and SQL Server (destination)

 

What is Managed Identity

 

Add Managed Identity to Gen and Database accounts

 

Create HDInsight Interactive Query Cluster

 

Ambari overview and UI

 

Ingest dataset in to DataLake storage

 

Data Extraction with Hive

 

Data transformation with Hive

 

Data Export with Sqoop

 

Summary

 

 

Cloud Computing basics for absolute beginners

 

Introduction

 

Why we need a cloud computing

 

What is cloud computing

 

Benefits of Cloud computing

 

Cloud Deployment models

 

Types of cloud services

 

AWS vs Azure vs Google

 

Conclusion

 

 

Data Warehouse crash course for absolute beginners

 

Introduction

 

What is Data Warehouse

 

Why we need Data Warehouse

 

Ideal Data Warehouse Solution

 

Responsibilities of Data Warehouse designer

 

SQL Server vs Data Warehouse

 

Dimensional Modeling

 

Facts and Fact Table

 

Dimensions and Dimension table

 

Star vs Snowflake

 

Summary

 

 

Hadoop crash course for absolute beginners

 

Hadoop overview

 

Why we need distribute computing?

 

Two ways to build system

 

Introducing Hadoop

 

Hadoop vs RDBMS

 

Hadoop Ecosystem

 

Hadoop Summary

 

 

Wrapping up

 

Bonus Lecture

300+ Courses

After your course completion, we provide course completion certificate as well.

Lifetime Access

All courses are for lifetime access.

l

Priority Support

All queries are answered 24/7.

What People Are Saying

Abhilash -

A very good match. i am enjoying every bit.

Sonal-

Experience was quite good and it was very useful and well elaborated course.

Karan-

I FEEL AS IF I AM ATTENDING A WORLD CLASS TRAINING AND THE LECTURER HAS BEEN AWESOME!

Gilbert-

I find that the explanation is good and also understandable.

Seyed-

Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.

Mayur-

I really like this course, it was a good match for me :))

Mahesh-

Standard process and hands on covered nicely.

 

Emily-

Perfect, with complete hands on. Well structured and nicely covered.

Kevin-

Great Content, nice and up to the mark course.

Mayuresh-

 

Great courses. Beginner friendly and the explanations are clear and very easy to understand.

Saket-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Tushar-

A very detailed explanation and quite handy tips and tricks! loved it

Sourabh-

 

Excellent lecture, pace of the instructor is very good, easy to understand

Rishi-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Mahima-

This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan -

A pesar de no dominar perfectamente el idioma, se entiende bien.

Emile-

Yes lessons are very good. Not so fast, well explained

Kishore-

Worth course for the beginner to invest their time to learn this demanding skills.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us