Azure for Data Engineers

Advertisements

Azure Basics

  1. Introduction to Cloud Computing
  2. IaaS Vs PaaS vs SaaS and Serverless
  3. Understand Azure Management Portal

Database in the Cloud

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

Azure Storage

  1. Create a Storage Account
  2. Create Containers and Blobs
  3. Install & Explore Azure Storage Explorer
  4. Create SAS tokens and understand the benefits of SAS tokens
  5. Copy Files from on prem to Azure Blob Storage using AzCopy
  6. Copy Files from one Storage Account to other Storage Account
  7. Create Queues and add messages into the queue using Powershell
  8. Create File Shares and sync the files
  9. Create Tables using Storage Explorer

Azure NoSQL – Cosmos DB

Cosmos DB – architecture
Understand the RUs and Throughput
Understand Partitions and the advantages

Azure – Deployment as Code using ARM Templates

  1. Overview of ARM Templates
  2. Benefits of ARM Templates
  3. Understand the Structure of ARM Templates
  4. Provision Azure Resources using ARM Templates
  5. Plug-in ARM Templates to Release pipeline to automate the process of provisioning the Resources.
Advertisements

ETL and Data Analytics

  1. Azure Data Factory Overview
  2. Understand ADF Core Concepts
  3. Move Data from Azure Storage to SQL Database pipelines and activities
  4. Migrate Data from On Prem SQL Server to SQL Database using ADF
  5. Migrate SSIS Packages to Azure using ADF
  6. Understand scheduling and Monitoring the ADF Pipelines
  7. Create & work with Dataflow
  8. Build an End-to-End pipeline to demonstrate ETL

Azure Data Lake

  1. Overview of Azure Data Lake
  2. Understand Azure Data Lake Architecture
  3. Creating an Azure Data Lake Store Gen2 with Portal
  4. Managing Data with Azure Data Lake Store Gen2
Advertisements

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.

For getting more updates you can join my WhatsApp group at https://chat.whatsapp.com/KSG5H9mJAECDlibkcknzWT

Praveen Sreeram


What People Say

“It was really great experience learning Azure for data engineers. Very informative and highly recommend this course. He has in-depth knowledge of Azure. Most importantly all sessions are practical with real-time use cases. “.

Prasad

Learning from Praveen does not stop after classes are over but an ongoing process. Explains concepts very patiently.

Omkar Gundlur

The course was very informative. He is very patient at answering each and every question. I would recommend Praveen for anyone who is seeking to learn Azure

Chanikya Reddy
Advertisements

Let’s build something together.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s