hey everyone welcome to the session by Intellipaat in today's world where we
are surrounded by data handling and maintaining this amount of data as a
task well it's easier with a lot of database technologies around us by
making use of powerful languages like SQL and other flavors of SQL as well in
this video we're gonna have a quick comparison between SQL and MySQL and see
what it offers to us well before we begin with this session make sure to
subscribe to the Intellipaat YouTube channel and hit that Bell icon so that
you never miss an update from us here's the agenda for today we started by
taking a quick introduction to databases followed by this we're gonna check out
the basics of SQL as well and after this we can check out all the types of SQL
that are in existence and then we can quickly check out what MySQL is and
followed by this finally we can compare SQL versus MySQL head-on and guys after
this if you have any queries make sure to head down to the comment section
below and do let us know we'll be happy to help you out at the earliest and guys
in case you guys are interested in end-to-end Co certification in SQL
Intellipaat provides the SQL course certification training program where you
can learn all of these concepts thoroughly and on a certificate at the
same time well without further ado let's begin the class so coming to the first
point on the agenda it's a quick introduction to SQL well what is SQL
guys SQL is a standard language which is used for accessing and manipulating a
standard relational databases throughout the world
so we've heard of SQL you might or might not know what it stands for
well SQL stands for structured query language so the goal of language such as
SQL is very simple it basically provides the user with a very powerful yet simple
and efficient tool which can be used to work with and talk with the database
where you know or you're performing operations such as adding data on to the
database pulling out data or even modifying and
altering some data there so how SQL fits into the world of
databases or something like this so at one point of time data is actually
generated by various sources when you have to think about it our data coming
from social media it can be structured data or whatever it is so all of this
data it has to be put into a database it has
to be basically a processed through or the language of SQL so SQL is a very
simple language which is extremely powerful as I just mentioned to actually
go on to store data into your database and to work with it and what advantage
of SQL is that it is it stores data in a very structured way when you have to
talk about the DBMS where it works with by DBMS I mean the database management
system it's an RDBMS which is a relational database management system
which SQL caters to mostly and this ensures that your data is stored in a
structured way and at the end of the day it can be accessed very easily and
worked on effectively this again saves a lot of time delay it saves a lot of
space and ensures efficiency is at its high coming to a quick introduction to
MySQL MySQL is again one of the first open-source databases that the world had
to see and again as I mentioned it is an RDBMS system a relational database
management system which ensures that the data whatever data anyone is putting
into the database that it is very structured and very organized so MySQL
is one of these tools which is pretty much you know as a database which is
when used alongside our tools as PHP Apache web servers this creates a huge
dynamic package at the end of the day which is very very powerful you know
when you have to go on to data processing storing it or using it
alongside each other and then what of MySQL the meaning is very simple guys so
when you have to say MySQL it literally says MySQL or you can say it as my
sequel as well SQL can be called as sequel or SQL of course so this stands
for that and then you have to talk about a little bit more about MySQL you know
MySQL actually provides a very good feature which is basically multi-user
access so more than one user can have the access to the database at every
point of time and this ensures that you know more than one person can work on
the data and you know process the data alter the data whatever the requirement
this and this also uses SQL to query the databases guys so here's where one of
your first differences comes in MySQL is the database through which we actually
use SQL on to SQL runs on top of MySQL to basically query the databases and
work with it and MySQL database system you know it the consists of a wide range
of database technology so many technologies and supports and
all these technologies they cater to users with different requirements
because again there are there are many types of data in in today's world right
so to cater to what type of data is needed by what type of a database here's
where MySQL helps a lot and then MySQLactually named pretty much after
the co-founder so a daughter the co-founder of MySQL is Michael Venus and
this was basically named after his daughter and MySQL again as we have to
talk about it after stress about it is that it is one of the most popular
database software's out there today just a quick info guys in case you're
interested in an end-to-end course certification in SQL Intellipaat
provides the SQL certification course training program where you can learn all
of these concepts thoroughly and earn a certificate and the same the link is
given in the description box so make sure to check it out and on that note
let's get back to the session and here is a quick usage of MySQL everyone from
Airbnb uber Netflix Pinterest Dropbox Twitter LinkedIn every fortune 500
company out there pretty much makes use of a MySQL and more and coming to the
quick comparison between SQL and MySQL the first point we're gonna be
discussing is the meaning well so the meaning is pretty simple guys as I told
you SQL stands for structured query language and it is one of the most
amazing language is basically used to manage a relational database system and
what is MySQL MySQL is the relational database system which is basically used
alongside SQL to perform operations guys so any operations which are storing data
or retrieval of data or modification of data in the database and this brings us
to the second point which is basically complexity whenever you talk about
complexity you know SQL as a language it has to be learnt on it has to be worked
on and practiced to ensure that you can make the most efficient use of your
queries to work with your database then coming to MySQL you know MySQL is
basically a readily available software which as you know you can which you can
download it install it and begin working with it without much of a prerequisite
and then coming to point number three it is the type of
you said shoot that we have to talk about because SQL is a very fine
language it is a very well tuned language which is put together to work
with a database but MySQL is an entire database software an entire platform
which is basically making use of SQL to query the database case again when you
have to think about what to learn with again if you're using MySQL then
obviously learning SQL is a prerequisite but then if you're just learning SQL
then you might not have to work with a MySQL database because there are many
other forms of relational database management systems where you can go on
to use SQL as well coming to point number four point number four is the
purpose when you talk about purpose again SQL is the language it is used to
operate on the database while MySQL is the tool which allows SQL to perform
operations such as data handling data storage data modification deletion
operations and much more so I hope you guys are getting the general picture
here SQL is the language while MySQL is the data base on which SQL works with
guys coming to point number five point number five is the usage when you talk
about usage again there are various techniques which SQL uses you know there
are multiple code segments code snippets multiple commands and pretty much
everything else which you know is used to talk to various RDBMS systems and
in fact MySQL is one of them but then you have to talk about MySQL MySQL is
the RDBMS database pretty much which ensures languages such as SQL can
run on top of it but then if you're thinking how well does SQL run on MySQL
guys it is extremely efficient and even today SQL is a very old language and
MySQL is a pretty old open-source software too from it's our day of the
release pretty much all those years ago it's still there and I would not
consider calling SQL or any of the MySQL RDBMS's as legacy because as I told
you there are companies around the world fortune 500 companies who make use of
these every single day guys and then coming to point number six it's updates
because SQL is a fixed language right so no matter what there are multiple
flavors of SQL of course there's Oracle SQL there is some Microsoft SQL there's
multiple types of SQL which is basically like a flavor of it you can run or
pretty much if you learn or SQL right so I scale as a fixed language if you learn
it then pretty much you can all the code all the come
99% of the code segments of the syntax pretty much remains the same but then
when you have to talk about MySQL or the updates are more frequent here because
at the end of the day it's a software and it has to cater to various customer
bases but then even at the end of the day solving bugs are making your
software more efficient or helping you work with your database management
system in a more efficient way if that requires frequent updates then yes MySQL
provides that guys then coming to the quick summarization of this particular
difference SQL as I told you it has been a big player it has been a huge player
in the world of IT and it is very very vital when we have to talk about the
applications and its usage in applications guys and coming to MySQL
you know MySQL brings about a software which pretty much makes the best
possible way to store structured data into it on the database and eventually
to work with it later on by making the developers or the coders life a lot
easier guys and on that note you have reached the end of this quick comparison
between SQL and MySQL just a quick info guys in case you're interested in an end
to end code certification in SQL Intellipaat provides the SQL certification
course training program where you can learn all of these concepts thoroughly
and on a certificate and the same the link is given in the description box so
make sure to check it out I hope you guys took away a lot from this session
if you have any more points to add to this SQL versus MySQL video or if you
have any queries head to the comments section and do let us know and we'll be
happy to help you out and on that note have a nice day