phpMyAdmin Fundamentals

phpMyAdmin is a free and open source tool for the administration of MySQL.
Course info
Rating
(71)
Level
Intermediate
Updated
Jun 20, 2014
Duration
1h 41m
Table of contents
phpMyAdmin Introduction
phpMyAdmin Installation and Configuration
Database Operations
Table Operations
Home Screen Settings
Summary and Resources
Description
Course info
Rating
(71)
Level
Intermediate
Updated
Jun 20, 2014
Duration
1h 41m
Description

phpMyAdmin is a free and open source tool written in PHP for the administration of MySQL via a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields, and rows as well as executing SQL statements or managing users and permissions. This course will guide you through maximizing the power of phpMyAdmin to get productive quickly with MySQL.

About the author
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
Monitoring MySQL with Performance Schema
Intermediate
1h 59m
28 Apr 2017
PostgreSQL: Advanced Server Programming
Intermediate
2h 14m
21 Mar 2016
More courses by Pinal Dave
Section Introduction Transcripts
Section Introduction Transcripts

phpMyAdmin Installation and Configuration
Hi, this is Pinal Dave, and welcome to the module of phpMyAdmin Installation and Configuration. Let's see what we are going to cover in this module. First, we'll discuss about various Prerequisite Software needed for phpMyAdmin and how to install them. Right after that, we will see where we can Download phpMyAdmin and how we can Install phpMyAdmin. Trust me, the Installation Process of phpMyAdmin is very simple. Once we install phpMyAdmin, I will show you a couple of tricks, how to configure phpMyAdmin without any warning or error. After successful installation of phpMyAdmin, we'll start with our journey to learn how we can connect to MySQL and use it efficiently.

Database Operations
Hi, this is Pinal Dave, and welcome to the module of Database Operations with phpMyAdmin. In this module, we are going to discuss various database operations, which we can do with the help of phpMyAdmin. It can be pretty boring and monotonous to learn about tools without context of the real world. Hence, I decided to talk about real-world scenarios and associate them with the features of phpMyAdmin. In this module, we are going to discuss various scenarios, which we often see in the industry. First, we'll talk about the need of reporting related to database and various softwares associated with phpMyAdmin. Right after that, we'll discuss variables and their usage, and after that we'll discuss about how we can monitor various activities of database with phpMyAdmin. Right after that, we'll discuss some of the crucial database operations and, after that, we'll talk about security and creating users. Finally, we'll talk about how to export and import Database. And we'll summarize all these concepts in the final clip of Summary.

Table Operations
Hi, this is Pinal Dave, and welcome to the module of Table Operations with phpMyAdmin. Let's see what we are going to cover in this module. In this module, we are going to discuss various table operations, which we are going to do with the help of phpMyAdmin. As you know from the previous module, we are discussing one story. This story has two characters, Rahul and Mike. In this module also, we'll continue the same story. We'll understand that a relationship, as well as focus on Rahul's aspiration to become a Senior Administrator from Junior Administrator, Mike will be giving various tasks to Rahul; for example, how to browse and edit tables, change data structure, Create, Read, Update, and Delete data, doing Advanced Search, maintaining table, Advanced Table Options, exporting and importing tables, and finally, how to track changes in any table. We'll walk through all the scenarios with the help of two characters. Finally, we will have a Summary, where we'll discuss if Rahul got the promotion or not. Let's start with Scenario Setup.

Home Screen Settings
Hi, this is Pinal Dave, and welcome to the module of Home Screen Settings with phpMyAdmin. So far, we have talked about Database and Table Operations with phpMyAdmin. However, we did not touch much on the settings of phpMyAdmin itself. In this module, we are going to discuss the same with the help of Scenario. Scenario is about two database administrators, which you are very familiar with from the previous module, Rahul and Mike. We will talk about how Home Screen Customization can help efficiency of the database user. Let's start with our scenario.