How to Design a Database for Instagram

 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-cheat-sheets/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign56
 Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign56
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.amazonaws.com/dbs/erd_instagram.png