If you’re curious how you would design a database to support an application like Trello, or want to design your own Kanban board-style application like Trello and need a database to go with it, then this is the video for you.
In this video, you will:
– see many different features of Trello
– starting from a blank diagram, create and update an Entity Relationship Diagram (ERD) to allow for the feature to be added
– repeat these steps will all features until we get to a final design
You can use this to see how to design a database, use it as a case study for certain techniques or scenarios, and even improve on it by adding your own features.
TIMESTAMPS:
00:00 – What we’re doing
01:00 – Sign up
02:33 – Create a board
04:04 – Add columns
04:58 – Add cards to a board
05:47 – Add comments to a card
07:19 – Checklists
08:17 – Add members (watch a card)
09:57 – Track activity
10:54 – Archive a card
11:34 – Labels
13:38 – Due date and reminder
14:34 – Attach files
VIDEO LINKS:
Final ERD: https://dbshostedfiles.s3.us-west-2.amazonaws.com/dbs/erd_trello.png
RESOURCES:
Get my free SQL Cheat Sheets for Oracle, SQL Server, MySQL, and Postgres here: https://www.databasestar.com/get-sql-cheat-sheets/
SQL Roadmap: an overview of SQL topics, which is a great place to start: https://www.databasestar.com/sql-roadmap/
Contact me here for questions, sponsorship requests, and more: https://www.databasestar.com/contact/
Want to take your database and SQL skills to the next level? Sign up for Database Star Academy, the online platform for database development and SQL. Check it out here: https://www.databasestar.com/dsa/
Take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments