JOIN me for a full beginner’s tutorial on MySQL. Learn the basics of relational databases by recreating AirBnb’s database with raw SQL

References

• Diagram https://drawsql.app/fireship/diagrams/airbnb-mysql-tutorial

• Installer https://dev.mysql.com/downloads/installer/

• MySQL Docs https://dev.mysql.com/doc/

• 00:00 0. SQL is King

• 00:49 1. The Legend of Ted Codd

• 01:24 2. ORM Magic

• 02:00 3. What is a RDBMS?

• 02:37 4. Draw SQL Diagrams

• 02:56 5. Schemas, Datatypes, & Constraints

• 04:12 6. Be Normalized

• 05:00 7. Install MySQL on Windows/Mac

• 05:50 8. Create a New Database

• 06:13 9. SQLTools VS Code Extension

• 06:46 10. --comments

• 07:02 11. Basic SQL Syntax

• 08:04 12. Primary Key

• 08:31 13. Varchar vs Text

• 09:31 14. INSERT New Data

• 10:28 15. Read or SELECT Data

• 10:57 16. LIMIT & ORDER

• 11:23 17. Filtering with WHERE

• 11:50 18. LIKE pattern matching

• 12:19 19. INDEX for read speed

• 12:56 20. JOIN a relationship

• 15:41 21. Alias AS

• 16:08 22. JOIN through a middle man

• 16:58 23. DROP a video

#mysql #database #sql