Introductory SQL

purlPURL: https://gxy.io/GTN:P00010
Comment: What is a Learning Pathway?
A graphic depicting a winding path from a start symbol to a trophy, with tutorials along the way
We recommend you follow the tutorials in the order presented on this page. They have been selected to fit together and build up your knowledge step by step. If a lesson has both slides and a tutorial, we recommend you start with the slides, then proceed with the tutorial.

This is an introductory course of SQL, as it was taught in Avans Hogeschool in the Netherlands.

This learning path covers all the topics usually taught during our 4 week SQL course.

Week 1: SQL Basics

The lesson is to be followed in class, and the game given as homework.

Lesson Slides Hands-on Recordings
Introduction to SQL
SQL Educational Game - Murder Mystery

Week 2: Advanced SQL

Today we introduce complex operations like Joins.

Lesson Slides Hands-on Recordings
Advanced SQL

Week 3: SQL in other languages

Based on which language you’re teaching alongside SQL, you can choose one of the following lessons which have the same content for different programming languages.

Lesson Slides Hands-on Recordings
SQL with R
SQL with Python

Week 4: Schema Design

In the Avans course an external tool was used when discussing Schema design.


Editorial Board

This material is reviewed by our Editorial Board:

orcid logoHelena Rasche avatar Helena RascheBazante Sanders avatar Bazante Sanders

Funding

These individuals or organisations provided funding support for the development of this resource