Complete Intro to SQL
Watch on Frontend Masters
Complete Intro to SQL
and PostgreSQL
Brian Holt
Stripe
Watch on Frontend Masters
Table of Contents
Welcome
Introduction
Docker
Databases and Tables
Databases
Tables
Data
Inserts
Updates and Deletes
Selects
Like and Functions
Node.js and PostgreSQL
Project
Joins and Constraints
Relationships
Other Types of Joins
Foreign Keys
Many-to-Many Relationships
Constraints
Project
JSONB
Unstructured Data
JSONB
When to Use
Aggregation
Aggregation
HAVING
Functions Triggers and Procedures
Functions
Procedures
Triggers
The Movie Database
Exercises
Answers
pgAdmin
Query Performance
Explain
Indexes
Create an Index
GIN
Partial Indexes
Derivative Value Indexes
Views
Basic Views
Materialized Views
Subqueries
How to Subquery
Arrays
Transactions
Transactions
Window Functions
Window Functions
Self Join
Self Join
Conclusion
Congrats
Project