Empire Data Systems

Microsoft Azure Fabric and Data Engineering Training(Online)

By Pavan, Microsoft Certified Azure Fabric and Data Engineer!!! (*****)

Course Description

Our Azure Data Engineering course will help IT professionals become subject matter experts in integrating, transforming, and consolidating data from various structured and unstructured data systems into structures suitable for building analytics solutions.

Key topics covered include:
  • Azure Data Factory (ADF): Learn how to create, schedule, and orchestrate data pipelines to move and transform data at scale.
  • Azure Databricks: Gain expertise in using this powerful analytics platform to process big data and perform advanced analytics with Apache Spark.
  • Microsoft Fabric: Understand how to leverage this unified platform for data integration, data engineering, and data analytics.

Responsibilities for this role include helping stakeholders understand the data through exploration, building, and maintaining secure and compliant data processing pipelines by using different Azure tools and techniques.

An Azure Data Engineer also helps ensure that data pipelines and data stores are high-performing, efficient, organized, and reliable, given a specific set of business requirements and constraints. This professional deals with unanticipated issues swiftly and minimizes data loss. An Azure Data Engineer also designs, implements, monitors, and optimizes data platforms to meet the data pipeline needs.

This course prepares you for the Microsoft Certification DP-700 (Fabric Data Engineer Associate) & DP-600 (Fabric Analytics Engineer Associate). Students will also get Hands-on Labs plus over 250+ Practice questions for the exam.

For course details and registration, please get in touch with Daniel at +1 267 718 1533 (Mobile & Whatsapp). We are based in Philadelphia, USA, and host affordable and comprehensive SQL Server/Azure/AWS/DevOps training programs for students around the globe.

Student Demographic

Course Introduction Video

Course Information

Pavan's Profile - Microsoft Certified Azure Data Engineer

Mr. Pavan, a Microsoft Certified Azure Data Engineer (DP 203) with five years of hands-on Microsoft Azure Data stack experience. His expertise is with Azure Data Platform includes Azure Databricks, Delta Lake, Data Factory, Synapse, HDInsight, Data Catalog, and Cosmos DB. Besides, he also has significant experience in Big Data infrastructure and Software development. He has a great passion for mentoring students, and he will take you deep into the Azure Data Platform domain.

Pavan's Certifications

Talk to Pavan

Live Training Videos

We believe in letting our prospective students to watch recorded videos of our live training classes and decide for themselves. If you would still like to attend a one-on-one live demo session, please give call Daniel @ 267 718 1533 and he can schedule one for you at your convenience.

Course Content

Module 1: Introduction to Azure Data factory

  • Understand Azure Data Factory components
  • Create linked services
  • Create datasets
  • Manage integration runtime

Module 2: Data Movement using Data Factory Control Flow

  • Understand data factory control flow activities
  • Develop the data factory pipelines using copy activity for data movement
  • Add parameters to data factory components
  • Debug data factory pipelines & data flows
  • Setup triggers & Alerts for pipelines

Module 3: Data transformation using Data Factory

  • Build Mapping Data Flow for data transformation
  • Add parameters to mapping data flows
  • Debug data flows from pipelines
  • Implement Slowly Changing Dimension using mapping data flows

Module 4: Introduction to Azure Databricks

  • Provision an Azure Databricks workspace
  • Ingest data using Azure Databricks.
  • Using the different data exploration tools in Azure Databricks.
  • Analyse data with Data Frame APIs.
  • Use Spark to process and analyse data stored in files.
  • Use Spark to visualize data

Module 5: : Manage data with Databricks Delta Lake

  • What is Databricks Delta Lake
  • How to manage ACID transactions using Delta Lake
  • How to use schema versioning and time travel in Delta Lake
  • How to maintain data integrity with Delta Lake

Module 6: SQL Warehouses in Azure Databricks

  • Create and configure SQL Warehouses in Azure Databricks
  • Create databases and tables
  • Create queries and dashboards

Module 7: Run Azure Databricks Notebooks with Azure Data Factory

  • Run Azure Databricks notebooks from ADF Pipelines.
  • Create an Azure Data Factory linked service for Azure Databricks.
  • Use a Notebook activity in a pipeline.
  • Pass parameters to a notebook.

Module 8: Introduction to Microsoft Fabric

  • Overview of Microsoft Fabric
  • Microsoft Fabric Terminology
  • Copilot in Microsoft Fabric
  • Microsoft Fabric settings
  • Working with Workspaces
  • Discovering data in OneLake catalog
  • Managing a Workspace with git

Module 9: Getting started with Data Engineering Experiences using Microsoft Fabric

  • Overview of Data Engineering in Microsoft Fabric
  • Working with Lakehouse
  • Data Factory in Microsoft Fabric
  • Working with Data Pipelines in Microsoft Fabric
  • Ingesting Data with Dataflows Gen2

Module 10: Data Engineering using Apache Spark, Delta Lakes and Notebooks

  • Introduction to Spark compute in Microsoft Fabric
  • Apache Spark job definition
  • Apache Spark monitoring in Microsoft Fabric
  • Delta Lake tables optimization and V-Order
  • Using Microsoft Fabric Notebooks

Module 11: Real-Time Intelligence in Microsoft Fabric

  • Work with Eventhouse
  • Get, process and route data in Eventstreams
  • Get data in KQL Database
  • Real-Time data processing using Event Processor
  • Query data from a KQL Queryset
  • Monitor and visualize your data
  • Drive alerts and actions from your data with Activator

Module 12: Implement Microsoft Fabric Data Warehousing

  • Create a Data Warehouse in Microsoft Fabric
  • Data ingestion options
  • Pipelines and Data flows
  • Mirror databases in Fabric
  • Open Mirroring & Clone tables
  • Dimensional modelling in Microsoft Fabric Warehouse
  • Query and monitor the Data Warehouse

Module 13: Power BI semantic models in Microsoft Fabric

  • Choose appropriate storage modes for your semantic model
  • Create relationships between tables in a semantic model
  • Design dynamic elements to extend calculations in a semantic model
  • Enable large semantic model storage format and incremental refresh
  • Optimize DirectQuery models with table level storage.
  • Restrict access to Power BI model data with RLS.
  • Restrict access to Power BI model objects with OLS.

Course Statistics

4

Years of Experience

2156

Gratified Students

26

Training Batches

6542

Training Hours

Gratified Student Feedback - From Year 2000

  • Trainer: Deeksha

    Thank you for this course ,I enjoyed so much , I get know experience and knowledge in using different kinds of Azure online tools which are useful and effective .I'd like to thank Daniel and Trainer Deeksha for amazing and organized job.
    Mohammed Al Jack
    Chicago, US

  • Trainer: Ms. Deeksha

    This course was fast paced and very informative and very helpful for Prep to DP-203 certification. I highly appreciate Ms. Deeksha for being very patient in answering the questions and tried to include all coming from different levels of subject knowledge. Thank you very much Deeksha and Daniel!
    Vidya Nair
    Atlanta, US

  • Trainer: Deeksha

    It was a great Azur data Engineering training. Deeksha is a very good trainer. I will come back for more training. Thanks Daniel.
    Omar Dekama
    Goose Creek, US

  • Trainer: Deeksha Gopal

    The training was very detailed and well structured focusing on Microsoft Azure DP-203 certification. Deeksha, as an experienced trainer, maintained a nice flow from the beginning to end. He answered all the questions raised by the participants and explained in a detailed manner showing the relevant scenario in the lab. Overall, it was a great learning experience towards the goal.
    Haroon Hussain
    Skokie, US

  • Trainer: Deeksha

    It was a good course and Deeksha is very knowledgeable in Azure Data Engineering.
    Shahid Syed
    Chicago, US

  • Trainer: Deeskha

    Deeksha is a great trainer and Azure data engineering course was awesome. Planning to take AZ 203 certification exam soon.
    mujtaba Ahmed
    Carol Stream, US

  • Trainer: Deeksha

    Azure data engineering course was good and I learned something new in Azure. Data Bricks, Delta Lake, Data Factory and Azure Synapse Analytics
    Anil Thota
    Charlotte, US

  • Trainer: Deeksha Gopal

    Very clear and helpful Azure Data Engineering course. . Thank you for Deeksha and Daniel for hosting it.
    Qi Li
    Phoenixville, US

  • Trainer: Deeksha & Raj

    Deeksha and Ashish are great instructors. They explained the topics clearly and have patient in taking and answering questions. I am planning to take the exam next month.
    Temesgen
    Reston, US

  • Trainer: Deeksha

    A very good training experience for us. Deeskha, you are a very good Data Engineer and a great trainer. Thank you!!!
    Eshetu Muluneh
    Nashville, US

  • Trainer: Raj

    Excellent training on Azure Data Engineering. I am getting ready for DP 203 certification exam.
    Ifeanyi Patrick Ikeme
    Peachtree City, US

  • Trainer: Raj

    It was Nice to be in the Team and I had an amazing time in the class . Thank you Raj . I am looking forward to tale certification exam DP 203
    Redwan Omer
    Nashville, US

  • Trainer: Raj

    Raj was very knowledgeable and taught relevant material with real-time examples. I highly recommend him for Microsoft Azure Data Engineering training.
    Sudha Sankisa
    Chicago, US

  • Trainer: Raj

    Excellent Training on Azure Data Engineering with DP 200 certification track. Thank you Raj. I am planning to take the exam next week.
    Mesfin E Yimer
    Houston, US

  • Trainer: Raj

    It was really informative and good practical lab sessions as well.
    Vyshnavi Kalyan Gadde
    Redmond, US

  • Trainer: Raj

    I really enjoyed the training especially the material covered and the trainer was the best in class.
    SHAHBAZ HUMAYUN
    Bradford Woods, US

  • Trainer: Raj

    Raj is vey good and very knowledgeable teacher. Overall its a good course and very affordable pricing.
    Mohammed Khalil
    Turnersville, US

  • Trainer: Raj

    Great instructor and wonderful Azure Data Engineering course. I will take the Microsoft certification exam next month.
    Ashutosh Atre
    Ames, US

  • Trainer: Raja

    The course was interesting and the instructor was resourceful. Overall, its a great Azure data engineering course and I am looking forward to tale certification exam.
    Efrem Araya
    Phoenix, US

  • Trainer: Naveen Venkatesh

    I have taken Microsoft Azure BI Training. I am very pleased with the comprehensive course content and the way every topic is taught by him. He is highly experienced and very knowledgeable, provides training at a good pace, and most importantly,
    Md Saddam Hossain
    Everett, US

  • Trainer: Naveen V

    Excellent Azure BI training . Great trainer, structured course and affordable. Thank you. !!!!
    Anto S Srinivasan
    New York City, US

Empire Data Systems

Social Links