04 SQL

Intro to SQL 

SQL on the Alevel Spec 

Defining and Updating Tables using SQL

SQL Zoo

Click here to complete some interactive SQL challenges

Lesson Activities 

Tracks DB

SQLite Python Example

Installing SQL

This lesson uses a program: 'Lesson 4 - SQL program.py'

Students only need to complete the SQL statement for the program to work.

The data the program uses is a SQL Lite 3 database, file: Lesson 4 - world.sqlite3

Both the program and the database should be stored in the same folder.

To view the database you can install SLQ Lite 3 browser. Installation files included.

Word and CSV versions are also included if installing SLQ Lite 3 browser is not an option.

SQL Handout

Cheet Sheets