Technology LearningCheat Sheet
DATABASECHEAT SHEETS
SHEET 03
Creating and Changing Data
M.R. Sterling
Database Intro · Sheet 03
Creating and Changing DataSQLite
Build a table, change its shape, then add, change and remove its rows. CREATE, ALTER and DROP, then INSERT, UPDATE and DELETE, the soft delete, and a transaction that undoes a mistake. Every step runs in order.
$4.50Get this sheet
Or get all 6 in the Database Cheat Sheets: Intro Pack for $19, or with the whole Health Database Clinic series in the Health Database Clinic - Complete + Cheat Sheets for $99.
Instant PDF downloadsent the moment you pay
Two A4 pagesprint front and back
SQLiteevery query runs as printed
Keep it foreverno expiry, no account
What the sheet looks like
A blurred preview, to show the layout and how much fits on the two pages. The full, print-sharp sheet comes with your download.
What is on this sheet
Shape or rows?
CREATE TABLE
SQLite's types
ALTER TABLE
Create twice, drop safely
INSERT
UPDATE
DELETE, or a soft delete
Transactions
The books this sheet pairs with
The sheet reminds you. These books teach it, one idea at a time, with every example worked.
More Database Intro sheets
One email when a new book lands
No schedule, no filler. Just the new titles and the odd free chapter.