VCE Data Analytics U3O1: SQL queries and database design tools
Students learn to write SQL queries with SELECT, WHERE, ORDER BY and INNER JOIN, and to plan databases and spreadsheets with data dictionaries, IPO charts, query designs and layout diagrams.
One content description from the full VCE Data Analytics - U3O1 - Data Analytics journey. All 15 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (15)
1
SQL SELECT and FROM
2
SQL WHERE conditions
3
Boolean operators AND, OR and NOT in a WHERE clause
4
SQL ORDER BY
5
SQL JOIN across two tables
6
Exporting query results for use in a spreadsheet
7
Data dictionary
8
Writing a data dictionary entry
9
Input-process-output (IPO) chart
10
Writing an IPO chart for a spreadsheet or database task
11
Query design
12
Designing a query from a requirement
13
Mock-up of a spreadsheet layout
14
Annotated diagram of a database or spreadsheet
15
Interpreting a given design
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →