Mastering Databricks & Apache spark -Build ETL data pipeline

Learn fundamental concept about databricks and process big data by building your first data pipeline on Azure

Welcome to the course on Mastering Databricks & Apache spark -Build ETL data pipeline

What you’ll learn

  • Databricks.
  • Build your first data pipeline to process CSV, JSON, XML.
  • Orchestrate data pipeline on Azure data factory.
  • Spin up spark cluster.
  • Delta tables.
  • Concept of time travel and vacuum on delta tables.
  • Apache Spark SQL.
  • Filtering Dataframe.
  • Renaming, drop, Select, Cast.
  • Aggregation operations SUM, AVERAGE, MAX, MIN.
  • Rank, Row Number, Dense Rank.
  • Building dashboards.
  • Build Complete project.
  • Build End to End data pipeline.

Course Content

  • Getting Started with Databricks –> 11 lectures • 15min.
  • Extraction of Data –> 5 lectures • 30min.
  • Transformation of Data –> 18 lectures • 2hr 15min.
  • Processing XML, JSON, Delta tables –> 3 lectures • 33min.
  • Loading data and building ETL data pipeline with dashboard –> 10 lectures • 49min.

Mastering Databricks & Apache spark -Build ETL data pipeline

Requirements

  • There are no pre requisites with this course.

Welcome to the course on Mastering Databricks & Apache spark -Build ETL data pipeline

Databricks combines the best of data warehouses and data lakes into a lakehouse architecture. In this course we will be learning how to perform various operations in Scala, Python and Spark SQL. This will help every student in building solutions which will create value and mindset to build batch process in any of the language. This course will help in writing same commands in different language and based on your client needs we can adopt and deliver world class solution. We will be building end to end solution in azure databricks.

 

Key Learning Points

  • We will be building our own cluster which will process our data and with one click operation we will load different sources data to Azure SQL and Delta tables
  • After that we will be leveraging databricks notebook to prepare dashboard to answer business questions
  • Based on the needs we will be deploying infrastructure on Azure cloud
  • These scenarios will give student 360 degree exposure on cloud platform and how to step up various resources
  • All activities are performed in Azure Databricks

Fundamentals

  • Databricks
  • Delta tables
  • Concept of versions and vacuum on delta tables
  • Apache Spark SQL
  • Filtering Dataframe
  • Renaming, drop, Select, Cast
  • Aggregation operations SUM, AVERAGE, MAX, MIN
  • Rank, Row Number, Dense Rank
  • Building dashboards
  • Analytics

This course is suitable for Data engineers, BI architect, Data Analyst, ETL developer, BI Manager

Get Tutorial