In this course we will talk about Structured Query Language - SQL, in particular we will focus on Microsoft's version of it - T-SQL. The language to get data from relational database. We will go through all the parts of the query, we will learn what we can select, from which data we can do that, how can we filter the returned data, use aggregations and many-many other things.

If you want to enter the world of data this course is for you. If you want to learn how to get data from database to be able to present it or to work with this data in your app - this course is for you.

This course may surprise you by its simplicity and casualty, because this is how I believe things should be taught.

During the course you will have a lot of info, a lot of homework and final task where you will have to go through all the material we have covered.

The course consists of 8 sections:

1. The Story Begins Here - Introduction To The Course

2. Imagine You Have To Find a Book in a Library - where we talk about Select Clause

3. Which Bookshelves I Want to Select books FROM - where we learn how and what to use as our data source

4. I've Got My Books, But It's Too Much!!! - Filtering Query Results

5. Some Books Have Similar Info, Can We Put Them Together - Grouping Query Results

6. Thanks Sir, I've Got The Books I Need, What Can I Do With Them Now

7. Final Project

8. Bonus Section

By the end of the course you will be able to get any data you need from a database and have a solid base knowledge about SQL.