Module Overview
This module focuses on database development with MySQL, which is the database system that powers WordPress. You'll learn database design principles, SQL queries, and how to integrate MySQL with PHP. By the end of this module, you'll be able to design and implement databases for web applications and understand how data is managed in WordPress.
Duration: 1 week (5 sessions of 3 hours each)
Prerequisites: Module 1 & 2: Web Development Fundamentals and PHP Fundamentals
Week 1: MySQL and Database Development
Session 1: Introduction to Databases
Session 2: Database Design
Session 3: SQL Fundamentals
- SQL syntax and conventions
- Data types in MySQL
- Creating and modifying database structures (CREATE, ALTER, DROP)
- Basic data manipulation (INSERT, UPDATE, DELETE)
- Simple queries with SELECT
- Filtering data with WHERE
- Sorting results with ORDER BY
- Homework: Write SQL queries to manipulate data in your database
Session 4: Advanced SQL
Session 5: PHP and MySQL Integration
Learning Resources
Required Materials
- VS Code or preferred code editor
- XAMPP or MAMP with MySQL
- GitHub account
Recommended Reading
- Learning MySQL by Hugh E. Williams & David Lane
- SQL Antipatterns by Bill Karwin
- Online resources: MySQL Documentation, W3Schools SQL Tutorial