peter-patocka/sql-workshop

Several introductory SQL lectures based on e-commerce-db MySQL schema. The whole bundle starts along with phpmyadmin in Docker container.

SQL workshop

All lectures are based on e-commerce-db database schema for e-commerce (webstores) sites

Diagram

Html info

ecommerce-db.html

Start MYSQL

To start MYSQL database server in docker container, use:

./run.sh up

If you do not have a permission to execute file run chmod +x run.sh.

All ./db/updates/*.sql files are applied to initial database dbname (defined by environment variable MYSQL_DATABASE).

To edit data, use phpmyadmin with user name username and password password.

Stop MYSQL

To destroy all running docker containers use:

./run.sh down

Lectures

1. Introduction to MYSQL
2. Entity–relationship model
3. Database normalization
4. JOINs
5. Triggers, Views, Procedures

---

Other topics (not covered yet):

• Database Testing
• NoSQL Databases
• Database servers differences
  • PostgreSQL vs. MySQL
  • Oracle vs. PostgreSQL
  • Comparison MySQL vs. Oracle vs. PostgreSQL
• Database Modeling in UML
• Database Migration - What It Is and How to Do It

Copyright and License Information

See the LICENSE for information on the history of this software, terms & conditions for usage, and a DISCLAIMER OF ALL WARRANTIES.