Lesson 1 > Get Started
Welcome to the free MySQL lessons!
This is your working desktop. Before we begin, click here to take a quick tour.
Here you will learn some of the basics that will help you in your journey with MySQL.
Before we get our hands dirty with SQL commands, we need to go through some basic terminology.
We know it's boring, but hang in there.
MySQL is what we call a DBMS, Database Management System.
By its name you can figure out that a DBMS is a software that manages the creation, maintenance and use of a database.
So, what is a database?
As its name indicates, a database is an organised collection of data. In other words, related data that is stored together.
For example, a video club, a library, and a shop could use databases to store information about their rentals, sales, customers, stock etc.
But still, how is the data organized inside a database?
Tables are smaller collections of related data.
Let's take the video club example. We already have the database which is called videoclub.
Inside this database we must store a number of different data. We will use tables.
We will create a table for our members, for the movies, for the movie categories, for the rentals, for pricing etc.
Each table holds specific information.
Now, a table consists out of columns. Each column can hold a single piece of data.
For example, the members table of our videoclub database would have some of the following columns:
first name, last name, birth date, registration date, address, city, post code etc.
Hang in there, we are almost done.
Let's look at this from another point of view.
That was it. Now that you know what a database, table and a column is, you can click the BEGIN button to start with your free lessons!
Hello dear friend.
As it seems you have landed here from a search engine.
We challenge you to complete all our lessons. Make sure you are logged in order to save your progress.
Click the OK button to close this window.
Here you will read everything you need to know about the exercise. Instructions, explanations, examples etc.
Here you can see all the lessons
This is the code editor. Right here you will practice and enter your final solution before clicking the CHECK ANSWER button.
When you want to see the result of your code,
And here we have these four buttons.
Just press this button to get the translated text from our website.
The text is pre-translated, so it works without accessing Google's servers
Do not show this again
What do you think?
Tell us more about it.
What other people say