Introduction
SQL for Data Science
Welcome
Introduction
1
Why Learn SQL?
2
Setup
Query
3
SELECT Statements
4
Data Types
5
Aggregating with GROUP BY
6
Joining Tables
7
Set Operations
Analyze
8
Conditional Expressions
9
Subqueries and CTEs
10
Window Functions
11
Connecting R to a Database
12
Connecting Python to a Database
Design
13
Keys and Referential Integrity
14
Entity-Relationship Diagrams
15
Database Normalization
16
Creating Tables
17
Views and Materialized Views
18
Building a Schema
19
Programmability
20
Security
21
Indexes
Load
22
Extracting Data from Files and APIs
23
Transforming Data with Polars
24
Loading Data into PostgreSQL with SQLAlchemy
25
A Complete ETL Pipeline
Deploy
26
Getting Started with Supabase
27
Deploying from VS Code
28
Database Migrations
Labs
29
SQL Injection
References
In Development:
This textbook is currently undergoing development and should not be used as an authoritative source of... well, ANYTHING.
Introduction
Welcome
1
Why Learn SQL?