Database Design for Facebook: A Social Network Database Example

 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-cheat-sheets/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign34
 Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign34
Are you interested in designing a database for a social network, like Facebook?
Facebook is a popular website and designing a database for a site like Facebook is a common exercise, whether you're in a database course at college or want to practice your skills.
In this video, you'll start with a series of basic features of the system, and one-by-one we'll create a database design, adding to the design at each step.
The final design will meet the requirements of the features we have identified.
You can then expand on the design, and of course modify it if you want different requirements.
A couple of links mentioned in this video:
- Falsehoods Programmers Believe About Names: https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/
- Image of final database design: https://dbshostedfiles.s3.us-west-2.amazonaws.com/dbs/database_design_fb.png
Timestamps:
00:00 Start
00:52 Features
01:39 Feature 1 - create profile
04:08 Feature 2 - add other profiles
05:41 Feature 3 - add posts
07:09 Feature 4 - see posts
07:31 Feature 5 - likes and comments on posts
08:49 Final design
09:51 Sample queries