Databases with MySQL

Store and find your data: tables, relations and SQL, then PHP talking to MySQL safely.

📚 4 modules 🎬 11 lessons ⏱ about 8 h 🎓 Certificate

What you will learn

✓Design tables and relations for a real business
✓Write SQL to find, add, change and total data
✓Connect PHP to MySQL safely with prepared statements
✓Keep money exact in the database

Course content

4 modules · 11 lessons

Module 1 Thinking in tables 3 lessons

📄What a database is
📄Installing MySQL and a database tool
📄Tables, columns and data types

Module 2 Writing SQL 4 lessons

📄SELECT, WHERE and ORDER BY
📄INSERT, UPDATE and DELETE
📄Joins: products, categories and sales
📄Totals with SUM, COUNT and GROUP BY

Module 3 PHP meets MySQL 3 lessons

📄Connecting with PDO
📄Prepared statements and SQL injection
📄Money in the database: DECIMAL, never float

Module 4 Project 1 lesson

📄A product and stock database for a mini-mart

About this course

Store and find your data: tables, relations and SQL, then PHP talking to MySQL safely. Part of the PHP & Laravel Masterclass from Kaydro Code Academy. Every lesson has a short video, the code and an exercise; the course ends with a project you keep for your portfolio, and a certificate.