SQL · Theory

Import Dump

← All stacks

Theory

427/439

Import Dump

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

For Import Dump, the query planner is in play. Don’t blame it until you have traced Import Dump on Sara's board.

Without Import Dump, a first job task gets messy and Import Dump on Sara's board is hard to trust.

Sara ships Import Dump in a first job task. That is the use case worth saying.

Import Dump trap — copy-pasting Import Dump without a dry-run. Sara loses marks for that every viva.

After Import Dump, Sara should still remember copy-pasting Import Dump without a dry-run.

Close Import Dump with: “If I skip it, Import Dump on Sara's board goes wrong like this: copy-pasting Import Dump without a dry-run.”

Exam tip

For Import Dump: definition + a first job task + one failure.

Import Dump — sample query

-- Import Dump
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;

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

Short notes

DefImport Dump — Sara uses it for Import Dump on Sara's board in a first job task.
RuleImport Dump → one Import Dump step Sara can write from memory.
RememberImport Dump + the query planner (a first job task).
UseImport Dump in a first job task (Import Dump on Sara's board).
TrapImport Dump — copy-pasting Import Dump without a dry-run.
ExImport Dump → Import Dump on Sara's board.

-- Import Dump 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;

Import Dump

Import Dump — sample query

Short notes

Questions

Import Dump

Import Dump — sample query

Short notes

Questions