Now, SQL, as you learned,
is actually just a language.
It's the Structured Query Language,
and it's a language that's being used
by relational database management systems.
And therefore we actually need to install
such a system. I will also just call
it SQL database system from now on,
on our system, on our computer. We need to
install such a SQL database system on our
computer because it will be that system that
then allows us to create tables and databases
that hold those tables in that system. Now,
when it comes to such systems, we've got various
options though, and they offered the
question which one do we want to use?
Well, if you Google for SQL databases or
SQL database systems, you'll find a lot of
results, a lot of options, but here are a couple
of the most popular and commonly used ones.
And that for example, would be MySQL,
PostgresSQL, MicrosoftSQL. And then as I said,
we have a bunch of others as well.
Now MySQL is probably the most
popular database system out there,
SQL database system I should say
though PostgresSQL is also super popular.
Now both these systems are actually open
source and free to use and very popular.
As I said, MicrosoftSQL is also very popular,
but requires a commercial license and is not free
to use. And for development and playing around,
you could use it for free, but if you want to
run it in production for a real website, you
would need to pay for it. For MySQL and Postgres
SQL, you can also use those for free,
for real websites, which are reachable by
visitors from all over the world.
And they offer it's these two database systems.
I want to focus on here and specifically
we are going to use MySQL in this course.
Now the features I show you the come-ons I
show you, the SQL language I will teach you that
generally is the same across all those databases.
There are differences, not all databases,
support all features. Some database systems
bring their own features, but generally,
it's the same idea. It's the same come-ons.
So what you'll learn in this course section,
and then discourse in general about SQL
and MySQL specifically will then also help you
if you decide to use PostgresSQL in the future,
therefore we just go with MySQL, the most popular
relational database system out there, and we're
going to install it and then set up our databases
in there and our tables in there. And so on.