Practical SQL for Beginners Using Adventureworks Database Part 3 || The CASE Command

SQL is one of the fastest-growing programming languages. It is widely used by Data Analyst, Data Scientist, Database Administrators, Backend Developers, etc.. As an aspiring Business Intelligence analyst and Data Analyst, you are often faced with data from different databases as against the conventional Excel files you learnt building visualization with. You will need to demonstrate a very good knowledge of SQL as business questions will be answered not just through the drag and drops Power BI environment but by demonstrating an understanding which addresses where the data required to answer this question resides in the database, how to retrieve it, what format must it be to be fit for the analysis, etc.. This is why you need to learn Structured Query Language. Business questions beget Queries. While writing SQL Commands to spool and analyze data, there are several instances where you will need to transform the output of the query from the raw form of the data e.g. binding age into category, renaming ‘M’ for Male, etc. In this video, I showed you how to do this binding and regrouping using the CASE command. Enjoy select Firstname, Lastname, Case persontype when 'IN' then 'Individual Custonmer' when 'EM' then 'Employee' when 'SP' then 'Sales Person' when 'SC' then 'Store Contact' when 'VC' then 'Vendor Contact' when 'GC' then 'General Contact' else 'Unknown Person Type' end TypeOfContact from person.Person Link to the SQL Playlist: https://studio.youtube.com/channel/UCKM0xzDyKUyJOJYGPUpmvlQ/playlists