Year 11 Computer Science ATAR: Building and querying a database with SQL

1 What SQL is 2 SQL column data types and sizes 3 CREATE TABLE and INSERT INTO 4 FOREIGN KEY ... REFERENCES in CREATE TABLE 5 SQL constraints for validation 6 What data validation is and why it matters 7 Validation rules on database fields 8 Importing a CSV file into a database table 9 Running an SQL query in a database tool 10 SQL UPDATE and DELETE 11 SQL SELECT and FROM 12 Field order in the output of a SELECT 13 SQL WHERE conditions 14 WHERE on text, Boolean, character and date fields 15 Boolean operators AND, OR and NOT in a WHERE clause 16 Mixing AND and OR with brackets in a WHERE clause 17 BETWEEN and IN in a WHERE clause 18 SQL LIKE with the % wildcard 19 NULL values and IS NULL 20 SQL ORDER BY 21 How a field's data type changes sorting 22 Clause order in a full SQL query 23 SQL aggregate functions: COUNT, SUM, AVG, MIN, MAX 24 SUM and COUNT with a WHERE condition 25 SQL GROUP BY 26 Why a query over two tables needs a join 27 Writing the ON condition: foreign key equals primary key 28 Table-qualified field names in a join 29 Table aliases in a join 30 A join with WHERE and ORDER BY 31 Joining three tables 32 A join that forgets the ON condition 33 Answering a question with a multi-table query 34 Writing an SQL query from a requirement 35 Describing what a query does in plain English 36 Working out the output of an SQL statement 37 Common mistakes in SQL scripts 38 Completing an SQL script 39 Testing a query against the data 40 Exporting query results for use in a spreadsheet