Learning 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.

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 when you just use command line?
  • Setting up a user account
  • Creating a database in the phpMyAdmin console
  • Getting the type right: Choosing the right column types for tables
  • Inserting data manually
  • Importing and exporting data from MySQL dump files, text files, CSV files and other types of files
  • Dealing with foreign keys and foreign key constraints
  • Building and running queries
  • Creating views
  • Creating stored procedures and functions
  • Checking performance

Did you know...?

PHP is the father of the web development. It is actually developed for the web desingers initially who are little bit away from programming. However for now it is one of the greatest language to develop a web app.

If you learn it these pros will be wating for you:

  • its server side setup is really easy to deploy your application.
  • there are lots of free hosting that only support PHP applications so it makes your work easier while you are in prototype period of your application.
  • It has great community and you can find the answer for all your problems and questions.
  • If you a hacker PHP is the most basic language you need to know.
  • It supports Prodecural coding with plain PHP also it supports Object oriented paradigm with PHP4 and PHP5.
  • There are good PHP frameworks that are available for all different purposes. For example Wordpress, Dupal are CMS solutions also Symfony, CakePHP ... are the other frameworks supports MVC pattern
Subject: 
Campus: 

Reviews

There are no reviews available... for now.

What do you think?

Do you have experience with this? write a review