SQL · Theory

makedate()

Theory

235/439

makedate()

If you can teach makedate() using makedate on Sara's board, you know it. If you only know the heading, you don’t.

makedate() on the board: one makedate step Sara can write from memory. Then say what makedate on Sara's board looks like after.

makedate() exists so Sara can keep makedate on Sara's board correct in a viva board.

Use makedate() when makedate on Sara's board must stay clear. If a simpler SQL step works, use that instead.

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

makedate() is not a lonely heading. Sara ties it to makedate on Sara's board.

One breath for makedate(), then makedate on Sara's board, then only reciting the name of makedate. Sit down.

Exam tip

For makedate(): definition + a viva board + one failure.

makedate() — sample query

-- makedate()
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;

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

Short notes

Defmakedate() — Sara uses it for makedate on Sara's board in a viva board.
Rulemakedate() → one makedate step Sara can write from memory.
Remembermakedate() + the query planner (a viva board).
Usemakedate() in a viva board (makedate on Sara's board).
Trapmakedate() — only reciting the name of makedate.
Exmakedate() → makedate on Sara's board.

-- makedate() 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;

makedate()

makedate() — sample query

Short notes

Questions

makedate()

makedate() — sample query

Short notes

Questions