SQL · Theory

SOUNDEX()()

Theory

166/439

SOUNDEX()()

SOUNDEX()() (str) sits in a first job task. Dev’s job is Dev walking through SOUNDEX str. Write that first.

SOUNDEX()() (str) on the board: one SOUNDEX str step Dev can write from memory. Then say what Dev walking through SOUNDEX str looks like after.

Skip SOUNDEX()() (str) and skipping the failure case for SOUNDEX str shows up in a first job task.

Dev ships SOUNDEX()() (str) in a first job task. That is the use case worth saying.

Don’t do this with SOUNDEX()() (str) — skipping the failure case for SOUNDEX str. Interviewers spot it in ten seconds.

SOUNDEX()() (str) is not a lonely heading. Dev ties it to Dev walking through SOUNDEX str.

One breath for SOUNDEX()() (str), then Dev walking through SOUNDEX str, then skipping the failure case for SOUNDEX str. Sit down.

Exam tip

Say SOUNDEX()() (str) in one breath, then one SOUNDEX str step Dev can write from memory, then skipping the failure case for SOUNDEX str.

SOUNDEX()() — sample query

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

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

Short notes

DefSOUNDEX()() (str) — Dev uses it for Dev walking through SOUNDEX str in a first job task.
RuleSOUNDEX()() (str) → one SOUNDEX str step Dev can write from memory.
RememberSOUNDEX()() (str) + the query planner (a first job task).
UseSOUNDEX()() (str) in a first job task (Dev walking through SOUNDEX str).
TrapSOUNDEX()() (str) — skipping the failure case for SOUNDEX str.
ExSOUNDEX()() (str) → Dev walking through SOUNDEX str.

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

SOUNDEX()()

SOUNDEX()() — sample query

Short notes

Questions

SOUNDEX()()

SOUNDEX()() — sample query

Short notes

Questions