A Pet Shelter – Using MySQL

In this video I will show you how I used MySQL 8 to create a database for a demo per shelter.
These are the stages of my work:
1. Architecture
2. Inserted data
3. Made queries of varying complexity
This is meant to simulate a real-life situation when you’d have to build a database for a small business.
The features of MySQL 8.0 I used include primary key, foreign key, many-to-one, constraint, on update, on delete, datediff, create table, create schema, select, join, left join, count, and more.