SQL · Theory

Create Database

Theory

8/439

Create Database

If you can teach Create Database using Zara walking through Create Database, you know it. If you only know the heading, you don’t.

Do Create Database once by hand. one Create Database step Zara can write from memory. Change one input. Say the new result out loud.

Create Database exists so Zara can keep Zara walking through Create Database correct in a first job task.

Zara ships Create Database in a first job task. That is the use case worth saying.

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

Place Create Database next to nearby SQL work — one Create Database step Zara can write from memory is the link.

Close Create Database with: “If I skip it, Zara walking through Create Database goes wrong like this: only reciting the name of Create Database.”

Exam tip

Say Create Database in one breath, then one Create Database step Zara can write from memory, then only reciting the name of Create Database.

Create Database — sample query

-- Database admin (MySQL syntax; run on MySQL server)
-- CREATE DATABASE shop;
-- USE shop;
-- SHOW DATABASES;
SELECT 'Use CREATE/USE/SHOW on MySQL server' AS tip;

CREATE DATABASE makes a schema; USE selects it for following statements.

Short notes

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

SQL · Theory

Create Database

← All stacks

Theory

8/439

Create Database

If you can teach Create Database using Zara walking through Create Database, you know it. If you only know the heading, you don’t.

Do Create Database once by hand. one Create Database step Zara can write from memory. Change one input. Say the new result out loud.

Create Database exists so Zara can keep Zara walking through Create Database correct in a first job task.

Zara ships Create Database in a first job task. That is the use case worth saying.

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

Place Create Database next to nearby SQL work — one Create Database step Zara can write from memory is the link.

Close Create Database with: “If I skip it, Zara walking through Create Database goes wrong like this: only reciting the name of Create Database.”

Exam tip

Say Create Database in one breath, then one Create Database step Zara can write from memory, then only reciting the name of Create Database.

Create Database — sample query

-- Database admin (MySQL syntax; run on MySQL server)
-- CREATE DATABASE shop;
-- USE shop;
-- SHOW DATABASES;
SELECT 'Use CREATE/USE/SHOW on MySQL server' AS tip;

CREATE DATABASE makes a schema; USE selects it for following statements.

Short notes

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

Create Database

Create Database — sample query

Short notes

Questions

Create Database

Create Database — sample query

Short notes

Questions