Skip to main content
Database Management Beginner

phpMyAdmin Guide

A COMPLETE beginner-to-advanced phpMyAdmin course. Learn to manage MySQL databases visually, perform CRUD operations, enforce security, and execute disaster recovery protocols.

21 chapters 5h 15m 4.8 (182)
Start Learning

What you'll learn

  • What is phpMyAdmin? | Intro to MySQL Database Administration
  • How to Install phpMyAdmin | XAMPP & WAMP Localhost Setup
  • phpMyAdmin Dashboard Tour | Navigating the Interface
  • How to Create Databases & Tables in phpMyAdmin
  • How to Edit Table Structure in phpMyAdmin
  • How to Insert and Edit Data in phpMyAdmin | CRUD Operations
  • How to Run SQL Queries in phpMyAdmin | SQL Execution
  • How to Import and Export MySQL Databases | phpMyAdmin Migration

Course content

21 chapters Β· 5h 15m
  1. 1 What is phpMyAdmin? | Intro to MySQL Database Administration 15 min
  2. 2 How to Install phpMyAdmin | XAMPP & WAMP Localhost Setup 15 min
  3. 3 phpMyAdmin Dashboard Tour | Navigating the Interface 15 min
  4. 4 How to Create Databases & Tables in phpMyAdmin 15 min
  5. 5 How to Edit Table Structure in phpMyAdmin 15 min
  6. 6 How to Insert and Edit Data in phpMyAdmin | CRUD Operations 15 min
  7. 7 How to Run SQL Queries in phpMyAdmin | SQL Execution 15 min
  8. 8 How to Import and Export MySQL Databases | phpMyAdmin Migration 15 min
  9. 9 How to Manage Users and Privileges in phpMyAdmin 15 min
  10. 10 How to create Foreign Keys in phpMyAdmin | Relation View 15 min
  11. 11 How to Search and Filter Data in phpMyAdmin 15 min
  12. 12 How to Backup and Restore Databases | phpMyAdmin Recovery 15 min
  13. 13 How to Manage Large Databases in phpMyAdmin 15 min
  14. 14 How to Add Indexes in phpMyAdmin | Query Optimization 15 min
  15. 15 Secure phpMyAdmin | Password Protection & Security Best Practices 15 min
  16. 16 How to use phpMyAdmin on Shared Hosting | cPanel & Hostinger 15 min
  17. 17 How to Connect PHP to MySQL | mysqli & PDO Guide 15 min
  18. 18 Build a PHP MySQL CRUD Application | Step-by-Step Guide 15 min
  19. 19 Database Administrator Workflows | Real-World phpMyAdmin Tasks 15 min
  20. 20 phpMyAdmin Capstone Project | Build a Database System 15 min
  21. 21 phpMyAdmin Bonus Content | Shortcuts, Cheat Sheet & Interview Prep 15 min