Sakila database demo

broken image
broken image

We're going to use the Sakila database in the MySQL server, but if you were to turn up one day and not be able to find the Sakila database in MySQL, you could change the current server to be Maria DB, and your queries ought to work exactly the same.

broken image

And you can see that the Sakila database is available in Maria DB. On the left here, are a list of all of the databases available. One says Maria DB, and the other one says MySQL, and I just want to show you something in Maria DB. If we look at the top left, where it says current server, underneath there's a dropdown.

broken image

It doesn't trip off the tongue, but it is an open source database software that you can actually download and use on any database that you like. This is the name of the software that we're going to use. In the top left, we have a logo for phpMyAdmin. So, here, is the demo that we are going to be using. This is a free resource to help people learn and use SQL. The reason I'm asking you to Google, instead of giving you a permanent link is because sometimes the link changes. You already know that we are going to use a demo database online, and to find that we can Google demo Sakila database in any order, and there it is.

broken image