SQL Pivot and Unpivot | Quick Tips Ep57

Published: 02 March 2021
on channel: Joey Blue

11,750

170

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

YOUTUBE NEWS UPDATES
/ sqltrainingonline

VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
http://www.sqltrainingonline.com

SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
http://www.youtube.com/subscription_c...

SUBSCRIBE TO OUR EMAIL LIST!
http://www.sqltrainingonline.com

LET'S CONNECT!
LinkedIn: / joeyblue
SQLTrainingOnline: http://www.sqltrainingonline.com

Watch video SQL Pivot and Unpivot | Quick Tips Ep57 online without registration, duration online in high quality. This video was added by user Joey Blue 02 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 11,750 once and liked it 170 people.