What will i learn?
- The primary audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about data engineering
Curriculum for this course
0 Lessons
00:00:00 Hours
Requirements
+ View more
Description
In this course, the Employees will learn how to implement and manage data engineering workloads on Microsoft Azure,
using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure
Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and
transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses,
capturing and aggregating streams of real-time data, and tracking data assets and lineage.
Azure Basics
1 Introduction to Cloud Computing
2 Understand various cloud deployment models - IaaS Vs PaaS vs SaaS and Serverless
3 Understand Azure Management Portal
4 Understand various Components of Azure (Subscription, Resource Groups etc.)
5 Implement RBAC (Role-Based Access Control) authorization to Azure Services
Azure SQL Database
1 Introduction to various options for hosting SQL server on Azure
2 Create a VM with SQL Server image (IaaS)
3 Create Logical SQL Server and Sql Database
4 Understand how to scale-up and scale-down the capacity of SQL Database
5 Understand how to configure Alerts on db load
6 Configure Web App code to access SQL Database
7 Configure Geo-Replication for disaster recovery.
8 Configure Firewall to whitelist the required IP Address for secure access at both Server
level and Database Level
Azure Storage
1.Azure Storage for storing Images & documents
Understand different Storage Services
2 Learn how to work with Blob Storage to save files and folders on the cloud
Copy files from on-premises to Azure Storage using AzCopy
3 Understand how to use Queues and implement Queue-Centric Patterns
4 Understand how to configure SMB protocol with Azure File Share
5 Understand how to work with Table Storage
Configure security to Storage account using
Access keys
Shared Access Signature
Azure NoSQL and Performance
Cosmos DB – architecture
Understand the RUs and Throughput
Understand Partitions and the advantages
Azure – Deployment as Code using ARM Templates
ARM Templates
Overview of ARM Templates
Benefits of ARM Templates
Understand the Structure of ARM Templates
Provision Azure Resources using ARM Templates
Plug-in ARM Templates to Release pipeline to automate the process of
provisioning the Resources
Azure Data Factory
Overview
Understand ADF Core Concepts
Move Data from Azure Storage to SQL Database pipelines and activities
Migrate Data from On Prem SQL Server to SQL Database using ADF
Migrate SSIS Packages to Azure using ADF
Understand scheduling and Monitoring the ADF Pipelines
Create & work with Dataflow
Build an End-to-End pipeline to demonstrate ETL
Azure Data Lake
Overview of Azure Data Lake
Understand Azure Data Lake Architecture
Creating an Azure Data Lake Store Gen2 with Portal
Managing Data with Azure Data Lake Store Gen2
Configure ADLS Gen2 as file system for HDInsight Cluster.
Azure Data Bricks
Overview of Azure Data Bricks
Create an Azure Data Bricks service.
Create a Spark cluster in Azure Data Bricks.
Learn transformation of data in Azure Data Bricks using Scala
Create Notebook to develop ETL using Data Bricks
Understand how to parameterize Data Bricks pipelines
Invoke Data Bricks pipelines with Azure Data Factory.
Azure Stream Analytics
Overview of Azure Stream Analytics
Understand the workflow of Azure Stream Analytics
Learn about Azure Stream Analytics Jobs
Learn Stream Analytics outputs
ABOUT THE Trainer
Trainer is working as an Azure Technical architect. He has 14+ years of experience in the field of development, analysis,
design and delivering the applications of various technologies right from Custom Web development using ASP.NET. He is
highly focused on Learning Technology. His current focus is on analyzing the business problems and providing technical
Solutions for various projectsrelated to Microsoft Azure.
+ View more
Other related courses
About the instructor
- 5 Reviews
- 100 Students
- 15 Courses
+ View more
www.justlivetutors.com
Justlivetutors.com is to help learners truly engage with and enjoy the learning process, with the hope that they will "fall in love with learning. Training to Hire in MNC.
Student feedback
Reviews
Write a public review