Learning phpMyAdmin

Course details

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.

Learning objectives
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

Concepts

0. Introduction

01 - Welcome
02 - What you need to follow this course
03 - Using the exercise files
04 - What's new in this version of the course

1. What phpMyAdmin Does

05 - Why use phpMyAdmin
06 - A quick tour of phpMyAdmin
07 - Limitations of phpMyAdmin in hosted environments

2. Setting Up phpMyAdmin Locally

08 - Setting the server connection collation
09 - Creating a database
10 - Setting up a user account
11 - Enabling advanced features on Windows
12 - Enabling advanced features on MAMP for OS X

3. Creating Tables

13 - Choosing the right column types
14 - Collation, character sets, and storage
15 - Defining a table
16 - Amending the table structure
17 - Inserting data manually
18 - Using the Browse tab
19 - Copying a column definition to another table with central columns

4. Importing and Exporting Data

20 - Importing data from Excel or a CSV file
21 - Importing data from an OpenDocument Spreadsheet
22 - Importing data from a SQL dump file
23 - Exporting a database the quick way
24 - Exporting multiple databases
25 - Creating a custom export for a single database
26 - Exporting partial data
27 - Enhanced export features in phpMyAdmin 4.5

5. Dealing with Foreign Keys

28 - Understanding foreign key constraints
29 - Converting the table engine
30 - Setting up a foreign key constraint
31 - Removing a foreign key constraint

6. Running Queries

32 - Performing a simple search
33 - Using query by example (QBE) to perform a simple search
34 - Finding and replacing text in a column
35 - Using QBE to set multiple conditions in a WHERE clause
36 - Joining multiple tables with QBE
37 - Building queries manually on a single table
38 - Building a query manually on multiple tables
39 - Saving frequently used queries with bookmarks
40 - Using a variable with a bookmarked query
41 - Using variables with bookmarks in phpMyAdmin 4.5
42 - Using named parameters in a query
43 - Running queries from the console
44 - New Console options in phpMyAdmin 4.5

7. Views and Stored Programs

45 - Syntax checker in phpMyAmin 4.5
46 - Creating a view
47 - Editing a view
48 - Creating a stored procedure
49 - Creating a stored function
50 - Creating a trigger
51 - Scheduling events

8. Checking Performance

52 - Profiling and explaining queries
53 - Analyzing table structure
54 - Normalizing a table
55 - Inspecting server performance
56 - Using Advisor to tune performance

Conclusion

57 - Other changes in phpMyAdmin 4.5
58 - Where next