Years and Units

Year 7 Appshed

Year 7 SQL

Year 7/8 Games

Year 8 Appshed

Year 8 Modelling

Year 9 Modelling

Year 9 AI

Databases and SQL

Main Resources

• The Pepford Criminal Record Database
• Crime Sheet 1
• Crime Sheet 2
• Crime Sheet 3
• Crime Sheet 4
• Crime Sheet 5
• Crime Sheet 6
• Crime Sheet Checker (Excel)

Lesson 1 videos :

• Introduction to Databases and SQL
• The Pepford Criminal Database
• Writing Queries
• Solving Crimes

Lesson 2 Videos :

• Using ORDER BY

Year 8 Videos

• Cross Table Query 1
• Cross Table Query 2
• Cross Table Query 3