One Pot Web Development

The basics

• Intro to relational databases
• SELECT queries in MySQL
• Examples of MySQL CRUD commands
• Using phpMyAdmin to administer a database
• Administering a MySQL database using phpMyAdmin

Sanitizing data

• Sanitizing user-generated content

Timestamps

• Making MySQL timestamp fields user-friendly

Pagination

• Pagination of results from MySQL queries using PHP

Search

• Search in MySQL

Debugging

• Debugging PHP and MySQL

Importing/Exporting databases

• Exporting and importing database tables