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