▄▄▄ ▄▄▄
█████▄ ▄▄▄ ▄█████
▄▄▄▄ ▀█████ ▄▄█▓█████▄▄ █████ ▄▄▄ ▄▄▄▄
▄██████████▄████▓ █████████████ ████ ▄█████ ██████
███▓▀▀▀▀█████▓████ █████▀ ▀████▓ ▓███ ▄██▄ █████▓ ▓██████
░▓███▄ ▄████ ████ █████▓ ▓█████▓███ ████ ██████▄ ▄██████▓
████████████▀ ████ █████ █████████ ████▄██▄███████▄███▀████▓
▀███▄ ▄▄▄ ▄████▀ ▓████ █████████ ████████▓███ ▀██▓▀ ████
▀███▄████▄█████ ██████ ████▓█████▄▓████ ▀▀ ████ ▀ ████
▄████▄ ▀▀████████▓ ███████ ▓▓██▀███▀ ▀██████▄██▄ ███ ████
█████████ ▀█▓▀ █████▄▄ ░▓███████▄▄▄████▄██▓ ▀████████████ ████
██████████▄ ▄▄ ▀▀█████▄▄▓████▀███████▀▄███ ▄▄ ████████████ ▓▄▄▄▄ ████▓░
▓█████████████▓▓█▄▄ ▀▀▓▓█████▓░ ▀▀▀ ▄ ▀████▄ ▀██ ████████████ ████▀ ▄███▓
▀███▓▓▓█████████████▄▄▄ ▀▀███▀ ▄███████▄ ▀▀███▄ ▓ ███▓███▓████ ▓█▀ ▄███▀▀
▀▀▀ ▀▀▀▓▓███▄▄▄▄▄███████▀▀▀▀▓ ▀▀ ███▓ ▀▀ ████ ▀ ▀▓▓█▄▄
▀▀▀▀▀▀ ▀▀ ▀██▀ ▀▀▀▀▀
RELEASE NAME....: Lynda.com.Up.and.Running.with.phpMyAdmin.2015-ELOHiM
RELEASE DATE....: 2015-10-13
RELEASE SIZE....: 39x15Mb
FORMAT..........: Bookware
LANGUAGE........: English
URL.............: http://www.lynda.com
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.
Topics include:
* 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
Subjects: Developer, Web
Software: MySQL, PHP, phpMyAdmin
Author: David Powers
Level: Beginner
Duration: 5h 0m
Released: Oct 13, 2015