Learning phpMyAdmin

Learn to create databases, design tables, import and export data, and run queries with phpMyAdmin.

Introduction

• Welcome
• What you need to follow this course
• Using the exercise files
• What's new in this version of the course

1. What phpMyAdmin Does

• Why use phpMyAdmin?
• A quick tour of phpMyAdmin
• Limitations of phpMyAdmin in hosted environments

2. Setting Up phpMyAdmin Locally

• Setting the server connection collation
• Creating a database
• Setting up a user account
• Enabling advanced features on Windows
• Enabling advanced features on MAMP for OS X

3. Creating Tables

• Choosing the right column types
• Collation, character sets, and storage
• Defining a table
• Amending the table structure
• Inserting data manually
• Using the Browse tab
• Copying a column definition to another table with central columns

4. Importing and Exporting Data

• Importing data from Excel or a CSV file
• Importing data from an OpenDocument Spreadsheet
• Importing data from a SQL dump file
• Exporting a database the quick way
• Exporting multiple databases
• Creating a custom export for a single database
• Exporting partial data
• Enhanced export features in phpMyAdmin 4.5

5. Dealing with Foreign Keys

• Understanding foreign key constraints
• Converting the table engine
• Setting up a foreign key constraint
• Removing a foreign key constraint

6. Running Queries

• Performing a simple search
• Using query by example (QBE) to perform a simple search
• Finding and replacing text in a column
• Using QBE to set multiple conditions in a WHERE clause
• Joining multiple tables with QBE
• Building queries manually on a single table
• Building a query manually on multiple tables
• Saving frequently used queries with bookmarks
• Using a variable with a bookmarked query
• Using variables with bookmarks in phpMyAdmin 4.5
• Using named parameters in a query
• Running queries from the console
• New Console options in phpMyAdmin 4.5

7. Views and Stored Programs

• Syntax checker in phpMyAmin 4.5
• Creating a view
• Editing a view
• Creating a stored procedure
• Creating a stored function
• Creating a trigger
• Scheduling events

8. Checking Performance

• Profiling and explaining queries
• Analyzing table structure
• Normalizing a table
• Inspecting server performance
• Using Advisor to tune performance

Conclusion

• Other changes in phpMyAdmin 4.5
• Where next