JOIN me for a full beginner’s tutorial on MySQL. Learn the basics of relational databases by recreating AirBnb’s database with raw SQL https://fireship.io/tags/sql/

Buy the MySQL Pillow https://fireshipio-swag.creator-spring.com/listing/mysql-pillow

References

Diagram https://drawsql.app/fireship/diagrams/airbnb-mysql-tutorial
Installer https://dev.mysql.com/downloads/installer/
MySQL Docs https://dev.mysql.com/doc/

#mysql #database #tutorial

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


Install the quiz app 🤓

iOS https://itunes.apple.com/us/app/fireship/id1462592372?mt=8
Android https://play.google.com/store/apps/details?id=io.fireship.quizapp

Upgrade to Fireship PRO at https://fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.

My VS Code Theme

- Atom One Dark
- vscode-icons
- Fira Code Font