Youtube Model Database

Frontend + Database Dev

School - Introduction to Relational Databases | Sep 2021 - Dec 2021
Project Overview
A CRUD App focused on managing the complex entity relationships within the Youtube platform. Users can perform queries with our database via a multi-page web interface. Built with PHP, Oracle (DBMS), and SQL by 3 developers, users can view and interact with viewer, content creator, and video data.
What I Learned: 
💡 How to create ER diagrams and define relationships between entities
‍
💡 Setting up database schema & defining data types
‍
💡 Connecting user input to SQL queries, and intuitively displaying the data requested  
‍
💡 How to query and aggregate data in valuable ways
Users can apply a search filter for Videos and Content Creators based on their attributes. They can also select which attributes they want to see.

Let me know if you want to know more!