Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Lynda - Up and Running with phpMyAdmin (Updated Feb 16, 2016)

Posted By: naag
Lynda - Up and Running with phpMyAdmin (Updated Feb 16, 2016)

Lynda - Up and Running with phpMyAdmin
MP4 | Video: AVC 1280x720 | Audio: AAC 48KHz 2ch | Duration: 5h 20m | 707 MB
Genre: eLearning | Language: 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.
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

Lynda - Up and Running with phpMyAdmin (Updated Feb 16, 2016)