Databases are extraordinarily powerful in managing sets of data, but what do we do when management wants to add/remove/modify something that code does? This lab is aimed at students with a moderate understanding of data engineering, and Python who want to understand how to update schemas to handle new features. We will walk through the changing requirements of a bug tracking application and how to handle them.

Learning Objectives

Upon completion of this lab you will be able to:

• Evolve MySQL tables to handle schema changes
• Learn how to update data models to meet changing requirements

Intended Audience

This lab is intended for:

• Data engineers
• Anyone needing to perform a schema migration on a relational database

Prerequisites

You should possess:

• A moderate understanding of Python
• A basic understanding of data engineering concepts

Updates

August 8th, 2024 - Added password protection to notebook