2013
Lynda
David Powers
2h 39m
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.
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.
Introduction 10m 36s
Welcome 1m 16s
What you should know before watching this course 1m 53s
Using the exercise files 56s
Configuring phpMyAdmin on MAMP for OS X 6m 31s
1. Why Use phpMyAdmin? 14m 9s
MySQL isn't a database, but a database management system 3m 42s
What phpMyAdmin does 5m 34s
Limitations of phpMyAdmin in hosted environments 4m 53s
2. Setting Up phpMyAdmin Locally 8m 19s
Creating a database 3m 35s
Setting up a user account 4m 44s
3. Creating Tables 29m 40s
Choosing the right column types 5m 51s
Defining a table 7m 0s
Amending the table structure 6m 43s
Inserting data manually 4m 9s
Updating and deleting data 5m 57s
4. Importing and Exporting Data 27m 38s
Importing data from a CSV file 6m 56s
Importing data from a .sql file 4m 8s
Exporting a database the quick way 4m 15s
Creating a custom export 7m 28s
Exporting partial data 4m 51s
5. Dealing with Foreign Keys 16m 57s
Understanding foreign key constraints 4m 5s
Converting from MyISAM to InnoDB 3m 0s
Setting up a foreign key constraint 7m 5s
Removing a foreign key constraint 2m 47s
6. Running Queries 43m 24s
Performing a simple search 8m 54s
Building a simple query by example on an individual table 4m 41s
Using a query by example to set multiple conditions in a WHERE clause 6m 48s
Building a query by example on multiple tables 3m 51s
Building queries manually on a single table 5m 2s
Building a query manually on multiple tables 3m 23s
Saving frequently used queries with bookmarks 4m 31s
Using a variable with a bookmarked query 6m 14s
7. Checking Performance 7m 36s
Inspecting server performance 5m 4s
Using Advisor to tune performance 2m 32s
Conclusion 1m 19s
Goodbye 1m 19s
www.lynda.com/phpMyAdmin-tutorials/Up-Running-phpMyAdmin/144202-2.html
Download File Size:296.49 MB
|
