Get Data from a Database – Introduction to SQL with Paul Buffa, Part 1

Course Description
In this course, you’ll learn the SQL basics for pulling and wrangling data, including: the main SQL clauses (SELECT, FROM, WHERE, GROUP BY, etc.), aggregation functions, joins, window functions and how to impress your friends and colleagues with lightning fast queries.

Part 1: Get Data from a Database
What are relational databases?
Working with SQL in Observable, DuckDB
The SQL clauses
SELECT, SELECT DISTINCT and GROUP BY