Introductory SQL
purlPURL: https://gxy.io/GTN:P00010Comment: What is a Learning Pathway?
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:
Helena Rasche
Bazante Sanders
Funding
These individuals or organisations provided funding support for the development of this resource
