
SQL Database Design and Querying
Tools Used: MySQL and GitHub.
Concepts explored: Database Modelling, Writing SQL Queries, Querying Databases, and Populating Databases.
Querying Databases
SQL Queries
Database Modelling
I created a data model to keep track of Techmoan's extensive retro electronics collection. The model records all the information about devices featured on Techmoan’s Youtube channel individually, but groups devices of the same or similar type into categories. Information like the device source(where it was purchased, or what sponsor it came from), their features, referenced documentation and any accessories that may have been purchased for a device are stored in their individual tables. The “DeviceModels” table in addition to other attributes also records the manufacturer of the item as well as the Country/Region a specific device model was made for, similar to the “AffiliateLinks” table. The model also includes a table to keep track of YouTube videos that may be associated with a device.
