Author
David Powers
Updated
2/18/2016Released
10/13/2015Updated 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.
- 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
Skill Level Beginner
Duration
Views
- [Voiceover] Welcome to Up and Running with phpMyAdmin. I'm David Powers. I've been using phpMyAdmin as the front-end administration tool for MySQL databases for more than 15 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.
I'll also show you how to build database queries, by example, through a form-based interface. phpMyAdmin automatically builds the SQL, which you can then copy and paste into your own application. This course has been completely updated since it was originally released in 2013, and it includes a new chapter on stored procedures and functions. There's a lot to cover, so let's get Up and Running with phpMyAdmin.
Q: This course was updated on 02/16/2016. What changed?
A: We added five new tutorials to cover changes in phpMyAdmin 4.5. This includes changes to variables with bookmarks and named query parameters, and features such as the new Console options and syntax checker.
-
Introduction
-
Welcome1m 7s
-
Using the exercise files2m 9s
-
-
1. What phpMyAdmin Does
-
Why use phpMyAdmin?3m 33s
-
A quick tour of phpMyAdmin7m 40s
-
-
2. Setting Up phpMyAdmin Locally
-
Creating a database3m 32s
-
Setting up a user account6m 45s
-
3. Creating Tables
-
Defining a table8m 19s
-
Amending the table structure5m 55s
-
Using the Browse tab7m 21s
-
4. Importing and Exporting Data
-
Exporting multiple databases6m 13s
-
Exporting partial data5m 47s
-
5. Dealing with Foreign Keys
-
Converting the table engine2m 51s
-
6. Running Queries
-
Performing a simple search8m 28s
-
-
7. Views and Stored Programs
-
Creating a view7m 17s
-
Editing a view2m 48s
-
Creating a stored function7m 54s
-
Creating a trigger7m 47s
-
Scheduling events7m 32s
-
8. Checking Performance
-
Analyzing table structure4m 29s
-
Normalizing a table9m 26s
-
Conclusion
-
Where next1m 43s
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome