This project is my first SQL project meant to demonstrate the skills I learned from my independent learning throughout the last few weeks. I focused on learning the basics of SQL and decided the best way to demonstrate my knowledge would be to create my own database locally and insert my own data. From there I'd make some queries to manipulate the data to show what I know. The databases are linked to VSCode using a MySQL extension. I also included queries that say "Insert ALL" to insert all the information I have in my local database on your own system if you'd like to create your own.
https://dev.mysql.com/downloads/installer/
https://www.youtube.com/watch?v=wzdCpJY6Y4c&t=157s
-Needs one working database
-Can pull data with basic queries
-Can have users added and removed
-I plan to have at least 15 users
-Has queries ready to fill in local database with all the data listed in backups.
-Has queries ready to view data in different orders and clear tables.
-Has second table with query to join tables together based on ID.