Links related to Game-Based-Learning for SQL

SQL Learning Games

• SQL Island
• Schemaverse
• SQL Detective
• SQL Murder Mystery
• Command Line Murder Mystery (für Linux Befehle, nicht SQL)
• SQL Police Department (kommerziell, aber freie Beispiele)
• Select Star SQL
• Johannes Schildgen, Jessica Rosin: Game-based Learning of SQL Injections. (DataEd'2022)
  [https://dl.acm.org/doi/10.1145/3531072.3535321]
• Using a Spaced-Repetition-Based Mobile Learning Game in Database Lectures (Florian Schimanke et.al., E-Learn 2015)

Spiel, das in SQL implementiert ist (Transact SQL)

• A SQL Game (Labyrinth)
• SQL Battleship

SQL Tutorials

• SQLZoo
• SQLTutor (Prof. Dr. Otto Rauh)
• Select Star SQL

Adventure Authoring Systems

• Quest
• Quest: Objekte
• TADS
• TADS: Documentation
• Twinery
• Inform7
• Inform (Wikipedia-Eintrag)
• Interactive Fiction Game Development
• Brass Lantern: TADS3 and Inform7
• IFWiki.org: Authoring Systems
• Z-Machine Matter: Programming IF
• So, Do we Need this Parser Thing Anyway? (Emily Short's Interactive Storytelling)
• Authoring Tools for Interactive Digital Narrative (Noam Knoller)
• Learning ZIL (Wayback Machine)
• The MDL Programming Language Primer
• The MDL Programming Language
• ADL: Adventure Definition Language
• Besprechung von AGT (Adventure Game Toolkit)

Adventure-Spiele, insbesondere Infocom

• Historical Sources (github)
• Historical Sources (github): Zork I (Infocom)
• Wikipedia: Adventure (1976) / Colossal Cave
• The Crowther and Woods 'Colossal Cave Adventure' game: Here's where it all began...
• Wikipedia: Infocom
• Infocom: The Master Storytellers
• The Infocom Gallery
• The Interactive Fiction Database: Zork
• IFWiki.org: Infocom
• IFWiki.org: Parser
• Infocom-Type Parser
• Zork Downloads
• The Infocom Files (github)
• The Infocom Documentation Project: Instruction Manuals
• The Infocom Documentation Project: Maps
• Wikipedia (deutsch): Z-Machine
• Wikipedia (englisch): Z-Machine
• Learning ZIL (Wayback Machine)
• The Z-Machine Standards Document (inform-fiction.org)
• The Z-Machine Standards Document (Wayback Machine)
• ZIP: Z-Language Interpreter Program
• Xzip Z-Machine Interpreter
• Andrew Plotkin: What is ZIL anyway?
• Jimmy Maher: ZIL and the Z-Machine
• Michael Ko: Internal Secrets of Infocom Games
• Making a Text Adventure Parser - Evan Wright
• Infocom: The Documentary (Jason Scott, Youtube)
• Let's Tell a Story Together (A History of Interactive Fiction) by Jimmy Maher
• You probably never heard of Professor Moriarty?
• Infocom: Zork 3 Manual
• Infocom: Zork 0 Manual
• ifwiki: Infocom-type parser

Weitere Informationen zu Adventure-Spielen

• Richard A. Bartle: Command Parsers: a Modest Proposal
• Past raif topics (Lange Liste von Diskussionsbeiträgen zu Adventurespielen
• The Craft of Adventure (aus dem Inform Manual)
• The Craft of Adventure: Five Articles on the Design of Adventure Games
• The Craft of Adventure: Five Articles on the Design of Adventure Games (Plain Text Version)

Role-Playing Games

• A Guide to the Mazes of Menace: Guidebook for NetHack
• NetHack Wiki: To-hit
• NetHack Wiki: Damage
• NetHack Wiki: Items
• NetHack Wiki: Waffen
• NetHack: Physical Damage Analysis
• NetHack Weapon Spoiler
• Learning Combat in Nethack (AAAI)
• Homework Java Program GameCharacter, Player, Monster
• RPG Maker
• Freier Nachbau von RPG Maker (EasyRPG)
• Quellcode eines freien Nachbaus von RPG Maker
• Open RPG Maker (Noch ein Nachbau von RPG Maker)
• How to build a Japanese-Style Role-Playing-Game (Dan Schuller)
• How to Make an RPG (Buch und Software, kostenpflichtig)
• Beschreibung zur Implementierung von Final Fantasy 7 (mit Kampf-Formeln)

Game Generators

• Forum für RPG Generators (Daten)
• Forum für RPG Generators: Procedural Challenge
• One-Page Dungeon by Watabou

Zufallsfunktionen, Perlin Noise

• Wilhelm Burger: Gradientenbasierte Rauschfunktion und Perlin Noise (2008)
• Stefan Gustavson: Simplex Noise Demystified

Elm

• Elm Narrative Engine
• Elm Narrative Engine: Package
• Guide to the Elm Language
• Elm Homepage
• Installing Elm on Linux
• Elm Dokumentations Generator
• Elm Dokumentations Format

Zufallsdaten

• Fantasy Name Generators: Hotel Names

Point-and-Click Games

• ScummVM
• Wikipedia: Game Engine
• Wikipedia: List of Game Engines
• Wikipedia: AGI (Adventure Game Interpreter), Sierra On-Line

Maze Generation

• Wikipedia: Maze Generation Algorithm
• Jamis Buck: Mazes
• Jamis Buck: Mazes for Programmers (Amazon)
• A Survey of Procedural Dungeon Generation (Breno M. F. Viana and Selan R. dos Santos, SBGames 2019)
• Jie Xu, Craig S. Kaplan: Image-guided maze construction (SIGGRAPH '07)

Literatur

• BTW-Artikel zu SQL Island
• Artikel im Datenbank-Spektrum zu SQL Island (Gib mir so viel Gold, wie die Metzger im Nachbardorf zusammen besitzen und ich lasse den Piloten frei!)
• Computerspiele als Lernmedium und ihr Einsatz in den Ingenieurwissenschaften (Frederic Adler, 2008)
• Interactive Storytelling: 11th International Conference, ICIDS 2018 (ab Seite 501 Authoring Systems)
• Contemporary Issues in Interactive Storytelling Authoring Systems (ICIDS 2018)
• A Framework for Classifying and Describing Authoring Tools for Interactive Digital Narrative (ICIDS 2018)
• How Do Writing ToolsShape Interactive Stories? (Sofia Kitromili, James Jordan and David E. Millard, ICIDS 2018)
• Didaktische Konzeption von Serious Games: Zur Verknüpfung von Spiel- und Lernangeboten (Michael Kerres, Mark Bormann und Marcel Vervenne)
• Gamification in Education: What, How, Why Bother? (Joey Lee, Jessica Hammer)
• A Practitioner’s Guide To Gamification Of Education (Wendy Hsin-Yuan Huang and Dilip Soman, 2013)
• Does Gamification Work? — A Literature Review of Empirical Studies on Gamification (Juho Hamari, Jonna Koivisto, Harri Sarsa, 2014)
• Games, Motivation, and Learning: A Research and Practice Model (Rosemary Garris, Robert Ahlers, James E Driskell, 2002)

Literatur (Neue Quellen von N.S.)

• Patrick Ward: Teaching of SQL through a Game (Master Thesis, SUNY, 2015)
• Game based learning for computer science education (Birgit Schmitz, Andre Czauderna, Roland Klemke, Marcus Specht)
• CodeAdventure: An Adventure Game for Computer Science Education (Panayiotis Andreou, George Nicou, Irene Polycarpou, Panagiotis Germanakos, Nearchos Paspallis)
• Motivation and computer game based learning (Nicola Whitton)
• Challenging games help students learn: An empirical study on engagement, flow and immersion in game-based learning (Juho Hamari, David J Shernoff, Elizabeth Rowe, Brianno Coller, Jodi Asbell-Clarke, Teon Edwards)
• A Game-based learning system for improving student's learning effectiveness in system analysis course (Ching-Hsue Cheng, Chung-Ho Su)
• Computerspielnutzung von Studierenden der Elektrotechnik: eine Befragungsstudie zur Erkundung der Akzeptanz von Computerspielen als Grundlage für ein Game-Based Learning-Konzept (Frederic Adler, Carolin Dehne)

Literatur (Game Based Learning):

• Elias John: Serious Game basierter Ansatz als Hilfe für Programmieranfänger (Preis für beste Abschlussarbeit)
• GI: Auszeichnung der besten studentischen Abschlussarbeiten im Bereich Bildungstechnologien

Literatur (Neue Quellen von Mario Wenzel)

• A Survey of Procedural Dungeon Generation (Breno M. F. Viana and Selan R. dos Santos, SBGames 2019)
• SBGAMES2019 Proceedings
• SBGAMES2018 Proceedings
• SBGAMES2017 Proceedings

Noch mehr Literatur

• Riemer Van Rozen: Languages of Games and Play: A Systematic Mapping Study (ACM Computing Surveys, Vol. 53, No. 6, December 2020, Article No.: 123)
• Rula Al-Azawi, Fatma Al-Faliti, Mazin Al-Bulshi: Educational Gamification Vs. Game Based Learning: Comparative Study (August 2016)

Pokemon

• Programmierung eines Pokemon Spiels mit Java und libgdx, Teil I (Youtube)
• Pokemon Battle Programming Project
• Pokemon Battle Recreation (Khan Academy)
• Gameplay of Pokemon (Wikipedia)

Servlets, Tomcat, Eclipse

• Java Servlet Technology (The Java EE 7 Tutorial)
• Java Servlet Technology (The Java EE 6 Tutorial)
• Installint Tomcat on CentOS (IONOS)
• Tomcat Documentation (Apache)
• Understanding Apache Tomcat (MuleSoft)
• Eclipse mit Tomcat (Torsten Horn)
• Eclipse mit Tomcat (MuleSoft)
• Eclipse mit Tomcat (Software Engineering, Uni Hannover)
• How do I share my code formatting settings with another user?

Maven

• Maven Homepage
• Maven Quick Reference
• Maven 3.5 (Torsten Horn)
• Maven Standard Directory Layout

Web Application Penetration Testing

• OWASP ZAP (Open Web Application Security Project, Zed Attack Proxy)

OAuth

• Wikipedia: OAuth
• OAuth 2.0
• OAuth 2.0 clients in Java programming

Editoren für Relationen

• Adminer Editor
• Convert ProstgreSQL DB Schema to JSON (Stack Overflow)