Introduction
Course introduction
()
What you should know
()
1. Introduction to Databricks
What is Databricks?
()
Setting up a Databricks workspace
()
Navigating the Databricks interface
()
Introduction to Databricks notebooks
()
Create a single-node cluster for practice
()
2. Getting Started with Databricks
Understanding the Databricks File System (DBFS)
()
Load sample data in DBFS
()
Browse and explore data in DBFS
()
3. Read Data with Databricks
Understand DataFrames
()
Read a CSV file in Databricks
()
Use a schema to read a file in Databricks
()
Read a JSON file in Databricks
()
Read a Parquet file in Databricks
()
Handle nested JSON data in Databricks
()
4. PySpark Transformation in Databricks
Use filter and where transformations in PySpark
()
Add or remove columns in PySpark
()
Use the select function in PySpark
()
Use UNION and DISTINCT in PySpark
()
Handle nulls in PySpark
()
Use sortBy and orderBy in PySpark
()
Use groupBy and aggregation in PySpark
()
Manipulate strings in PySpark
()
Handle date manipulation in PySpark
()
Handle timestamp manipulation in PySpark
()
5. Write a DataFrame in Databricks
Write a DataFrame as a file in DBFS
()
Write a DataFrame as using partitioning
()
6. Spark SQL in Databricks
What is Spark SQL?
()
Create temporary views in Databricks
()
Create global temp views in Databricks
()
Use Spark SQL transformations
()
Write DataFrames as managed tables in PySpark
()
Write a DataFrame as external table in PySpark
()
7. Delta Lake and Delta Tables in Databricks
What is Delta Lake and its benefits?
()
Create Delta tables
()
Handle DML operations in Delta tables
()
Time travel using Delta Lake
()
8. Join Optimizations in Databricks
Handle multiple types of join
()
Broadcast join
()
Bucketing in PySpark
()
9. Scheduling the Notebook
Notebook job scheduling
()
10. Cluster Management in Databricks
Understand the interactive cluster
()
Explore cluster configuration and the UI
()
Understand job clusters
()
11. Workflows in Databricks
Understand workflows in Databricks
()
Create a workflow in Databricks
()
12. dbutils in Databricks
What is dbutils in Databricks?
()
dbutils fs commands
()
dbutils mounting
()
dbutils notebook
()
13. Unity Catalog in Databricks
Understand the Unity Catalog
()
14. Capstone Project
Project use case
()
Solution
()
Ex_Files_Complete_Guide_to_Databricks.zip
(1.7 MB)