Learning phpMyAdmin

Sale!

Safe Payment

Secure payment via Credit Card, Don't keep any cards information.

Secure Download

All download sources is secure & reliable through Google Drive.

Lifetime Access

All softwares and products gets unlimited access & lifetime use.

If you are going to buy up from 5+ products through our website you can asking for 30% OFF Coupon code.

Categories PHP & MySQL, Videos Tags David Powers, PHP & MySQL Videos

Learning phpMyAdmin (Up And Running with PHPMyAdmin)

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.

Updated for phpMyAdmin 4.5, this introductory course shows designers and developers how to set up local user accounts, create a database, and design tables. Author David Powers also explains how to import data from CSV files, spreadsheets, and SQL dump files, and how to export data for backup or to transfer to another database. You’ll also learn how to run database queries within its intuitive form-based interface, and monitor server performance.

Video Demo Here :

Topics include:

Why use phpMyAdmin?
Setting up a user account
Creating a database
Choosing the right column types for tables
Inserting data manually
Importing and exporting data
Dealing with foreign keys
Building and running queries
Creating views
Creating stored procedures and functions
Checking performance

About the Author

David Powers has been developing websites since 1994 and writing books on web development since 2003.

He is an Adobe Community Professional and Adobe Certified Instructor for Dreamweaver. You’ll often find him giving help and advice in the Dreamweaver forums and the Adobe Developer Center, to which he has contributed many popular tutorials and training videos. He also greatly enjoys traveling and taking photos.