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
Buy Premium to Support Me & Get Resumable & High Speed Download