How to Design a Database for Instagram

Instagram, the photo and video-based social network, is a good example to use as an exercise in database design.

In this video, you’ll learn how to design a database as though you were creating the next Instagram. We’ll look at a few features that Instagram has, understand what they do, and create a database diagram that shows the tables and fields that could be used. We’ll see how all of these tables relate to each other and adjust the design as we go.

If you want to learn more about database design and practice your skills, this is the video for you.

Timestamps:
00:00 What we’re doing
00:45 Users
01:14 Posts
02:17 Followers
03:04 Filters and effects
04:34 Location and caption
05:36 Tags
06:11 Comments and reactions
07:27 Stories
08:26 What else can we add?

ERD used in this video: https://dbshostedfiles.s3.us-west-2.a...

/// RESOURCES
📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🧭 SQL Roadmap from basics to advanced: https://www.databasestar.com/sql-road...
✍️ Learn how to design a database: https://databasestar.mykajabi.com/edd
📧 Contact me here: https://www.databasestar.com/contact/

📝 Database Design Exercises: https://bbrumm.gumroad.com/l/hqsxi
📝 SQL Practice Questions: https://bbrumm.gumroad.com/l/ulekqk
📝 SQL Performance Quick Guide: https://bbrumm.gumroad.com/l/fcvny
📝 Ultimate SQL How-To Guide: https://bbrumm.gumroad.com/l/oqggau