SQL Language
Master SQL and PL/SQL from first SELECT to shipped developer: 47 chapters covering joins, window functions, CTEs, transactions, cursors, triggers and procedures — with runnable code, traps flagged, practice + bonus challenges, and four capstone projects with full solutions.
SQL Language is a free 47-chapter Notion roadmap covering SQL and PL/SQL, from SELECT, table design and joins to CTEs, window functions, transactions and stored procedures.
Study the examples, practice challenges and solutions before applying the concepts to the four capstone projects: a bookstore, gym tracker, budget app and inventory reorder engine.
What’s inside
- Schema & Data — designing tables, data types, constraints, and getting data in with INSERT, UPDATE, and DELETE
- Query Craft — SELECT in depth, filtering, sorting, grouping, and the aggregate functions that answer real questions
- Combining Data — every join, subqueries, set operations, CTEs, and window functions for analytics
- Performance & Design — views, indexes, transactions and ACID, and normalization that keeps data clean
- The PL/SQL Track — blocks, cursors, exceptions, functions, stored procedures, triggers, and GRANT, across 22 dedicated chapters
- "Try Every Possibility" code, trap-annotated — idioms and the famous traps marked -- BROKEN: and -- ILLEGAL:, so you meet them in safety first
- A practice challenge + a harder bonus in every chapter — with hidden solutions and a dedicated Challenge Answers chapter
- 4 Capstone Projects — the Bookstore, the Gym Tracker, the Budget App, and the Inventory Reorder Engine
See what you get with Pro.
The SQL guide is a complete starting point; the Library is every language track in one place.
A complete SQL & PL/SQL roadmap — from first SELECT to shipped developer, free from day one.
- Full SQL track — schema & data, SELECT in depth, joins, CTEs & window functions
- Performance & design — views, indexes, transactions & normalization
- The PL/SQL track — cursors, procedures & triggers, 22 chapters
- Trap-annotated code — idioms plus -- BROKEN: / -- ILLEGAL: traps
- Practice + bonus challenge every chapter, hidden solutions
- 4 capstone projects with full solutions
- Not included: 27-chapter Intro to CS course — one foundation in universal pseudocode, from how computers think to trees, graphs & Big-O
- Not included: 11 complete language templates — HTML, CSS, JavaScript, TypeScript, React, Node.js, Swift, Kotlin, Dart, C# & C++
- Not included: Web core track — HTML, CSS, JavaScript & TypeScript
- Not included: Front-end & full-stack frameworks — React, Node.js, Next.js & Vue.js
- Not included: Mobile & cross-platform — Swift & SwiftUI, Kotlin + KMP, Dart & Flutter
Instant delivery · Notion account required
The full multi-language library the SQL guide graduates into.
- 27-chapter Intro to CS course — how computers think, data structures, trees, graphs & Big-O, in universal pseudocode
- The full web track — HTML, CSS, JavaScript & TypeScript, then React, Node.js, Next.js & Vue.js: zero to full-stack
- Mobile & systems languages — Swift, Kotlin + KMP, Dart & Flutter, C++ and C#: apps, games and native code
14-day money-back guarantee from Notion
- ✦ Initial public release of the template.
- ✦ All 47 chapters complete across the SQL and PL/SQL tracks.
- ✦ Clean light & dark-friendly layout.