This repo includes a sample database from MySQL's website known as sakila as well as a script that makes queries to the database. The queries I made are in quries.sql.
This script has 8 parts, each of which composes of about 1 to 8 querries each. The goal of this script is to showcase some of the queries that can be made in MySQL. The database sakila can be downloaded directly from MYSQL's website: https://dev.mysql.com/doc/sakila/en/sakila-installation.html
- Basic Querries
- Filtering
- Basic DDL Commands
- Groupbys and More DDL
- Creating tables
- Joins
- Sub Queries
- Views