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

#1: Easy to Learn
Compared to other web languages that require a bit of study, PHP does not require one to spend a lot of time researching a manual. Thanks to the syntax being logical and command functions describing exactly what they do, one can easily get right to the part of creating and optimizing the application. To build applications which is fast, reliable and easy to understand . PHP offers a great sense of responsibility which can help to build web applications.

#2: Familiarity with syntax
If you have programming experience in both Perl and C, then learning PHP will be quite easy, as its syntax is based on these languages.

#3: Free of Cost
PHP is an open source web app development language. It’s completely free of cost. It doesn’t get better than that, now does it?

#4: Efficiency in Performance
Depending on how you code, PHP can turn out to be an efficient web language to use. In fact, PHP is known to be scalable when writing code as well as in creating applications and is very reliable when you need to serve several web pages.

#5:Lots of PHP Support
PHP has a complete set of libraries which can be used as per requirements and builds upto a large scale applications. If you get stuck or are getting started when using PHP, one of the best places you can find information about the language is Hypertext Preprocessor apart from also obtaining tips from PHP pros from numerous websites and forums that are available over the internet.

Subject: 
Campus: 

Reviews

There are no reviews available... for now.

What do you think?

Do you have experience with this? write a review