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.

English +19 moreNewFree

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.

You're here
SQL Language
Free
Instant Notion duplicate

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

👑 Most complete
Developer Code Library
$24.62
One-time purchase · Lifetime access

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
12 templates inside — what they Cost
HTML$2.92
CSS$2.92
JavaScript$2.92
TypeScript$2.92
React & React Native$5.92
Node, Next.js & Vue$8.92
Swift & SwiftUI$5.95
Kotlin + KMP$5.95
Dart & Flutter$5.92
C++$2.92
C#$2.92
Bought separately$50.18
Developer Library$24.62
You save$25.56

14-day money-back guarantee from Notion

🆕 What's new in v1.0
  • ✦ Initial public release of the template.
  • ✦ All 47 chapters complete across the SQL and PL/SQL tracks.
  • ✦ Clean light & dark-friendly layout.

You might also like.

Free
Free · Instant Notion duplicate
Get the Template → 👑 Upgrade to Pro →

Instant delivery · Notion account required

LanguagesEnglish +19 more
DownloadsNew
RatingNew
Versionv1.0
CategoryLearning
Last UpdatedJun 2026
FormatNotion Template