Intermediate SQL Tutorial | Case Statement | Use Cases

In today's Intermediate SQL lesson we walk through Case Statements.

All Topics Covered: Joins, Unions, Case Statements, Updating/Deleting Data, Partition By, Data Types, Aliasing, Views, Having Clause, GetDate(), Primary vs Foreign Key

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

Resources:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

Websites:

____________________________________________

*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*

[AlexTheAnalyst]

Time Stamps:
Definition: 0:06
Syntax of Case Statements: 0:25
Use Case: 4:15

[tempura_edward]

I like how you said everyone got a raise while HR’s salary raise is like nothing 😂 😂
Thank you for the great video 👍👍

[youvegotmail]

I love Alex's low-key shade on HR. Love it!

[edmondnathan]

You are a great teacher Alex. Your ability to break down complex topics and make them look easy is second to none. By the way, what a raise that was for the HR department🤣

[ankurperiwal]

I have been using SQL for over 3 years but have learnt or used this in my role - Thanks for your teachings :)

[jrg]

Your beginner SQL videos have highly contributed to my beginner
training in SQL management studio. Thanks, Alex!!

[anuragdas]

I was really struggling with my self-study and you came in as a savior... thanks mate! and also I can tell that you really hate Toby and love Dwight :D

[goon]

You're really good at explaining logical statements in SQL and Excel

[estherakpanowo]

I can't believe i waited so long to finally watch your video on this topic. I have been battling with this for days now...and yeah 'm a beginner. Great work👍

[Slizzer]

these videos are getting better and better and more helpful the more you progress. thanks Alex!!!

[pavodecampo]

Thank you so much for this!! It really helps learning that way, because it is enjoyable and pleasant at the same time, step by step! Excellent job!! ❤

[remidee]

This is the best platform i've learnt SQL, so simple and yet highly educative with very relatable use cases. Thank you Alex!!!

[achmadhendy]

I just wanna say thank you Alex! Your tutorial videos are really helpful. God bless you man 😇🙏

[alimurtaza]

Much appreciated!
You are doing an amazing job by simplifying all of it making it easily understandable and memorable.

[Richinator]

Truth must be told... Just started my career path in Data Analytics and following your boot camp till now has been easily educative.. Thank you😊

[kyleburko]

Such a good video - thank you for being super clear and concise and fun. A true joy!

[moatheshtaiwi]

Please continue this series, it is very wonderful, and I hope you explain the function of date ❤️

[patrickchukwu]

Very helpful. you made the case function a whole lot easy. thank you. loving this transition.

[micahlawrence]

Appreciate having the Use Cases in the videos. Helpful to know some ways you use these operators in the job.

[lisaamante]

Las Vegas, Nevada, USA: As usual, very clear, concise, quick, relevant, easy to understand! Thanks so much, Alex. As an aside, tell us how you really feel about HR, Alex! ;-)