CRUD

Code pattern Key terms bank Check

Jump to a topic

See every item in the sequence

Definition

Create, Read, Update, Delete: the four basic database operations (INSERT, SELECT, UPDATE, DELETE).

Example

UPDATE Student SET mark = 80 WHERE id = 3

Check this one: From the school notes, not named in the syllabus.

Found in: school notes.

Short version to memorise (key terms bank)

Create, Read, Update, Delete (INSERT, SELECT, UPDATE, DELETE).

Where you'll use it in the test

Syllabus area: Y12 Programming for the Web.

Question types it can appear in

Multiple choice: Pick the option that matches the definition or example.
SQL: Write or read it in the SQL query tool.
Fill in the blanks: Choose this term to complete a statement or table.

How to use it

A model sentence

General advice, built from the definition and example above

Code pattern: “Create, Read, Update, Delete: the four basic database operations (INSERT, SELECT, UPDATE, DELETE).” Then apply it: UPDATE Student SET mark = 80 WHERE id = 3

In a short answer, give the definition in your own words first, then tie it to the situation in the question. Do not copy the example above unless it fits the scenario.

Go deeper

Flashcard: CRUD in Programming for the Web (Year 12) · study that set
Memorise: SQL vs ORM
Key terms bank entry: CRUD
Notes: Web development system: front end, back end, databases (Programming for the Web (Year 12))
Notes: Model elements that form a web development system, including client-side (front-end) web… (Programming for the Web (Year 12))
Notes: Python with sqlite3 and parameterised queries (Python and SQL you must be able to write)
Full term page: every question, note and marking comment for CRUD

Check yourself

Write or say the “CRUD” pattern from memory: the syntax and what it does.

Reveal the answer

Create, Read, Update, Delete: the four basic database operations (INSERT, SELECT, UPDATE, DELETE).

Example: UPDATE Student SET mark = 80 WHERE id = 3

Could be tested as: Multiple choice, SQL, Fill in the blanks.

End of this topic. Next up: Year 12: Software Automation.