I Built a SQL Database for Oxford Independent Coffee Shops

Heya, in this video I will share the project I build as part of the Code First Girl Data & SQL kick-starter course. The name of the project is Oxford Independent Coffee (short: oxford_cafe). The idea is to create a database that includes all the independent coffee shops in oxford. The query let people find out which coffee shop provide Wi-Fi and plugs for charging, and allow visitors to work out how much they can save on coffee when they bring travel mugs themselves. For the owner of the coffee shops, they can use the created view to understand how coffee sales had been in the Oxford area.
Let me know if you think this will be a useful tool to continue and potentially build an app for it! Don't forget to like and subscribe :) Much appreciate the support.

MORE RESOURCES
GitHub repo for this project: https://github.com/WhySeeYC/oxford_cafe
Huge thanks to #CodeFirstGirl giving me all the guidance on learning MySQL: https://codefirstgirls.com/


GET IN TOUCH
Instagram: @whysee_yc1
LinkedIn:   / yi-chun-w  
Website: https://whyseeyc.github.io/
GitHub: https://github.com/WhySeeYC

MY TOOLS
Editing Software: ‪@Kapwing‬ [https://www.kapwing.com/]
Thumbnails: Figma