-
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.
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.
