Relational Data and MySQL Lesson
A movie-themed, hour-long lesson on MySQL and relational data for the Sparkbox Full Stack Apprenticeship.
The final lesson in the Sparkbox Full Stack Apprenticeship covered the basics of MySQL and relational data. By combining my interest in teaching database concepts with my love of film, I created a fun and practical hour-long lesson and practice database. In keeping with the movie theme established by the famous Sakila sample database, the custom lesson and its Universal Studios-themed database gave apprentices a hands-on way into relational data.
The lesson covered MySQL basics such as data normalization, joins, and primary, foreign, composite, and surrogate keys. It also taught apprentices to read entity relationship diagrams (ERDs) and write queries, stored procedures, and stored functions.
Jordan has a passion for contributing to his team outside of project work...Perhaps most impressively, Jordan led a significant portion of the Sparkbox fullstack apprenticeship several years in a row. Jordan maintained a healthy balance between these extra curriculars and project work resulting in happy clients and well-educated apprentices.