SQL · Theory

Exercises

← All stacks

Theory

412/439

Exercises

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

For Exercises, an index is in play. Don’t blame it until you have traced Exercises on Riya's board.

Skip Exercises and only reciting the name of Exercises shows up in a campus project.

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

Don’t do this with Exercises — only reciting the name of Exercises. Interviewers spot it in ten seconds.

Place Exercises next to nearby SQL work — one Exercises step Riya can write from memory is the link.

Close Exercises with: “If I skip it, Exercises on Riya's board goes wrong like this: only reciting the name of Exercises.”

Exam tip

For Exercises: definition + a campus project + one failure.

Exercises — sample query

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

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

Short notes

DefExercises — Riya uses it for Exercises on Riya's board in a campus project.
RuleExercises → one Exercises step Riya can write from memory.
RememberExercises + an index (a campus project).
UseExercises in a campus project (Exercises on Riya's board).
TrapExercises — only reciting the name of Exercises.
ExExercises → Exercises on Riya's board.

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

Exercises

Exercises — sample query

Short notes

Questions

Exercises

Exercises — sample query

Short notes

Questions