Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
Welcome to Up and Running with phpMyAdmin. I'm David Powers, trainer and author of many books on php and web development. I've been using phpMyAdmin as the front end administration tool for MySQL databases for more than a dozen years. In this course, I'll show you how to use phpMyAdmin to create a database and design tables to store your data. I'll also give you advice on which data types to choose for individual columns.
Because it's web-based, phpMyAdmin is ideal for exporting your data and table structure as a backup, all ready for transfer to another server. Another useful feature is building database queries by example, through a form based interface. PHP MyAdmin automatically builds the SQL, which you can then copy and paste in to your own application. Most of the time, I'll be working with a local installation of phpMyAdmin. But you can use the one on your remote server if you prefer.
I don't intend to cover every single feature but by the end of the course, you should definitely be up and running with phpMyAdmin. And it'll probably cover everything you need to know about it.
There are currently no FAQs about Up and Running with phpMyAdmin.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.