Hey you beautiful tech-minded individuals today i have a question for you
deep question come a little closer do
you know how to spend your time right now what
are you doing looking at your computer staring into me
and i think you could be learning 2020's
most popular programming language the language to
learn this year but what language can that be
well by the end of this video i will tell you which language no matter what
position you're working in if you want to work with a computer if
you want to work in some sort of technical aspect
if you want to earn a little more money and show everybody
at your workplace that you mean business when it comes to data
i think i have the language for you
there's not going to be one perfect answer for what data
needs it's kind of like cooking baking a cake
you need a specific tool for each specific type of cake if you're a
madeline you need a madeline baking tin if you need a if you need a
bundt cake you need a bundt cake baking tin
every single coating language is slightly different so this one
is what i would suggest to the beginners to the people that have just started out
or perhaps are on their first or second language and
need to know where to go next let me explain to you what language i would say
are you ready for this drum roll please if you haven't subscribed yet make sure
you subscribe and here it comes sql
now i can hear you in the comments sql that's a language for data
sql isn't exactly the same kind of language
as a c plus plus a javascript a python so if you're not in a data related field
or if you're in a purely engineering field
do i really need that yes you do and here's why
if you're in any field that uses a computer if you're in a field that uses
excel if you're in a field that requires you
to build a spreadsheet that taps into some data source knowing sql
can be your key to getting that promotion that only
someone who can manipulate databases will be able to be qualified for
what i'm trying to say about sql is that it is a differentiator
between someone who is a consultant a business analyst
someone who is mostly working in excel and powerpoint
and it's starting to get tired of that and wants to earn
up to 40 to 50 more money immediately by moving into a more
technical analyst role or a data scientist role
right you want to up your game you want to become
the best you that you can be in the job market sql
is the language for you let's take a use case for example let's say that you are
the middle manager at a pizzeria and you are trying
to build a spreadsheet on how many pizzas you've sold in a specific time
by creating a sql lite database and then plugging that into your boss's humble
company website you'll suddenly be able to prove to him
hey i can make your company scale i can create different branches and
i think you need a branch manager that's just one crazy example
of how you can prove to someone that you're capable by using
your sql knowledge so many companies are moving to larger databases
to more complex systems to more scaled systems
and they need that special person which can be you
to take the challenge and make that extra cash
let's say for example you learn sequel and you are a manager
of a chain of restaurants person that is franchising out those restaurants
is finally ready to move into the cloud and you are the only person
that is able to find out what times for deliveries
is the most optimized for a specific geolocation
right you are the only person that knows how to take sql and then
use your knowledge to be able to grind data
out that a person with excel and powerpoint can't do
this is the language for you if you're sitting at home
if you don't like your job very much if you want to start
learning how to up your ante this is the way to do it so hold up if
you are an engineer in silicon valley and you have never
touched sql that's fine you don't need to
move into sql if you have been dealing with javascript or c
plus or some other language your entire life but
i'm talking to the everyman i'm talking to the person who wants to get into tech
but has no idea where to start and wants to take a somewhat ease
into the pool of large technology i think that sequel
is that easing into the pool it is just three main statements that gets you as
far as 99 into the career of sql
and you might call it sql i'm going to call it sql because
back in the 70s when sql was created it was
originally an abbreviation for structured english
query language sequel ultimately there was some sort of
lawsuit of a british aircraft company that did not like them sharing the name
so they shorten it to sql structured query
language and today it's sql or sql so why do i think that's the very best
language the sql is the most industry accepted way
to query into a database nowadays originally if you had a large
warehouse of files maybe something that you remember from
grade school elementary school a big filing cabinet with your permanent
record inside you would ask the principal
everybody with a certain number of detentions make sure that you
get them outside during recess and for whatever reason
they need their immunizations or something like that
that's one in a billion use cases that a sql
expert someone such as yourself could be i think that no matter what industry
you're in medicine food service management of any kind knowing sql will
be your key to unlocking a technical future in your
very near future and if a couple of my videos have tipped it off
sql preparation is one of the fundamental pieces of
data science preparation you need to be able to pass
a pretty technical interview with a bunch of sql questions
prepared to answer specific sql-based questions need to understand how to get
your way around a database and i would say that second
biggest reason why sql is such a great language to learn
is that it can be picked up in 24 hours 24 hours that's right one day you can
learn all of sql anything you need to know in one day and
that is a lofty statement but let me start you off
in the right path let me bring out this fancy whiteboard
and you see that we have our first table right here
it is the veggie tables table we have a couple of vegetable names and there's
score that's something that i like to call
you know their vegetable score so out of 10 how good is
beet how good is pea and how good is corn and over here we have another table
the avengers table and the avengers table you have their favorite
vegetable name and that is the magic of it all you see this is another
one out of a billion use cases for using sql
just by having these two tables you can start querying
how many avengers like corn or how many avengers have good taste
and vegetables and you can start dropping avengers that might not belong
in the table anymore if you reach the end of a certain
blockbuster movie you might have to drop one of these characters from the table
no spoilers but spoiler alert it's this one
is this spidey this this one gets dropped but you can insert him back
once you get to the end of another blockbuster movie
both of which feature the avengers so the main point
of sql is you just learned a really big portion of it you learned that sql looks
into different tables you can coordinate data between two tables that share
similar columns and you can aggregate and filter for
whatever you might need now this might sound like a very similar
tool that a lot of business people use excel and in essence it is like using an
excel spreadsheet or google sheets spreadsheet you are basically building
out the types of data structures that you
need but you're doing it in a scalable way
this is for humongous cloud-based databases where a lot of different
pieces of data now need you a sql specialist to query
now you have a competitive edge and this will give you
a gateway to more structured languages if you want to do more statistical
analysis you can move on to r if you want to do anything from
visualization at scale to building your own websites and having
your own databases plugged in now that you know sql you can build them in
python with a flask or django now this is your very first
step and within 24 hours you can build out an immeasurably
good skill if you agree or disagree about whether or not sql should be your
first programming language for anyone it doesn't matter what type
of career you want to go into front and design back in design you
are going to rock it if you learn how to write sql so let me know what you think
if you agree if you disagree if you haven't hit that like button
please i think it is time for you to gently caress it
so that people know that this is a video
that you prefer and you want to find out more about if
you want me to build out your 24 hour guide to sql i can consider
it let me know down below as well and if
you want to follow me on any of these social medias this one is for tweeting
this one is for instagramming and this one is for
the third type of social media i will see you again come on closer
peace
hey