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.

This introductory course will show designers and developers how to create a database, design tables, and insert, update, and delete data either on a local computer or a remote server. Plus, you'll learn how to use phpMyAdmin to export data to a text file that can be used as a backup or to transfer the data to another server. You'll also learn how to run database queries within its intuitive form-based interface, and monitor server performance.
Topics include:

What is phpMyAdmin?
Setting up a user account
Choosing the right column types for tables
Inserting data manually
Updating and deleting data
Importing and exporting data
Dealing with foreign keys
Building queries
Using Advisor to tune server performance

Download File Size:396.95 MB

---