Course

Learn SQL Basics for Data Science

University of California, Davis

This Specialization is perfect for learners with no coding experience who want to master SQL for data science. You'll tackle progressively challenging projects covering SQL basics, data wrangling, analysis, AB testing, and distributed computing with Apache Spark and Delta Lake.

  • Master SQL commands to filter, sort, and summarize data
  • Manipulate strings, dates, and numerical data from various sources
  • Use Databricks workspace to create end-to-end pipelines and scalable Spark SQL code
  • Develop a project proposal, perform statistical analysis, and present findings

Certificate Available ✔

Get Started / More Info
Learn SQL Basics for Data Science
Course Modules

This specialization features four modules covering SQL basics, data wrangling, distributed computing with Spark SQL, and a capstone project. Each module equips learners with essential skills for data analysis and manipulation using SQL.

SQL for Data Science

Module 1: SQL for Data Science

  • Learn to write SQL queries to filter, sort, and summarize data
  • Integrate data from different sources using functions

Data Wrangling, Analysis and AB Testing with SQL

Module 2: Data Wrangling, Analysis and AB Testing with SQL

  • Validate and clean datasets
  • Build a testing framework for AB Testing

Distributed Computing with Spark SQL

Module 3: Distributed Computing with Spark SQL

  • Write scalable Spark SQL code in a collaborative Databricks workspace
  • Build an end-to-end data pipeline and a medallion lakehouse architecture with Delta Lake

SQL for Data Science Capstone Project

Module 4: SQL for Data Science Capstone Project

  • Develop a project proposal and select data
  • Perform descriptive statistics and advanced techniques in SQL
More Data Analysis Courses

Create Technical Stock Charts Using R and Quantmod

Coursera Project Network

Learn to use R and Quantmod to pull stock data, apply technical indicators, and create technical stock charts in this 1-hour project-based course.

Google Data Analytics Capstone: Complete a Case Study

Google

Complete a case study to prepare for the data analytics job hunt in the Google Data Analytics Capstone course.

Quantitative Text Analysis and Textual Similarity in R

Coursera Project Network

Quantitative Text Analysis and Textual Similarity in R is a comprehensive project that delves into document similarity and textual analysis using R, covering document...

데이터 기반 의사결정을 위한 질문

Google

데이터 기반 의사결정을 위한 질문은 Google 데이터 애널리틱스 수료증 과정의 두 번째 강좌로, 데이터 애널리스트 직무에...