SQL Full Course for Beginners (30 Hours) – From Zero to Hero

Hello and welcome to this unique course to master SQL.

My name is Barra Zalkini and I lead big data projects at Mercedes-Benz over a decade of experience in SQL, data engineering, building data warehouses and data analytics.

Now, of course, the first question is what makes this course so special?

Well, not only you will learn how to write SQL codes, but more important than that, you will learn how exactly SQL works behind the scenes.

So I'm going to break complex concept in SQL using hundreds of animated visuals.

This makes it really easier to understand SQL and as well it is more fun than just sharing my screen and I just show you code right?

The second reason is this course is taught by me.

I have industrial experience and I will be sharing with you everything that I know about SQL and how I use it in my real projects.

So I will be sharing with you hundreds of best practices, tips and tricks and I'm gonna show you my decision making process in SQL.

So by the end of this course you will be ready to solve any complex task like I do using SQL.

So now I designed this course to cover the basics like

writing your first SQL query and then we're gonna keep progressing

in the course by covering advanced techniques in SQL like the window functions, stored procedures, indexes and even at the end we're gonna build a data warehouse using SQL.

And this course is suitable for anyone. Data engineers, data analysts, data scientists and even for students.

And by the way the good news everything is for free. From the start until the ends.

I will be sharing with you as well a lot of materials, code, presentations, and animations,

and there are no hidden costs, so you don't have to pay for anything. But my friends, in return, I really appreciate it if you support that channel in order to grow.

All right, my friends, I'm really excited about it. I don't know about you. If you are motivated, join me learning SQL. This is going to be amazing.

So let's go. All

right, now I'm going to show you the roadmap in order to learn everything about SQL,

starting from very basics and then advanced step by

step until we have very advanced topics so now at the

start we have to understand few stuff like what is sql why

to learn it what are databases and the types of

databases and after the theory we're gonna prepare your pc with

data and the softwares now once we have everything then we

can go to the next chapter this is the basics how to query data using sql and here we're gonna cover the basic components in each sql query like select from

where those basics now once you understand how to

query the data how to get the data out of the database the

next step we're gonna go and learn how to define the

structure of the database how to create a new table add

a new column remove column and as well how to drop

a table so with that you are defining new stuff in the database

and then the next chapter you have to learn about the data manipulation this time we're gonna go inside the table and we're gonna learn how to insert a new data, how to update the data and as well delete few rows from our database.

So with that you have the basics, how to query data, how to define the structure of your tables and how to manipulate your data.

And I can say with that you cover the basics about SQL.

Now after that we start with the intermediate phase where we're gonna deep dive into topics like how to filter your data.

Here we're gonna learn about the comparison operators, logical operators, between end like.

So all the operators that you can use in order to build a condition in

order to filter your data then after that it's going to be very

interesting topic you have to learn how to combine them and here we

have two mechanism either using the join or using

the set operators and oh my god joining data it's

going to be very interesting topic here we're going to cover like a lot of stuff

like we can start with the basic joins and then we go to

advanced and then you have to learn how to choose the right join

and after that you have to learn about the set operators and here you have like four methods union union all except intersects so that you

learn how to combine multiple tables by combining

the columns or the rows of your tables so this

is very important now moving on in our course now

using sql you can do a lot of stuff cleaning up the data a

lot of data preparations and at the end you can do a lot

of analytics and aggregations so they are like two families

of functions the first one is the row level functions and

here we have a lot of stuff you can transform your string values the numbers date and time and how to handle the nulls in SQL and at the end the amazing case statements.

So all those stuffs are transformation for only one single value. We call it row level functions.

And after you learn how to do data transformations, then you have to learn about how to do data analytics and aggregations using SQL functions.

So we're going to start with very basics like the aggregate functions and then we're going to deep dive into the window functions, analytical functions.

And here we have like aggregates, ranking and value functions.

Those are very important tool for any data analyst or data scientist doing analytics tasks in SQL.

So I can say the raw level functions is for data engineers and the analytical functions are for data analysts.

So at the chapter eight, we can say you have covered now the intermediate level and the last four chapters, they will be the advanced stuff in SQL.