
Build data pipelines with Apache Spark and Databricks, using Delta Lake and Dbfs volumes, then explore lakehouse concepts and the Databricks data lakehouse platform with hands-on Python, Scala, and SQL.
Ingest, transform, and persist data using Apache Spark on Databricks. Create data frames with a spark session and store results in Delta tables.
Explore the complete data workflow in Databricks using Unity Catalog and Delta tables: ingest, read, transform, and write data into Delta tables with ACID transactions and time travel.
Explore delta tables as data lake components, storing parquet data accessible via SQL or spark, with versioning, time travel, and ACID transactions, while the delta log records changes.
Explore storing data in a delta table with Databricks, perform transformations, and use delta time travel to query, restore, and audit table versions across Spark SQL.
Run an AWS Glue Studio ETL job to read bank prospect data from the data catalog, drop the purchased field, and store the CSV output in an S3 bucket.
Explore Amazon EventBridge, a serverless event bus for real-time, decoupled communication using publish-subscribe patterns, rules, and event transformations to multiple targets.
Set up an EventBridge rule to capture S3 object created events and trigger an SNS topic notification, delivered via email, demonstrating AWS services integration.
Orchestrate three Lambda functions in a Step Functions state machine to add, multiply, and subtract, with a visual editor showcasing the workflow and successful execution results.
Master the foundations of AWS EC2 for Amazon EMR, launching an Amazon Linux instance, configuring key pairs and security groups, and accessing it via EC2 Instance Connect or Cloud Shell.
Build a data pipeline on Amazon EMR to run a Spark transformation with PySpark, reading bank prospects data from S3, filtering null values, and saving the cleaned output back to S3.
Thank you for enrolling in this course; access resources, exclusive Udemy coupons, and subscribe to our YouTube channel for educational blogs to support your learning journey.
Data Engineering is a vital component of modern data-driven businesses. The ability to process, manage, and analyze large-scale data sets is a core requirement for organizations that want to stay competitive. In this course, you will learn how to build a data pipeline using Apache Spark on Databricks' Lakehouse architecture. This will give you practical experience in working with Spark and Lakehouse concepts, as well as the skills needed to excel as a Data Engineer in a real-world environment.
Throughout the Course, You Will Learn:
Conducting analytics using Python and Scala with Spark.
Applying Spark SQL and Databricks SQL for analytics.
Developing a data pipeline with Apache Spark.
Becoming proficient in Databricks' free edition.
Managing a Delta table by accessing version history, restoring data, and utilizing time travel features.
Unity Catalog Volumes - File Storage and Operations
Optimizing query performance using Delta Cache.
Working with Delta Tables and Databricks File System.
Gaining insights into real-world scenarios from experienced instructors.
Course Structure:
Beginning with familiarizing yourself with Databricks' free edition and creating a basic pipeline using Spark.
Progressing to more complex topics after gaining comfort with the platform.
Learning analytics with Spark using Python and Scala, including Spark transformations, actions, joins, Spark SQL, and DataFrame APIs.
Acquiring the knowledge and skills to operate a Delta table, including accessing its version history, restoring data, and utilizing time travel functionality using Spark and Databricks SQL.
Understanding how to use Delta Cache to optimize query performance.
Optional Lectures on AWS Integration:
'Setting up Databricks Account on AWS' and 'Running Notebooks Within a Databricks AWS Account.'
Building an ETL pipeline with Delta Live Tables
Providing additional opportunities to explore Databricks within the AWS ecosystem.
This course is designed for Data Engineering beginners with no prior knowledge of Python and Scala required. However, some familiarity with databases and SQL is necessary to succeed in this course. Upon completion, you will have the skills and knowledge required to succeed in a real-world Data Engineer role.
Throughout the course, you will work with hands-on examples and real-world scenarios to apply the concepts you learn. By the end of the course, you will have the practical experience and skills required to understand Spark and Lakehouse concepts, and to build a scalable and reliable data pipeline using Spark on Databricks' Lakehouse architecture.
This course uses high-quality AI-generated text-to-speech narration to complement the powerful visuals and enhance your learning experience.