Databases & SQL
Store data for real on PostgreSQL: tables, keys, CRUD, joins, aggregates, constraints, transactions and relational algebra, with an animation on every lesson.
Every lesson runs real code in your browser, checked the moment you submit. No installing anything, no setup, no waiting.
Start Databases & SQL freeWhat this course covers
- What is a Database?
- Tables, Keys and Relationships
- Designing Data: ERD and Normalization
- SQL vs NoSQL
- Meet PostgreSQL, and What SQLite Is For
- Databases: Store Data for Real
- Add & Read Data (INSERT, SELECT)
- Filtering with WHERE
- Sorting & Counting
- NULL: The Value That Is Not There
- Update & Delete (full CRUD)
- Relationships & JOIN
- Aggregating Data: GROUP BY & HAVING
- Joins in Depth: INNER, LEFT & Self
- Relational Algebra: The Maths Under SQL
- Subqueries & Nested Queries
- Data Integrity: Constraints & Keys
- Normalization: 1NF, 2NF, 3NF
- Indexes & Query Performance
- Transactions & ACID
- Views & Reusable Reports
- Capstone: Build a Library and Ask It Questions
Other courses
Learn to think like a problem-solver before you write a single line of code. Break big …
Your first Python course, no experience needed. Learn variables, loops, functions, and …
Level up your Python with comprehensions, lambdas, error handling, files, modules, and …
Master OOP in Python: classes, objects, inheritance, polymorphism, encapsulation, abstr…
Go deeper in Python: decorators, generators, type hints, regex, JSON, SQLite, testing, …
Core CS: arrays, lists, stacks, queues, hash tables, trees, graphs, sorting, searching,…
Build your own 2D games from scratch: the game loop, sprites, movement, collisions, and…
Learn Java from zero, with no programming background needed. Write your first program, …
Learn C++ from zero, with no programming background needed. Start with your first progr…
Learn C from zero, with no programming background needed. The language that Unix, Linux…
Learn JavaScript from scratch: variables, types, loops, functions, arrays and objects, …
Build for the browser: structure pages with HTML, style them with CSS, then use live AP…