Student Reviews
( 5 Of 5 )
1 review
Video of Database Design for Facebook: A Social Network Database Example in Database ERD Principles course by Database Star channel, video No. 10 free certified online
Get my Database Design Guides to many different sample databases: https://databasestar.mykajabi.com/lpkj-dbdesign/?videosougyTO_Wjw
Turn your idea into a real database: https://databasestar.mykajabi.com/edd/?videosougyTO_Wjw
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