Advanced SQL Tutorial

In this tutorial I will cover many advanced SQL concepts like full outer joins, coalesce, cross apply, outer apply, intersect, except and pivot.
NOTE: The database I use for this tutorial is MS SQL Server and the syntax can vary depending on the database.

[kamlist]

What a legen! His restaurants went bankrupt but now he teaches us SQL. Thank you Jamie Oliver

[zackjones]

Thanks for this. I finally have PIVOT working! I've converted two stored procedures so far and will be converting more now that I understand how it works.

[IanJohnstonblog]

Great Video. Thanks for making your series on SQL... I've learned a ton from your clear and concise explanations.

[jonnywright]

I find your vids real helpful as a full stack dev tweaking sprocs every now and then. Thanks for the content.

[shreyapansari]

Amazing ! finally could understand coalesce and pivot. Please make videos on stored procedures, CTE and materialised views.

[angelchavez]

Thank you! I was looking for the SQL equivalent of the || operator, and had read about coalesce before. Your video really made it "click" for me.

[Squeez]

>Thanks for watching

Thanks for creating

[andpiojo]

Great vid! Difficult topics explained in a very clear and easy way to understand! Thanks and keep them coming!

[preranadas]

Loved the video!!! thank you for making this amazing video.

[philippebalech]

Man you just rock thank you for sharing ❤

[MichalH-zp]

at the first query, isn't it the same as union all? instead of left join+coalesce? if not, when do you use which?

[nishantm]

how can you import csv file to an already existing table using sql query?
like suppose you have Customer table and now you want to add data from xyz.csv file and both Customer and csv file have same attribute, then how to do such task?

[sgpleasure]

SQL is supposed to be simple human readable. Always had issues with the Pivot, the fact that the Categories values had to be hard-coded in the code makes it static. There are solutions on the internet how to first read the list of categories values in a variable.

[darrylw]

It's rubbish that you have to hard code the columns for the pivot... can you not do a select Distinct to populate that?

[juandavidgomezrestrepo]

This is super useful stuff, thanks a lot mate

[palanit]

Thanks for the video. Can you please make a video on how Enterprise manager reports can be leveraged.

[AnshulMarele-gbaa]

How to enable viewing syntax and command definition [while typing any command] in MS-SQL as we see in Excel

[DARULULOOMKARACHI]

Hi, We may also use Isnull(s.ProductID, e.ProductID) ProductID instead of coalesce this gives also same output. plz verify.

[kshathrugan]

Cool, i have a doubt. Suppose i have a table with 3 columns say name, id, address and say 100 records. The table has some of the values in name, address filled with null or blank space. I Need to take report which shows me the count of records with blank spaces, null and this shud be achieved without using group by

[sgpleasure]

So what's the value in using OuterApply or CrossApply? Based on the demo, the result could be achieved with Table Joins. Anyway, I can Google for the answer. Was always curious when to use Cross Apply or Outer Apply, never knew the answer until this came up in a job interview.