MySQL is one of the most widely used database systems for
dynamic websites and content management systems. And
phpMyAdmin is the most common method of administering a
MySQL database, included in many CMSs as well as the XAMPP
and MAMP testing environments
Updated for 2015, this introductory course shows designers
and developers how to set up phpMyAdmin local user
accounts, create a database, and design tables. Author
David Powers also explains how to import data from CSV
files, spreadsheets, and SQL dump files, and how to export
data for backup or to transfer to another database. You'll
also learn how to run database queries within its intuitive
form-based interface, and monitor server performance

Topics include:

* Why use phpMyAdmin?

* Setting up a user account

* Creating a database

* Choosing the right column types for tables

* Inserting data manually

* Importing and exporting data

* Dealing with foreign keys

* Building and running queries

* Creating views

* Creating stored procedures and functions

* Checking performance