Lego SQL

By Jarret Jeter

This project was made to show competence of using SQL to read and work with a database

Technologies Used

• SQL
• Docker
• Beekeeper Studio
• MariaDB

Description

The code begins with simple queries like selecting columns and finding substrings to narrow information, and then on to subqueries. Next is updating columns and also adding to them. I use aggregation on tables and filter then to find particular details. The last three blocks of code use different joins on table id's to find what they have in common.

Setup/Installation Requirements

• Clone this repository onto your machine.
• In your command line, run ./start_db.sh
• Open Beekeeper Studio and start a new connection(Connection type: MariaDB, Host: localhost, Port: 3306, User: root, Password: mysql) and connect
• Select lego from the left dropdown list
• Type in 'show tables' to check that you're connected to the lego database
• Now you can input the code I've written to see how it works

Known Bugs

Possible incorrect code here:

• UPDATE inventory_parts SET quantity = quantity * 2 WHERE quantity > 1;
• SELECT * FROM inventory_parts ORDER BY quantity LIMIT 20;

License

If you have any questions or concerns, please email me at jarretjeter@gmail.com

MIT Copyright (c) 04/23/2022 Jarret Jeter