Database engineers earn good money for a reason. Databases are complicated. Thankfully the knowledge a Web developer needs is a bit less. These pages may still make you cry! What is here is very simplified but should be enough for you to then start the beginners' MySQL tutorial pages and create useful pages.
Hover over the links for a brief description.
- What is a database?
- Database fields and their attributes
- Database primary keys
- Database relationships
- Database integrity
- Entity relationship diagrams
- Normalisation
- Database indexes
- Local and server databases
- PHPMyAdmin
- Using PHPMyAdmin to connect to a MySQL server
- Using PHPMyAdmin to create users
- Using PHPMyAdmin to create databases
- Using PHPMyAdmin to create tables
- Using PHPMyAdmin to enter data
- Using PHPMyAdmin to create relationships
- Using PHPMyAdmin to backup MySQL data
- Using PHPMyAdmin to import data
