MySQL The Basics Learn SQL in 23 Easy Steps

YOUR LINK HERE:

http://youtube.com/watch?v=Cz3WcZLRaWc

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-sprin... • References • Diagram https://drawsql.app/fireship/diagrams... • Installer https://dev.mysql.com/downloads/insta... • 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/fires... • Android https://play.google.com/store/apps/de... • 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

#############################

New on site