Up and Running with phpMyAdmin-ELOHiM
Released: 2013-12-12 | Author: David Powers | Size: 409 MB
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
• Building queries
• Using Advisor to tune server performance
c. Play and Learn