The purpose for this github repository is to provide people who would like to practice
with SQL to host a simple database with an .sql file backup called "employees" found from
a source that includes the following authors, with sample data from Aalborg university:
- Fusheng Wang and Carlo Zaniolo
The .sql file is loaded as a volume mount as the initial database for the docker entry point.
- install docker and docker-compose (if linux [tested on ubuntu]) or with docker on windows
- change directory to the root of this repo's directory after cloning
- concatenate the contents of split files in the db-dump folder into a file called "employees.sql"
a. cat db-dump/x* > db-dump/employees.sql - remove the x* files from db-dump
- run "docker-compose up" from the root of this directory (on ubuntu) or docker compose up on windows