Case Statements in MySQL | Intermediate MySQL

Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to take a look at Case Statements in MySQL!
GitHub Code: github.com/AlexTheAnalyst/MyS...
____________________________________________
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:
📖Google Data Analyst Certification: coursera.pxf.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
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

[@user-kq3tc5tu1c]

I use something like a CASE Statement in Excel's Power Query A LOT. Very powerful. Same idea as a CASE statement in MySQL (and probably MSSQLSVR, PostreSQL, etc.) Another "Thumbs Up" lesson in my opinion. Glad to have this treasure trove of knowledge to fall back on if I get stuck going down a MySQL rabbit hole (Read in your best "Elmer Fudd" voice - Got to love those rascally rabbits...😁)

[@collettecollettec]

omg, i'm working on a project of my own with the exact same table title. this is great timing!

[@collettecollettec]

This was so helpful, thanks!

[@Seftehandle]

Great vid, i would use the statement of finance id as first statement and then add the 2 consequtive when end

[@Seftehandle]

Loved it!

[@TobiDeolu]

Hi Alex, this is so interesting and pretty fascinating. I would like to ask, which do you think is pretty simple not to get confused with when writing the "New_Salary" equation? Is it writing the full equation as "Salary + (Salary * 0.05) for 5% increase or writing it as "Salary * 1.05"

[@alicdngwenya5081]

Hello Alex, your positive impact on lives is evident, and I've been following your journey. Your work is commendable. I'm eager to collaborate with you to make a difference in the lives of struggling youth who are losing hope due to unemployment, turning to substances. Together, we can bring positive change."

[@LibyaMicro]

Question: What distinguishes MySQL from Firebird, and does it have strengths over other databases?

[@rahulpattnaik4118]

Hey Alex, your MySQL lessons are fantastic! Could you please upload them a bit faster? I have an upcoming interview and I'd love to practice more before then. Thanks so much!

[@AlexTheAnalyst]

I post only one video per week because otherwise I would post way too much and have to constantly be creating more videos. I do have a full MySQL course and a platform to practice MySQL on AnalystBuilder.com - hope that helps!

[@AliAli-li4ys]

@@AlexTheAnalystCan you please provide a discount code? I would really appreciate it. Any suggestions/recommendations of what course to begin with (on your website) for a complete beginner. Thank You

[@ryanstef]

Hi Alex, thank you for these videos. How can i use the case statement as an input data? example: Case end as Salary_increase, salary + salary_increase as New_salary SQL is not recognizing salary_increase as a new column that i can use.

[@rahullshharma3800]

Where can I find this dataset?

[@MinatoJunior-hl8tb]

Hello can you do a video into how to download a csv file faster into mysql. I was able to prep the csv file and create table and the datatypes for it but i ran into the problem of error code 1265

[@user-zf3it3vw2e]

may I know how to download these tables?

[@marabunta1980]

Hello Alex, I have about 15 years of software engineering experience in java ecosystem. Been a hard-core programmer throughout my career. Lately been thinking of adding any worthy skill set to boost my career. Do you think something like a data analyst would be apt for me?

[@user-zf3it3vw2e]

thank you

[@megan_mackenzie]

Ron's age/birthday data isn't there 😂😂😂

[@AlexTheAnalyst]

The man is an enigma

[@AliAli-li4ys]

Alex can you please provide a discount code for your website? Can you also suggest/recommend what course should I begin with. Please respond 😇 I don’t mean to spam your comment section. Just hoping to grab your attention.

[@Pragya3421]

In case of finance, Isn't it the salary should be as per 5 or 7 % as per the bracket and Bonus should be 10%? Bcoz bonus is one time only.

[@DivisivelyIndivisible]

What do you think about rapidly increasing adoption of Databricks?

[@asgard5522]

On death's door lol

[@areebakhan1838]

I understand everything he studied us but can't practice because I don't have data

[@real__memes]

Poor Jerry man, he's not only old but doesn't get a raise as well. Feel bad for the bloke

[@fazrikurniawan9643]

on death's door