SQL · Theory

ProcessList

Theory

328/439

ProcessList

Don’t start ProcessList with jargon. Start with Riya walking through ProcessList. That is the whole point.

ProcessList order: meaning → one ProcessList step Riya can write from memory → one limit. Dumping ten features helps nobody.

ProcessList exists so Riya can keep Riya walking through ProcessList correct in a small live site.

Riya ships ProcessList in a small live site. That is the use case worth saying.

If Riya walking through ProcessList breaks under ProcessList, check only reciting the name of ProcessList first.

ProcessList is not a lonely heading. Riya ties it to Riya walking through ProcessList.

One breath for ProcessList, then Riya walking through ProcessList, then only reciting the name of ProcessList. Sit down.

Exam tip

Board: Riya walking through ProcessList. Dry-run ProcessList. Name the trap: only reciting the name of ProcessList.

ProcessList — sample query

-- ProcessList
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

ProcessList: create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

DefProcessList — Riya uses it for Riya walking through ProcessList in a small live site.
RuleProcessList → one ProcessList step Riya can write from memory.
RememberProcessList + an index (a small live site).
UseProcessList in a small live site (Riya walking through ProcessList).
TrapProcessList — only reciting the name of ProcessList.
ExProcessList → Riya walking through ProcessList.

-- ProcessList CREATE TABLE demo ( id INTEGER PRIMARY KEY, label TEXT NOT NULL, qty INTEGER DEFAULT 0 ); INSERT INTO demo (id, label, qty) VALUES (1, 'alpha', 2), (2, 'beta', 5); SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

ProcessList

ProcessList — sample query

Short notes

Questions

ProcessList

ProcessList — sample query

Short notes

Questions