Apache Spark is one of the most widely used technologies in big data analytics. In this course, you will learn how to leverage your existing SQL skills to start working with Spark immediately. You will also learn how to work with Delta Lake, a highly performant, open-source storage layer that brings reliability to data lakes. By the end of this course, you will be able to use Spark SQL and Delta Lake to ingest, transform, and query data to extract valuable insights that can be shared with your team.
This course is part of the Data Science with Databricks for Data Analysts Specialization
Offered By
About this Course
68,717 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 1 of 3 in the
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Familiarity with SQL
Approx. 14 hours to complete
English
Subtitles: English
What you will learn
Ingest, transform, and query data to extract valuable insights.
Leverage existing SQL skills to start working with Apache Spark.
Skills you will gain
Data AnalysisSpark SQLSQL
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 1 of 3 in the
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Familiarity with SQL
Approx. 14 hours to complete
English
Subtitles: English
Offered by
Databricks
Databricks is the data and AI company. Founded by the creators of Apache Spark™, Delta Lake and MLflow, organizations like Comcast, Condé Nast, Nationwide and H&M rely on Databricks’ open and unified platform to enable data engineers, scientists and analysts to collaborate and innovate faster.
Syllabus - What you will learn from this course
27 minutes to complete
Welcome to Apache Spark SQL for Data Analysts
An introduction to this course including learning objectives, frequently asked questions, and a chance to get to know fellow classmates.
27 minutes to complete
1 video (Total 2 min), 1 reading, 1 quiz
1 hour to complete
Spark makes big data easy
1 hour to complete
6 videos (Total 21 min)
6 videos
What is big data?6m
Common struggles with big data4m
Big Data Needs2m
Apache Spark Intro3m
Spark SQL2m
1 practice exercise
Module 2 Concept Review30m
3 hours to complete
Using Spark SQL on Databricks
3 hours to complete
9 videos (Total 19 min), 4 readings, 2 quizzes
9 videos
Signing up for Databricks Community Edition1m
Preparing your workspace2m
Working with notebooks3m
Using course materials6m
Basic queries with Spark SQL reading introduction1m
Data Visualization on Databricks reading introduction38s
Data visualization tools1m
Exploratory Data Analysis lab introduction25s
4 readings
Course Materials5m
Basic Queries reading activity30m
Data Visualization reading activity30m
Your turn! Exploratory Data Analysis lab30m
2 practice exercises
Module 3 Concept Review30m
3.3 Exploratory Data Analysis Quiz15m
1 hour to complete
Spark Under the Hood
1 hour to complete
7 videos (Total 32 min)
7 videos
Understanding optimizations7m
The physical cluster3m
The SparkUI and SQL tab2m
Optimizing query logic4m
Impact of Caching6m
Optimizing with selective data loading6m
1 practice exercise
Module 4 Concept Review30m
Reviews
TOP REVIEWS FROM APACHE SPARK (TM) SQL FOR DATA ANALYSTS
by SKJan 12, 2021
Course is good but lot of cleanup and errors need to be fixed. Final exam it self has incorrect questions. Also someone should be answering the questions raised by students in the forum.
by RWDec 22, 2020
Many of the videos (all that introduced the notebooks) were not necessary and I stopped watching them. The course introduced me to some spark sql functions that I was unaware of.
by IEDec 28, 2020
Nice work but the exam is not real test to the materials , and it is not difficult but I would say strange and difficult to read
by ALNov 13, 2020
Riddled with spelling AND CODE errors, but was a great resource for improving my lacking SQL skills.
About the Data Science with Databricks for Data Analysts Specialization
This specialization is intended for data analysts looking to expand their toolbox for working with data. Traditionally, data analysts have used tools like relational databases, CSV files, and SQL programming, among others, to perform their daily workflows. In this specialization, you will leverage existing skills to learn new ones that will allow you to utilize advanced technologies not traditionally linked to this role - technologies like Databricks and Apache Spark. By the end of this specialization, you'll be able to solve real-world business problems with Databricks and the most popular machine learning techniques.
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
More questions? Visit the Learner Help Center.
