Up and Running with phpMyAdmin | 229 MB

duration : 2h 33m | Video: AVC (.mp4) 960x540 15fps | Audio: AAC 48KHz 1ch

Genre: eLearning | Level: Appropriate for all | Date : Dec 09, 2013

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