SQL · Theory

Tools

← All stacks

Theory

388/439

Tools

Don’t start Tools with jargon. Start with Tools on Riya's board. That is the whole point.

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

Tools exists so Riya can keep Tools on Riya's board correct in lab hour.

Use Tools when Tools on Riya's board must stay clear. If a simpler SQL step works, use that instead.

If Tools on Riya's board breaks under Tools, check skipping the failure case for Tools first.

Tools is not a lonely heading. Riya ties it to Tools on Riya's board.

One breath for Tools, then Tools on Riya's board, then skipping the failure case for Tools. Sit down.

Exam tip

For Tools: definition + lab hour + one failure.

Tools — sample query

-- Tools
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;

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

Short notes

DefTools — Riya uses it for Tools on Riya's board in lab hour.
RuleTools → one Tools step Riya can write from memory.
RememberTools + the query planner (lab hour).
UseTools in lab hour (Tools on Riya's board).
TrapTools — skipping the failure case for Tools.
ExTools → Tools on Riya's board.

-- Tools 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;

Tools

Tools — sample query

Short notes

Questions

Tools

Tools — sample query

Short notes

Questions