Engram · SQL — real PostgreSQL

SQL you still write in week eight.

Sixteen chapters, from how a query is evaluated to the patterns analysts use every day. Every query runs on a real PostgreSQL engine inside your browser — nothing to install.

16 chapters · 201 topics · 11,073 cards · 2 chapters free
Six ways into every topic

From reading it
to using it.

Every topic is practised six ways, and each good answer pushes the next review further away.

01 · DECODE Read it One idea, with the query and its result side by side.
02 · QUIZ Pick it Four options; every wrong one is a real mistake people make.
03 · RECALL Say it Answer from memory, then reveal. Pulling it out is what makes it stay.
04 · PREDICT Predict the result Say what comes back before you run it — the skill interviews test.
05 · SOLVE Write it Your query on real tables, marked on the rows it returns.
06 · APPLY Use it A situation from real work: choose the approach and explain why.
Syllabus

16 chapters.

Core covers what every chapter needs day to day. Advanced goes deeper in the same chapters.

  1. 01 The relational model and query evaluation
  2. 02FREE · CORE SELECT, filtering, sorting and paging
  3. 03 NULL and three-valued logic
  4. 04 Joins
  5. 05 Set operations and subqueries
  6. 06 Aggregation and grouping
  7. 07FREE · ADVANCED Window functions
  8. 08 CTEs, recursion and LATERAL
  9. 09 Types, text and numbers
  10. 10 Dates, times and time zones
  11. 11 Arrays and JSON
  12. 12 Writing data and transactions
  13. 13 Schema design, constraints and integrity
  14. 14 Query plans, indexes and optimisation
  15. 15 Views, stored logic and security
  16. 16 Applied analytics patterns
LAUNCH PRICE · UNTIL 31 JANUARY 2027

One payment.
Twenty-four months.

Prices in US dollars · ₹ and UPI in India. No auto-renewal. Full refund within 14 days, no questions asked.

Core SQL Everything you use in daily work and most interviews. 133 topics · 7,532 cards. $49₹1,199 $89 · ₹1,999 from 1 Feb 2027 Chapter 2 free Join the launch list
Advanced SQL Plans, indexes, recursion, JSON and applied analytics in depth. 68 topics · 3,541 cards. $49₹1,199 $89 · ₹1,999 from 1 Feb 2027 Chapter 7 free Join the launch list

Tax is calculated at checkout where it applies.

Questions

Before you decide.

Do I need to install anything?

No. PostgreSQL runs inside your browser tab. A laptop or desktop browser works best for writing queries.

Should I start with Core or Advanced?

Try both free chapters first. If Chapter 7 feels hard, start with Core; if Chapter 2 feels easy, Advanced is for you.

What happens after 24 months?

Nothing is charged. Your progress isn’t deleted, and you can buy another pass if you want to keep going.

Can I pay in rupees?

Yes. In India you see ₹ prices and can pay by UPI. Our payment partner handles checkout and invoices.

What if it isn’t right for me?

Ask for a full refund within 14 days of purchase. No questions asked.

Two chapters, free.
Start in your browser.

Open a free chapter now. No sign-in, no card.

terminal
$ engram start --course core --chapter 2 Core SQL: SELECT, filtering, sorting and paging · 10 topics $ engram start --course advanced --chapter 7 Advanced SQL: Window functions, in depth · 5 topics $