Up and Running with phpMyAdmin

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.

Topics include:

• What is phpMyAdmin?
• Setting up a user account
• Choosing the right column types for tables
• Inserting data manually
• Updating and deleting data
• Importing and exporting data
• Dealing with foreign keys
• Building queries
• Using Advisor to tune server performance

Table of content

• Introduction
  • Welcome
  • What you should know before watching this course
  • Using the exercise files
•  Why Use phpMyAdmin?
  • MySQL isn’t a database, but a database management system
  • What phpMyAdmin does
  • Limitations of phpMyAdmin in hosted environments
•  Setting Up phpMyAdmin Locally
  • Creating a database
  • Setting up a user account
•  Creating Tables
  • Choosing the right column types
  • Defining a table
  • Amending the table structure
  • Inserting data manually
  • Updating and deleting data
• Importing and Exporting Data
  • Importing data from a CSV file
  • Importing data from a .sql file
  • Exporting a database the quick way
  • Creating a custom export
  • Exporting partial data
• Dealing with Foreign Keys
  • Understanding foreign key constraints
  • Converting from MyISAM to InnoDB
  • Setting up a foreign key constraint
  • Removing a foreign key constraint
• Running Queries
  • Performing a simple search
  • Building a simple query by example on an individual table
  • Using a query by example to set multiple conditions in a WHERE clause
  • Building a query by example on multiple tables
  • 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
• Checking Performance
  • Inspecting server performance
  • Using Advisor to tune performance
• Conclusion
  • Goodbye

Uploaded.net 

1. http://ul.to/oo63bkpm

Rapidgator.net

1. bit.ly/TDz8pW