Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Coding Exercises: SQL Data Science

via LinkedIn Learning

Write review
Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More → Unihackers Ad

Launch Your Cybersecurity Career in 6 Months

Learn More →

Overview

Syllabus

Introduction
  • Up for a code challenge?
  • How to use the CoderPad environment
1. SQL Fundamentals
  • Column selection
  • Filtering rows from data
  • Removing duplicate data
  • Sorting and grouping query results
2. SQL Joins
  • Inner joins
  • Outer and cross joins
  • Set theory for SQL joins
3. Writing Complex Queries
  • Using OVER and PARTITION BY statements
  • Filtering and subsetting data
  • Using CASE and WHEN statements
  • Calculating moving window average
4. Data Cleaning with SQL
  • Partitioning dates with the DATE_PART function
  • Text formatting and pattern matching
  • Using COALESCE to replace null values
  • Sorting with regular expressions

Taught by

Harshit Tyagi

Reviews

4.5 rating at LinkedIn Learning based on 235 ratings

Start your review of Coding Exercises: SQL Data Science

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.