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

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