Oneqsoft

Menu
Job Portal
Start Course

Azure Data Factory & DataBricks - Mastering Cloud Data Processing

One-Q Soft offers you complete practical and Real-time ETL Azure Data Factory and Databricks training with basic to advanced concepts along with DWH Concepts.

Here in One-Q Soft– along with this course we also include concept wise documentation, Real-time scenario, Project solution, Project use case & interview preparation guidance for your job interviews.

Why only One-Q Soft

  • 1400+ professionals trained on different technologies.
  • Splendid Certified and Experienced Trainers.
  • Highly Interactive & Classroom training
  • Customised complete course notes
  • Job guidance
  • Guidance on official certification

Azure Data factory & DataBricks Training Highlights

  • Free Demo class
  • 45 days class room training
  • Successfully trained 1000+ learners
  • Customised course notes & recorded ccource videos
  • Live instructor-LED Online and Classroom training
  • Real-time practical guidance
  • Doubt clarification schedules
  • Basic to advanced training
  • Interview Guidance

Azure Data factory & DataBricks

ETL testing is done to ensure that the data that has been loaded from a source to the destination after transformation is performed. It also involves the validation of data in different stages used between source and destination using ADF ,ADB and Pyspark. ETL stands for Extract-Transform-Load.

Apart from delivering you the best ETL Development training, you will also get many other extra learning concepts which include, advanced material for ETL Development interview questions and Job Guidance.

Azure Data factory & DataBricks COURSE CURRICULUM

1, Data warehouse overview

    • a. Data Warehouse Product introduction

    • b. Launching a Data Warehouse Instance

    • c. Typical Data Warehouse Architecture

  • 2, Technical concepts related to data warehousing

    • a. Data Warehouse Basics

    • b. Time Zones

    • c. File Formats

    • d. Stages

    • e. Functions/Procedures/  Sequences, etc,.

  • 3, Overview to Matillion

    • a. Matillion ETL Product Overview

    • b. Matillion architecture

    • c. Launching a Matillion ETL Instance

  • 4, Exploring the core concepts of matillion

    • a. Matillion project creation

    • b. Folder creation

  • 5, Orchestration

    • a. Adding Data Sources

    • b. Connectors

    • c. Connector Authentication

    • d. Cloud Storage

    • e. DDL

    • f. Flow Components

    • g. Generators

    • h. Messaging

    • i. Scripting

    • j. Variables

  • 6, Transformation

    • a. Transform

    • b. Join

    • c. Read

    • d. Write

  • 7, Components

    • a. Loading Data

    • b. Expression Editors

    • c. URL Safe Characters

    • d. Incremental Load Tools

  • 8, Scheduling Job

    • a. Jobs

    • b. Job Concurrency

    • c. Shared Jobs

    • d. Task Management

    • e. Generate Job Documentation

    • f. Data Lineage

  • 9, Environment

    • a. UI And Basic Functions

    • b. Enterprise Mode

    • c. Admin Menu

  • 10, Administration

    • a. Understanding about the Managing of Backups

    • b. Backups (GCP)

    • c. Backups (Azure)

  • 11, Migration

    • a. Explore on how to Import and export the Projects

    • b. Learn to perform the Import Job and Export Job