SQL · Theory

LOG()()

Theory

202/439

LOG()()

Don’t start LOG()() (math) with jargon. Start with Riya walking through LOG math. That is the whole point.

Do LOG()() (math) once by hand. one LOG math step Riya can write from memory. Change one input. Say the new result out loud.

LOG()() (math) exists so Riya can keep Riya walking through LOG math correct in lab hour.

Riya ships LOG()() (math) in lab hour. That is the use case worth saying.

LOG()() (math) miss — only reciting the name of LOG math. Fix it before you talk about advanced SQL.

Place LOG()() (math) next to nearby SQL work — one LOG math step Riya can write from memory is the link.

One breath for LOG()() (math), then Riya walking through LOG math, then only reciting the name of LOG math. Sit down.

Exam tip

Board: Riya walking through LOG math. Dry-run LOG()() (math). Name the trap: only reciting the name of LOG math.

LOG()() — sample query

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

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

Short notes

DefLOG()() (math) — Riya uses it for Riya walking through LOG math in lab hour.
RuleLOG()() (math) → one LOG math step Riya can write from memory.
RememberLOG()() (math) + InnoDB (lab hour).
UseLOG()() (math) in lab hour (Riya walking through LOG math).
TrapLOG()() (math) — only reciting the name of LOG math.
ExLOG()() (math) → Riya walking through LOG math.

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

LOG()()

LOG()() — sample query

Short notes

Questions

LOG()()

LOG()() — sample query

Short notes

Questions