MySQL - The Basics // Learn SQL in 23 Easy Steps

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 ... https://www.youtube.com/watch?v=Cz3WcZLRaWc