Introductory SQLpurlPURL: https://gxy.io/GTN:P00010
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.
|Introduction to SQL
|SQL Educational Game - Murder Mystery
Week 2: Advanced SQL
Today we introduce complex operations like Joins.
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.
|SQL with R
|SQL with Python
Week 4: Schema Design
In the Avans course an external tool was used when discussing Schema design.
This material is reviewed by our Editorial Board:Helena Rasche Bazante Sanders
This material was funded by:Gallantries Avans Hogeschool