SQL Pivot and Unpivot | Quick Tips Ep57

In this video I show how to use the SQL Pivot and Unpivot. I will walk you through what it is, demonstrate how to use it on a small dataset, then demonstrate how you might use it in everyday programming.
SQL Pivot and Unpivot | Quick Tips Episode #57
TABLE OF CONTENTS
00:00 - Intro
00:57 - PIVOT and UNPIVOT example in Excel
02:34 - PIVOT in SQL
06:34 - SELECT INTO Example
07:03 - UNPIVOT in SQL
10:10 - Real World Example of UNPIVOT
13:26 - Phone Number Normalization
14:30 - SELECT INTO Example 2
15:12 - Drop Phone Columns
16:10 - Left Join Example
17:00 - PIVOT in SQL, advanced example
19:39 - Insert new PhoneType of Fax
UA-cam NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
ua-cam.com/users/subscription_c...
SUBSCRIBE TO OUR EMAIL LIST!
www.sqltrainingonline.com
LET'S CONNECT!
LinkedIn: / joeyblue
SQLTrainingOnline: www.sqltrainingonline.com

[@AtlasExit]

Joey Blue glad to see you are making videos again. Your previous videos were instrumental in helping me understand data analysis and databases when I was having a tough time getting it. Just wanted to say Thank You. Also you have one of the coolest names I've ever seen.

[@joeyblue1]

You're welcome! I'm glad the videos were helpful.

[@sunilanthony17]

I enjoy these sql tutorials of yours.

[@powellndlovu3591]

Great video please kindly send dataset

[@Dangerous_Trader]

Very good Explain

[@courtneybarker8935]

Hey Joey excellent video but where did you get the pivot syntax from?

[@danhle7999]

thank you for making this sir. But I think you should zoom in more for people with small screen and low resolution can see it easily