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.
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
Using Advisor to tune server performance