SQL Cribsheets
SQL
DB4SQL
DB4SQL at AHS
Using DB4SQL & SQL
Creating a Database
Opening a Database
Creating a New Database
Creating a New Table
Primary & Foreign Keys
Validation Checks
DDL Code
Nat4
Editing Records
Sorting Records
Filtering Records
Nat5
SQL SELECT (search)
SQL INSERT
SQL UPDATE
SQL DELETE
Higher
Wildcards
Aliases
Aggregate Functions and GROUP BY
Adv.Higher
DROP Statement
CREATE Statement
HAVING Clause
Subqueries
Reference
Data Types
Conditions
Sample Databases
SQL
DB4SQL
DB4SQL at AHS
Using DB4SQL & SQL
Creating a Database
Opening a Database
Creating a New Database
Creating a New Table
Primary & Foreign Keys
Validation Checks
DDL Code
Nat4
Editing Records
Sorting Records
Filtering Records
Nat5
SQL SELECT (search)
SQL INSERT
SQL UPDATE
SQL DELETE
Higher
Wildcards
Aliases
Aggregate Functions and GROUP BY
Adv.Higher
DROP Statement
CREATE Statement
HAVING Clause
Subqueries
Reference
Data Types
Conditions
Sample Databases
Reference
Cookie policy
Privacy policy
