This Specialization is intended for a learner with no previous coding experience seeking to develop SQL query fluency. Through four progressively more difficult SQL projects with data science applications, you will cover topics such as SQL basics, data wrangling, SQL analysis, AB testing, distributed computing using Apache Spark, Delta Lake and more. These topics will prepare you to apply SQL creatively to analyze and explore data; demonstrate efficiency in writing queries; create data analysis datasets; conduct feature engineering, use SQL with other data analysis and machine learning toolsets; and use SQL with unstructured data sets.
What's inside
Four courses
SQL for Data Science
(0 hours)
SQL for Data Science
(0 hours)
Data Wrangling, Analysis and AB Testing with SQL
(0 hours)
Data Wrangling, Analysis and AB Testing with SQL
(0 hours)
Distributed Computing with Spark SQL
(0 hours)
Distributed Computing with Spark SQL
(0 hours)
SQL for Data Science Capstone Project
(0 hours)
SQL for Data Science Capstone Project
(0 hours)Learning objectives
- Use sql commands to filter, sort, & summarize data; manipulate strings, dates, & numerical data from different sources for analysis
- Assess and create datasets to solve your business questions and problems using sql
- Use the collaborative databricks workspace and create an end-to-end pipeline that reads data, transforms it, and saves the result
- develop a project proposal & select your data, perform statistical analysis & develop metrics, and present your findings & make recommendations
- Use sql commands to filter, sort, & summarize data; manipulate strings, dates, & numerical data from different sources for analysis
- Assess and create datasets to solve your business questions and problems using sql
- Use the collaborative databricks workspace and create an end-to-end pipeline that reads data, transforms it, and saves the result
- develop a project proposal & select your data, perform statistical analysis & develop metrics, and present your findings & make recommendations
Save this collection
Save
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
