From the course: Intermediate SQL: Data Reporting and Analysis

Get familiar with phpMyAdmin - SQL Tutorial

From the course: Intermediate SQL: Data Reporting and Analysis

Start my 1-month free trial Buy for my team

Get familiar with phpMyAdmin

“

- [Instructor] Let's get ready to code in SQL by getting familiar with phpMyAdmin, an open source database software with a very long name. phpMyAdmin is particularly well suited for creating databases to power websites, and it's the software used by the Sakila demo database, which we're going to use in this course. phpMyAdmin uses MySQL, we will also cover Oracle SQL, Microsoft's Transact-SQL, and PostgreSQL, but we cannot run these commands in phpMyAdmin because they won't work. I'll point out where commands differ between these main types of SQL. We're going to be using the phpMyAdmin demo site called Sakila. Now normally we would be using the MySQL demo site, and you can see in the top left, I just changed the server between MySQL and MariaDB. These two things are largely equivalent, I'll come onto that in a second. So to access the Sakila database, if you look down the left hand side of your screen, you can see on the left hand side below all that, it says Sakila. Now as you follow this course, you are going to find that this environment is extremely unstable, anybody can delete anything globally within this setup, so occasionally you're going to come along here and the Sakila database simply won't be present, and you'll see me struggling with the same thing in the course. Now when this happens, the first thing to try is to come over to the top left and change server, so switch between MariaDB and MySQL. If we scroll down, you can see there's a Sakila database under MariaDB as well. Your commands should work pretty much identically. MariaDB was set up by the same guy who invented MySQL. MySQL was created by Finn, Michael Widenius, which I've probably mispronounced and apologies for that. It was named after his elder daughter My. After MySQL was acquired by Sun and then Oracle, Michael Widenius developed Maria DB, named after his younger daughter, and deliberately made it compatible with MySQL. I always think we should shout out these modern day heroes, so there's my tribute to him. Okay, back to phpMyAdmin. Across the top, you can see that there are tabs, it says databases, SQL, status, et cetera. These are contexts dependent, meaning that some of them will disappear, depending where you are in the database. We're currently sitting at the very top, server route level, and I can tell that by looking at this screen because in the very top of the screen, there is a breadcrumb bar, and at the moment it just says server phpMyAdmin demo MariaDB, and as we go down into the Sakila database, for example you can see the breadcrumb bar has expanded and those tabs have renamed, different ones have popped up, so now they say structure, SQL, search, query, et cetera. We're going to be using the Sakila database, so let's take a look now at what data it contains.

Contents