password : almutmiz.net

 
 
Lynda

[Lynda] Learning phpMyAdmin

password : almutmiz.net

   

Request course

طلب كورس

Written by Curss Curss

password : almutmiz.net

   

Request course

طلب كورس

Author

image of author David Powers David Powers

Updated

2/18/2016

Released

10/13/2015

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 phpMyAdmin 4.5, this introductory course shows designers and developers how to set up 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
Skill Level Beginner

5h 26m

Duration

223,661

Views
Show More Show Less
Size: 69.62M

 

Content retrieved from: https://www.lynda.com/MySQL-tutorials/Up-Running-phpMyAdmin/418255-2.html.

password : almutmiz.net

   

Leave a Comment

Facebook
Twitter
Google+0
Linkedin0
Total
0