Database Design for Chat Application

 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-cheat-sheets/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign39
 Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign39
Designing a database for an application is a good way to learn and practice your database design skills.
In this video, we have a fictional “chat application”, similar to WhatsApp or Messenger. We have a few requirements and we want to design a database that could store the required information.
This video shows you how to design a database for this chat application from scratch, starting with the first table, adding more tables and fields, and making adjustments along the way.
It includes the concept of a many-to-many relationship, which I have a video about here:
So if you’re interested in a database design for a chat application, either as a project or just to learn, this video will be useful to you.
Timestamps:
00:00 Introduction
00:48 Requirements
02:16 Message table
03:14 Contact table
04:56 Group messages
05:34 Members joining groups
06:57 Refactoring the design
08:46 Enhancements and conclusion