How to Design a Database for Instagram

Published: 14 June 2022
on channel: Database Star
39,171
1k

📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Turn your idea into a real database: https://databasestar.mykajabi.com/edd...

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...


Watch video How to Design a Database for Instagram online without registration, duration hours minute second in high quality. This video was added by user Database Star 14 June 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 39,17 once and liked it 1 thousand people.