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!
____________________________________________
AFFILIATE LINKS:
Python for Data Analysis Book - https://amzn.to/3dDneGq
SQL Beginner's Guide to Managing and Analyzing With SQL Book - https://amzn.to/2X5341B
Best Laptop for Data Analysts - https://amzn.to/2WLfJGE
Best Laptop on a Budget - https://amzn.to/3cqWt7S
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________
Websites:
GitHub: https://github.com/AlexTheAnalyst
____________________________________________
*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*
Видео Intermediate SQL Tutorial | Case Statement | Use Cases канала Alex The Analyst
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!
____________________________________________
AFFILIATE LINKS:
Python for Data Analysis Book - https://amzn.to/3dDneGq
SQL Beginner's Guide to Managing and Analyzing With SQL Book - https://amzn.to/2X5341B
Best Laptop for Data Analysts - https://amzn.to/2WLfJGE
Best Laptop on a Budget - https://amzn.to/3cqWt7S
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________
Websites:
GitHub: https://github.com/AlexTheAnalyst
____________________________________________
*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*
Видео Intermediate SQL Tutorial | Case Statement | Use Cases канала Alex The Analyst
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases](https://i.ytimg.com/vi/9URM1_2S0ho/default.jpg)
![SQL Case Statements For Data Science Interviews in 2021](https://i.ytimg.com/vi/W_IERUwElkg/default.jpg)
![Intermediate SQL Tutorial | Unions | Union Operator](https://i.ytimg.com/vi/lYKkro6rKm0/default.jpg)
![Writing CASE WHEN Statements in SQL (IF/THEN)](https://i.ytimg.com/vi/mf_IFI3I7to/default.jpg)
![](https://i.ytimg.com/vi/0MwAeZckdoc/default.jpg)
![Intermediate SQL Tutorial | Updating/Deleting Data](https://i.ytimg.com/vi/bhnrIforc7s/default.jpg)
![SQL Tutorial - Additive CASE statements](https://i.ytimg.com/vi/hbLj8-ZfKYg/default.jpg)
![Intermediate SQL Tutorial | Aliasing](https://i.ytimg.com/vi/Dk7he_yEs4U/default.jpg)
![Why You Need to Stop Taking Courses (From an Ex-Course Addict)](https://i.ytimg.com/vi/aLp-6C-p-T0/default.jpg)
![SQL CASE Statement | Quick Tips Ep61](https://i.ytimg.com/vi/D376AdbKRIs/default.jpg)
![Data Analyst Expectations vs Reality](https://i.ytimg.com/vi/1xT68oeQTd0/default.jpg)
![SQL Window Functions on Data Science Interviews in 2021 | Asked By Airbnb, Netflix, Twitter, Uber](https://i.ytimg.com/vi/XBE09l-UYTE/default.jpg)
![Advanced SQL Tutorial | Temp Tables](https://i.ytimg.com/vi/RF0LE3hYFrI/default.jpg)
![Data Analyst Career Path | How to Become a Data Analyst + What to Do Next](https://i.ytimg.com/vi/5MZo2RoS8Yo/default.jpg)
![How to do Subqueries in SQL with Examples](https://i.ytimg.com/vi/GpC0XyiJPEo/default.jpg)
![SQL Tutorial - CASE Statements](https://i.ytimg.com/vi/ZANtieWGDWM/default.jpg)
![Data Scientist vs Data Analyst | Which Is Right For You?](https://i.ytimg.com/vi/fUpChfNN5Uo/default.jpg)
![SQL Stored Procedures - What They Are, Best Practices, Security, and More...](https://i.ytimg.com/vi/Sggdhot-MoM/default.jpg)
![SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial](https://i.ytimg.com/vi/Ww71knvhQ-s/default.jpg)
![SQL Tutorial: CASE WHEN with aggregate functions](https://i.ytimg.com/vi/ImiEKaEBvjE/default.jpg)