2015
Lynda
David Powers
5:00
English
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 2015, this introductory course shows designers and developers how to set up phpMyAdmin 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.
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
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
Running queries from the console
7. Views and Stored Programs
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
Where next
Download File Size:628.67 MB
|
