Trending

Wednesday, July 2, 2014

Up and Running with phpMyAdmin

Lynda – 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

No comments:

Post a Comment

About

Contact Form

Name

Email *

Message *

Copyright © 2013 TOTdownload.com
Designed By Blogger Templates