SQL SET Operators: UNION, UNION ALL, EXCEPT (MINUS), INTERSECT | #SQL Course 11

☕ *Stay Connected*

📚 *Free Courses*

🎓 *If You Need Certifications*

📖 *Table of Content*
00:00 Intro
00:27 What are SET Operators?
03:31 SET: Syntax
04:16 SET: #1 Rule
05:21 SET: #2 Rule
06:56 SET: #3 Rule
08:50 SET: #4 Rule
10:37 SET: #5 Rule
12:43 SET: #6 Rule
15:31 UNION
20:56 UNION ALL
24:51 EXCEPT
30:09 INTERSECT
32:46 Use Case: Combine Information
42:29 Use Case: Delta Detection
44:29 Use Case: Data completeness Check
46:24 Summary

#sql #sqlserver #data #analytics
*Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[xFlaSh]

While watching your videos i am always wondering how content of this quality is available for free on the internet, glad I found it. Thanks for the work you doing.

[ndifsmurida]

Thank you for your diligent devotion to simplifying SQL for the world. You are truly appreciated. Your videos are the gold standard. I have never seen anything this good anywhere.

[SahilGupta-sw]

I'm blessed that i found this channel for learning Advance Sql for data analysis free of cost

[omarisawesome]

I am grateful that I discovered this free resource for learning advanced SQL for data analysis.

[SAhmBal]

Having a teacher like Baraa makes being a data analyst much easier. Thank you

[MALIK_AR]

never seen a better teacher than him. I don't have words to appreciate this guy how smooth his way of teaching is and how he makes things easier. May Allah bless you baraa

[yacineissolah]

Exactly what I was Looking for, well Detailed and Explained, Thank you !

[shubh_pokharkar]

completed the whole advance sql in 4 days thankyou barra and grateful, learning sql seems easy now

[MuzaffarOchilov-yj]

Really appreciate your work, thank you so much !!!
Your courses are in high level !!! Every point is clearly and completely explained, easy and simple to understand and this is because of talent, sure.
Thank you,

All the best !!!

[gsalema]

One more step toward my goal, I feel blessed to have found this channel, what a good method of explaining a lesson.

[egit]

الف الف شكر لحضرتك مستر بارا.. الله يبارك في حضرتك وفي مجهودك إللي بجد مشفتش حد زي حضرتك يعطي كل ما لديه من معلومات وخبرات ولا تنتظر مقابل... إللي زي حضرتك قليل ومن قلبي متشكر جدا مره أخري لمجهودك.

[jaydeep]

you know baraa every body is thanking you for the quality of content you are sharing, of course it will happen, but I'm surprised that you even added steam coming out from the coffee cup, ☕☕, but thank you, thanks a lot for educating us GURU JI,

[SahilLodhi]

Completely Understood every single thing, I mean how could I not when The best teacher is teaching me. Hoping to Case Statements now. Thank You So Much Baraa, I'm so Grateful to you❤

[Toyahan]

I watch your tutorials every day and I watch each video 2-3 times to let it stick before moving on. Thank you for your efforts

[schanduriable]

Fabulous teaching skill in synchronized order. Enjoyed the Video. Thank you

[shubhamsinha]

Amazing content, it's hard to believe that content of this level is free.

[WasefKamal]

Today, I saw the real and useful application of set operations studied in grade 6 MATHS.

[sedzidickson]

Hello boss, I can say you are the best tutor I have come across on this platform. You are a natural. Thanks for the sacrifice

[AkramHussain-pz]

Appreciate the work behind good Editing work for explaining theough Visuals

[aymaneagharbi]

Here We Go Again !!! Another Amazing Video.. Thanks For Your Effort Sir