Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Learn SQL language from scratch, the easy way, is designed to give a detailed introduction to using and understanding structured query language (SQL) for manipulating business data. This is the first part of a 2 parts course which covers the following topics:
For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out.
There are 2 sample databases provided with this course. SQLMain is used throughout the demonstrations. The second one is a Microsoft developed sample database that you can have fun with after you finish the course. Besides the video tutorials and sample databases, this course includes a 186 pages PDF book about SQL that I have written. Some of the concepts covered in the book will be demonstrated in this course leaving the remaining ones to be presented in part 2 of the course.
I myself started learning on my own with no mentor and no place where to get the exact information that I needed. This is one of the reasons this course is structured in such a way that you can start writing SQL code in hours with ease.
I recommend taking one lecture once every 2 or 3 days. This way you will have time to get used with the terminology and also have time to practice what you learned on your own. This course is not going to make you a SQL guru overnight. It takes practice and patience to get there.
Let's get started and learn SQL language together. The easy way.
Good to know:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
This lecture includes a presentation of all the video tutorials and chapters that will be covered in part 1 and part 2 of this course. You will also be able to download 2 sample databases. After installing Microsoft SQL Server make sure you restore the 2 sample DB. SQLMain is the main on used throughout this course.
|Section 2: Concepts and Overview|
As we are going to start from scratch, this lecture includes basic concepts about databases like what is a database, a table, a row, ANSI Standards, RDBMS Platforms and Relational Data
|Section 3: SELECT Basics|
In this lecture we are going to start querying data out of a database using the SELECT statement, filter and order data and also talk about some query toolset functionalities.
|Section 4: Filtering data|
In this lecture we are going to dive in the WHERE clause in a lot more detail. We will look at the IN and BETWEEN operators,the IS and IS NOT predicates, Boolean operators, how to properly delimit string and date data and a few other fun things.
|Section 5: Scalar Functions|
In this lecture we are going to talk about how to use functions within SQL queries. We will see the differences between scalar and non-scalar functions, deterministic and non-deterministic function. We will look at how to read the syntax in both MS SQL Server and MySQL. We'll also talk about how functions differ between platforms
|Section 6: Aggregate Functions|
In this lecture we are going to talk about aggregate functions which are different from the scalar functions that we talked about in the previous video.Specifically we are going to talk about SUM , MIN , MAX, AVG, COUNT and more.
|Section 7: Advanced Tricks|
In this lecture we are going to talk about the TOP keyword, (LIMIT/OFFSET in MySQL), we'll have a look at subqueries and how they work, column and table aliasing and we're also talk about the DISTINCT operator and casting and converting data.
|Section 8: Inserting updating and deleting data|
In this lecture we are going to talk about 3 of the basic DML queries that you will use in SQL. Insert data, update it and delete data from a database table.
|Section 9: Joining Multiple Tables|
In this lecture we are going to talk about multiple types of joins used to link multiple tables together and extract data from them.
I am a young but experienced and highly passionate BI Reporting Specialist and Database Developer,writer and founder of EasyWaySQL.
I also have a Bachelor's degree in Business Administration and a Master's degree in Economic Decision Support Systems.
Other than that I am dedicated to share my knowledge with others and learn new technologies on the way.