Course Details

Courses Descriptions

This module introduces the core components of Azure data engineering, focusing on account creation, user management, and organizational setup. Students will learn how to configure Azure environments to support business needs and access control through user roles, groups, and domain management.

Classes:

• Class 1: Azure Account Creation – Create and configure Azure accounts.

• Class 2: Azure User Creation & Deletion – Manage Azure Active Directory users.

• Class 3: Azure Static and Dynamic Groups – Understand and configure group types.

• Class 4: Azure Custom Domain Naming – Add and configure custom domains.

• Class 5: Azure Company Branding – Customize Azure AD branding for organizations.

🔹 Module 2: Azure Security & Access Management

Short Description: Secure Azure environments using MFA, policies, and identity management.

Detailed Description:
Dive deep into Azure identity protection, multifactor authentication, and conditional access policies. Learn how to apply security best practices to safeguard enterprise data and ensure compliant user access.

Classes:

• Class 6: Azure Multifactor Authentication - Part 1 – Set up MFA using Azure.

• Class 7: Azure Multifactor Authentication - Part 2 – Advanced MFA settings and policies.

• Class 8: Conditional Access Policy – Define and apply policies based on user/device conditions.

• Class 9: Directory Creation & Deletion – Create and manage Azure directories securely.

🔹 Module 3: Resource Management

Short Description: Learn how to deploy, manage, and organize Azure resources effectively.

Detailed Description:
Gain practical experience managing Azure resources, creating virtual machines, provisioning SQL databases, and exploring the infrastructure differences between physical and virtual Azure environments.

Classes:

• Class 10: Creation of Resource Group – Organize resources efficiently.

• Class 11: Creation of VMs & Adding Disks – Deploy virtual machines and attach storage.

• Class 12: Azure SQL – Set up and manage Azure SQL databases.

• Class 13: Physical & Virtual Azure VMs – Compare and configure VM types.

• Class 14: Resource Group & Virtual Machine Deep Dive – Combine multiple resources for integrated solutions.

🔹 Module 4: Introduction to Azure Data Engineering

Short Description: Understand the data engineering ecosystem in Azure.

Detailed Description:
Get introduced to Azure Data Engineering, including the tools and platforms used to ingest, process, and manage large-scale data. This demo session sets the foundation for upcoming real-world data integration techniques.

Classes:

• Session: Azure Data Engineering Demo – Overview of data pipeline architecture and Azure tools.

🔹 Module 5: Python and SQL Essentials for Data Engineering

Short Description: Build foundational programming and database querying skills.

Detailed Description:
This module introduces Python and SQL—two core skills for any data engineer. Learn data structures, logic, querying, and integration techniques that you'll use while building ETL pipelines and performing data analysis.

Classes:

• Part 1: Introduction to Python and SQL – Basics of syntax, types, and commands.

• Part 2: Python Control Structures & SQL Functions – Use logic to drive programs.

• Part 3: Working with Data – Learn lists, dictionaries, and SQL queries.

• Part 4: SQL Joins and Subqueries – Combine multiple tables and write advanced queries.

• Part 5: Real-world Problems and Integration – Practice data processing and automation with real datasets.