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

Data Engineer – Roles & Responsibilities

  1. Overview of the Roles and Responsibilities of Database Engineers
  2. Role of DevOps for automation of Data and other components
  3. Understand the Data Engineering Processes

Introduction to Azure Data Services

  1. Relation Databases
  2. NoSQL Databases
  3. Storage Services
  4. ETL Services
  5. Big Data Services
  6. Stream Analytics

Database in the Cloud

  1. Introduction to various options for hosting SQL server on Azure
  2. Create Logical SQL Server and Sql Database
  3. Learn about various Pricing Tiers (DTU vs vCores)
  4. Learn about Backup & Restore methods (Point-in-Time and Long Term Backup Retention)
  5. Understand how to scale-up and scale-down the capacity of SQL Database
  6. Configure Geo-Replication for disaster recovery.
  7. Configure Firewall to whitelist the required IP Address for secure access at both Server level and Database Level.
  8. Manage Sensitive Data with Dynamic Data Masking and Data Encryption
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

Azure Data Lake Gen 2

  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

Azure NoSQL – Cosmos DB

  1. Overview of Cosmos DB
  2. Understand the Cosmos DB architecture & Hierarchy
  3. Create Cosmos DB Account & Database
  4. Create Cosmos DB Containers and explore Partitions & Indexes
  5. Working with Cosmos DB Capacity (Request Units) and Cost Estimations
  6. Learn how to query data from Cosmos DB

Azure – Deployment as Code using Bicep

  1. Overview of Bicep
  2. Benefits of Bicep
  3. Provision Azure Resources using Bicep
  4. Integrate Bicep Scripts to Azure DevOps
Advertisements

Azure Data Factory

  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
Advertisements

Azure Data Bricks

  1. Overview of Azure Data Bricks
  2. Create an Azure Data Bricks service.
  3. Create a Spark cluster in Azure Data Bricks.
  4. Learn transformation of data in Azure Data Bricks using Scala
  5. Create Notebook to develop ETL using Data Bricks
  6. Understand how to parameterize Data Bricks pipelines
  7. Invoke Data Bricks pipelines with Azure Data Factory.

Azure Synapse Analytics

  • Overview of Synapse Analytics

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.


One comment

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