e-learning

SQL Educational Game - Murder Mystery

View material

Abstract

This is not a tutorial like most GTN content but a fun exercise for you to play around and learn a bit about SQL in a more 'practical', and hopefully re-inforce the skills you covered in Basic and Advanced SQL skills. It makes use of the NUKnightLab/sql-mysteries SQL murder mystery project and released under open licenses:

About This Material

This is a Hands-on Tutorial from the GTN which is usable either for individual self-study, or as a teaching material in a classroom.

Questions this will address

  • Who did the crime?

Learning Objectives

  • Explore SQL City and discover who committed the murder
  • Reinforce your experiences with SQL such as querying, filtering, and joining data.

Licence: Creative Commons Attribution 4.0 International

Keywords: Foundations of Data Science, SQL, game, jupyter-notebook

Target audience: Students

Resource type: e-learning

Version: 6

Status: Active

Prerequisites:

  • Advanced SQL
  • Introduction to SQL

Learning objectives:

  • Explore SQL City and discover who committed the murder
  • Reinforce your experiences with SQL such as querying, filtering, and joining data.

Date modified: 2023-11-23

Date published: 2021-10-11

Authors: Helena Rasche, NU Knight Lab

Scientific topics: Software engineering

Activity log