Microsoft Azure Data Factory

Microsoft Azure Data Factory

Microsoft Azure Data Factory

Course Duration: 8 days ( 48 hrs )
Course Fees: £1500   

About Us

LSA Training is an institution providing professional education to individuals pursuing career growth in an increasingly sophisticated and competitive world. We aim to promote excellence in education and training in both the academic and corporate world.

Duration :5 days( 40 Hours )

  • Week day Batches: ( Mon to Thur 10am to 4pm ) 8 Days
  • Weekends Batches: ( Sat & Sun 10am to 4pm ) 4 weekends


Course DescriptionCourse ContentHighlights

About Microsoft Azure Data Factory Training Course

Microsoft Azure DP-200 certification training gives learners the opportunity to get used to implementing Azure Data Solution. This training ensures that learners improve their skills on Microsoft Azure SQL Data Warehouse, Azure Data Lake Analytics, Azure Data Factory, and Azure Stream Analytics, and then perform data integration and copying using Hive and Spark, respectively. Also, real-world projects would be provided. Further the course in line with the Azure DP 201 exam as well. Therefore, the learners will learn to design the Azure Data Solutions, Data Processing, and Data Security.

Module 1: Non-Relational Data Stores and Azure Data Lake Storage
Non-Relational Data Stores and Azure Data Lake Storage

  • Document data stores
  • Columnar data stores
  • Key/value data stores
  • Graph data stores
  • Time series data stores
  • Object data stores
  • External index
  • Why NoSQL or Non-Relational DB?
  • When to Choose NoSQL or Non-Relational DB?
    • Best Uses
    • Scenarios
  • Azure Data Lake Storage
    • Definition
    • Azure Data Lake-Key Components
    • How it stores data?
    • Azure Data Lake Storage Gen2
    • Why Data Lake?
    • Data Lake Architecture
Module 2: Data Lake and Azure Cosmos DB
Data Lake and Azure Cosmos DB

  • Data Lake Key Concepts
  • Azure Cosmos DB
  • Why Azure Cosmos DB?
  • Azure Blob Storage
  • Why Azure Blob Storage?
  • Data Partitioning
    • Horizontal partitioning
    • Vertical partitioning
    • Functional partitioning
  • Why Partitioning Data?
  • Consistency Levels in Azure Cosmos DB
    • Semantics of the five-consistency level


  • Load Data fromAmazonS3 to ADLS Gen2 with Data Factory
  • Working with Azure Cosmos DB
Module 3: Relational Data Stores
Relational Data Stores

  • Introduction to Relational Data Stores
  • Azure SQL Database
    • Deployment Models
    • Service Tiers
  • Hands-on: Create a Single Database Using Azure Portal
  • Hands-on: Create a managed instance
  • Hands-on: Create an elastic pool
  • Why SQL Database Elastic Pool?
  • Hands-on: Create a SQL virtual machine
  • Hands-on: Configure active geo-replication for Azure SQL Database in the Azure portal and initiate failover.
Module 4: Why Azure SQL?
  • Azure SQL Security Capabilities
  • High-Availability and Azure SQL Database
    • Standard Availability Model
    • Premium Availability Model
  • Azure Database for MySQL
  • Hands-on: Design an Azure Database for MySQL database using the Azure portal
  • Hands-on: Connect using MySQL Workbench
  • Azure Database for PostgreSQL
  • Hands-on: Design an Azure Database for PostgreSQL – Single Server
  • Azure Database For MariaDB
  • Hands-on: Create an Azure Database for MariaDB server by using the Azure portal
  • What is PolyBase ?
    • Why PolyBase?
  • What is Azure Synapse Analytics (formerly SQL DW)?
    • SQL Analytics and SQL pool in Azure Synapse
    • Key component of a big data solution
    • SQL Analytics MPP architecture components
  • Hands-on: Import Data From Blob Storage to Azure Synapse Analytics by Using PolyBase
Module 5: Azure Data Factory
  • Flow Process of Data Factory
  • Why Azure Data Factory
  • Integration Runtime in Azure Data Factory
  • Mapping Data Flows
  • Hands-on: Transform data using Mapping data flows
Module 6: Azure Data Bricks
  • What is Azure Databricks?
  • Azure Spark-based Analytics Platform
  • Apache Spark in Azure Databricks
  • Hands-on: Run a Spark Job on Azure Databricks using the Azure portal
  • Hands-on: ETL Operation by using Azure Databricks
  • Hands-on: Stream data into Azure Databricks using Event Hubs
Module 7: Azure Stream Analytics
  • Working of Stream Analytics
    • Key capabilities and benefits
    • Hands-on: Analyze phone call data with stream analytics and visualize results in Power BI dashboard
  • Stream Analytics Windowing Functions
    • Tumbling window
    • Hopping Window
    • Sliding Window
    • Session Window
Module 8: Monitoring & Security
  • What is Azure Monitor?
    • Metrics
    • Logs
    • Metrics Vs Logs
  • What data does Azure Monitor collect?
  • What can you Monitor?
    • Insights and Core Solutions
  • Alerts in Azure
    • Flow of Alerts
    • Key Attributes of an Alert Rule
    • What can you set alert on?
    • Manage alerts
    • Alert States
    • How to create an alert?
  • Hands-on: Create, View, and Manage Metric alerts using Azure Monitor
  • Hands-on: Monitor your Azure Data Factory Pipelines proactively with Alerts
  • Azure Security Logging & Auditing
    • Types of Logs in Azure
    • Azure SQL Database Auditing
    • Server-level vs. Database-level Auditing Policy
  • Hands-on: Azure SQL Database Auditing

Training Highlights

  • Instructor Led – Face2Face / class room training
  • More interaction with student to faculty and student to student.
  • Detailed presentations. Soft copy of Material to refer any time.
  • Practical oriented / Job oriented Training. Practice on Software Tools & Real Time project scenarios.
  • Mock interviews / group discussions / interview related questions.
  • Test Lab is in Cloud Technology – to practice on software tools if needed.
  • We discuss about the real time project domains.
  • The teaching methods / tools / topics we chosen are based on the current competitive job market.

Also on this course we offer the following

  • Hands on Experience
  • Real Time project work
  • Interview based Training

Expected Salary/ Pay Package

  • Expected Salaries are as follows:
  • For Contractors £400 to £800 per day
  • Permanent Positions £50 to £100k per annum all depends on experience and skills set

Call us for more details on: +44 – 203 371 0546, or contact us at:

A Few of Our Clients