Discover how to create the Twitter DATABASE from scratch with MySQL in this stepbystep tutorial. Learn to structure tables, define relationships, and optimize queries to efficiently manage information on one of the most popular social networks. Dive into the fascinating world of data management!
This is a summary of a livestream that took place on Twitch.
Threads: https://www.threads.net/@midu.dev
Community Discord: / discord
Follow me on Twitch for more livestreams: / midudev
list=PLUofhDIg_38q4D0xNWp7FEHOTcZhjWJ29
Instagram: / midu.dev
Twitter: / midudev
TikTok: / midudev
Video timestamps:
0:00 Intro
1:11 Installing MySql on Windows
1:40 Installing MySql on MacOS
3:06 Let's get started
3:13 Explaining the MySql WB UI
5:15 Creating the Twitter Database
6:16 Keyboard shortcut
6:32 Using the Twitter Database
7:00 Users Table
12:09 Primary Key
14:20 Inserting Information into the Users Table
17:26 Comments in MySql
17:34 Inserting multiple data into Tables
18:52 Drop Database
20:51 Followers Table
25:29 Foreign Key
27:24 Inserting Information into the Followers Table
28:31 Applying constraints
31:16 Creating simple queries
33:55 Creating JOIN queries
36:32 Tweets Table
38:25 Inserting Information into the Tweets Table
39:16 Making block comments
41:28 How to make Subqueries
43:18 GROUP AND HAVING
46:55 DELETE queries
49:31 UPDATE queries
52:11 Twitter Likes Table
56:15 Obtaining the number of Likes for each Tweet
57:28 Triggers
#twitter #backend