Azure Data Engineer Bootcamp : Hands on Practical Demos
4.4 (67 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,350 students enrolled

Azure Data Engineer Bootcamp : Hands on Practical Demos

Learn Azure Data Lake Storage, Azure SQL Database, Azure Data Factory, Synapse Analytics, Power BI, Real World Use Cases
4.4 (67 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,351 students enrolled
Created by Amit Navgire
Last updated 7/2020
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 14.5 hours on-demand video
  • 2 articles
  • 18 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Students will learn Azure Data Lake, Azure Data Factory, Azure SQL Database, Azure Data Factory, Power BI
Requirements
  • None
Description

Hi,


Azure Data Engineer is the most lucrative job profile and those who possess the skill sets require to become Azure Data Engineer are always in great demand and easily can get a 6 figure salary in USD as per the market trend.


But, it can be overwhelming for a beginner to start his/her journey to become a Azure Data Engineer since there are so many different technologies and services offered by Azure.


Hence below I have provided step by step guide of the skill sets require to start your Data Engineer journey and then progress gradually to become an Intermediate level or Expert  Azure Data Engineer.


Beginner -> Azure SQL Database, Azure Data Factory, Azure Data Lake, Power BI

Intermediate -> Azure Synapse Analytics, Azure Analysis Services

Expert -> Azure Databricks, Azure Stream Analytics


In this course, I am going to continously add all of the above mentioned Azure Services so that you can become an Expert Azure Data Engineer.


NOTE: ALL THE AZURE DATA SERVICES PRESENT IN THIS COURSE ARE FOR BEGINNERS SO PEOPLE WHO ARE EXPERIENCED AZURE DATA ENGINEERS MAY FIND THE CONTENT OF THIS COURSE TOO BASIC.


Following are the topics currently this course covers:


1. Basics of Cloud Computing

2. Azure SQL Database

3. Azure Data Lake Storage

4. Azure Data Factory V2

5. Implementing Real World Use Cases

6. Power BI


Also, all the topics in this course are explained using practical examples and lab sessions which makes it easy to understand and also practice at home for students.

I have also added a section containing "REAL WORLD USE CASES" where some common and important scenarios which you would come across in real life when you work as a Azure Data Engineer in an organization.  Do not miss this section as its very important and will also help you in the interview.


All the Best and Happy Learning !!





Who this course is for:
  • Everyone
Course content
Expand all 96 lectures 14:43:32
+ Cloud Computing Basics
3 lectures 24:20
What is Azure and How to Create Free Azure Account ?
05:53
Quiz on Cloud Computing
2 questions
+ *****AZURE SQL DATABASE*****
10 lectures 01:42:46
Overview of Azure SQL Database
07:33
Lab: Pricing Tiers
17:39
Lab: Azure SQL Virtual Machine
09:04
Lab: Connect and execute queries on Azure SQL Database
08:38
Lab: Elastic Pools
15:48
Quiz
1 question
Lab: Active Geo Replication
06:58
Lab: Failover Group
09:51
Lab: Dynamic Data Masking
08:05
Lab: Auditing
08:52
+ ******AZURE DATA FACTORY v2******
25 lectures 03:55:15
Lab: Building Blocks of Data Factory
29:28
Quiz
2 questions
Lab: Copy Data Activity - Scenario 1
16:41
Lab: Copy Data Activity - Scenario 2
08:21
All the best
Copy files from local filesystem to Azure SQL Database
1 question
Lab: Get Metadata Activity
07:59
Lab: Filter Activity
08:31
Lab: If - Else Activity
04:45
Lab: Append Activity
02:56
Lab: Wait Activity
02:50
Lab: Lookup Activity
07:43
This assignment you will make use of some control flow activities and copy data activity
Load a table from one db to another db based on a condition
1 question
Lab: Data Flow - Source
11:55
Lab: Data Flow - Sink
09:53
Lab: Data Flow - Conditional Split
21:07
Lab: Data Flow - Derived Column
06:14
Lab: Data Flow - Lookup
12:42
Lab: Data Flow - Select
04:02
Lab: Data Flow - Filter
05:23
Lab: Data Flow - Join
08:46
Lab: Data Flow - Exists
05:39
Students should use data flow activity transformations for this assignment
Load records in respective tables based on their department
1 question
Lab: Parameters - Linked Services Parameters
14:18
Lab: Parameters - Pipeline Parameters
04:18
Lab: Parameters - Data Flow Parameters
03:22
Lab: Monitoring - Visually Monitor
06:08
Lab: Monitoring - Azure Monitoring
09:03
+ *****REAL WORLD USE CASES *****
8 lectures 02:26:11
Lab: Implementing in Azure Data Factory V2
45:02
Artifacts for Tables used in the Lab session
00:29
Introduction to Slowly Changing Dimension Type I
09:25
Lab: Implementing Slowly Changing Dimension Type I in ADFv2
26:21
Artifacts for Tables used in the Lab session of SCD Type 1
00:08
Introduction to Slowly Changing Dimension Type 2
14:17
Lab: Implementing Slowly Changing Dimension Type 2 in ADFv2
34:20
+ *****Azure Data Lake Storage Gen2*****
9 lectures 51:18
Introduction to Azure Data Lake Storage Gen2
05:11
Lab: Create Azure Data Lake Storage Gen2
10:37
Lab: Storage Explorer
06:09
Lab: Access Control and Data Transfer
06:33
Lab: Shared Access Signatures (SAS)
03:23
Lab: Encryption
02:02
Lab: Monitoring Azure Data Lake Storage
03:15
Lab: Security
02:37
+ *****AZURE SYNAPSE ANALYTICS (formerly SQL Data Warehouse)*****
12 lectures 02:33:25
Introduction to Azure Synapse Analytics
06:51
Lab: Synapse Workspace & Synapse Studio
28:59
Understanding Synapse SQL Pool Architecture
29:56
Lab: Create Synapse SQL Pool in Azure Portal
09:05
Lab: Setting up & Loading data using Polybase
22:52
Lab: Load Data using CTAS
05:04
Lab: Load Data using Copy Into Statement
10:16
Lab: Load Data using Azure Data Factory
18:49
Lab: Restore Synapse SQL Pool from Restore Point
03:52
Lab: Geo Backups
02:50
Lab: Encryption and Auditing
07:21
Lab: Monitoring Synapse SQL Pool
07:30
+ *****POWER BI ******
29 lectures 02:50:16
Lab: Download and Install Power BI Desktop
03:52
Lab: Connect to Data Sources
08:26
Lab: Creating Relationships between different tables
10:18
Lab: Create Calculated Columns
07:41
Lab: Create Measures
03:26
Lab: Data Transformation - Replace Nulls
02:53
Lab: Data Transformation - Choose Column & Remove Column
03:52
Lab: Data Transformation - Keep Rows & Remove Rows
03:06
Lab: Data Transformation - Split column
03:34
Lab: Data Transformation - Merge Query
04:35
Lab: Data Transformation - Group By
08:30
Lab: Data Transformation - Format
02:13
Lab: Data Transformation - Extract
04:09
Lab: Data Transformation - Date Format, Conditional Column, Index Column
04:53
Report Building - Set Background Color, Logo
03:21
Report Building - Slicers
11:59
Report Building - Charts
09:38
Report Building - Pie Charts
06:24
Report Building - Tables
06:25
Report Building - Cards
09:10
Report Building - KPI
08:19
Report Building - Filters On All Pages
06:06
Power BI Service - Publish a Report
02:35
Power BI Service - DataSet Gateway
09:52
Power BI Service - Sharing a Report
02:34
Power BI Service - Dashboard
04:52