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