SQL · Theory

Create User

Theory

93/439

Create User

Asha only reaches for Create User when Asha walking through Create User has to stay correct in a first job task.

Create User on the board: one Create User step Asha can write from memory. Then say what Asha walking through Create User looks like after.

Create User exists so Asha can keep Asha walking through Create User correct in a first job task.

Create User shows up in a first job task. Name Asha walking through Create User, not “a real-world scenario”.

Create User miss — only reciting the name of Create User. Fix it before you talk about advanced SQL.

After Create User, Asha should still remember only reciting the name of Create User.

One breath for Create User, then Asha walking through Create User, then only reciting the name of Create User. Sit down.

Exam tip

Board: Asha walking through Create User. Dry-run Create User. Name the trap: only reciting the name of Create User.

Create User — sample query

-- Create User
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;

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

Short notes

DefCreate User — Asha uses it for Asha walking through Create User in a first job task.
RuleCreate User → one Create User step Asha can write from memory.
RememberCreate User + an index (a first job task).
UseCreate User in a first job task (Asha walking through Create User).
TrapCreate User — only reciting the name of Create User.
ExCreate User → Asha walking through Create User.

-- Create User 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;

Create User

Create User — sample query

Short notes

Questions

Create User

Create User — sample query

Short notes

Questions