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 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

Join Today
SQL Unpivot and more
▶︎

SQL Unpivot and more

40 Advanced Tips for SSMS (To Save You Time)
▶︎

40 Advanced Tips for SSMS (To Save You Time)

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3
▶︎

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

SQL Self Join | Quick Tips Ep58
▶︎

SQL Self Join | Quick Tips Ep58

SQL Server Management Studio (SSMS) | Full Course
▶︎

SQL Server Management Studio (SSMS) | Full Course

SQL Server sp_help | Quick Tips Ep56
▶︎

SQL Server sp_help | Quick Tips Ep56

Expert Level SQL Tutorial
▶︎

Expert Level SQL Tutorial

Learn SQL Server Integration Services (SSIS) in 2 Hours - Complete Beginner's Guide to ETL
▶︎

Learn SQL Server Integration Services (SSIS) in 2 Hours - Complete Beginner's Guide to ETL

How to remove Duplicate Data in SQL | SQL Query to remove duplicate
▶︎

How to remove Duplicate Data in SQL | SQL Query to remove duplicate

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
▶︎

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

SQL WITH Clause | How to write SQL Queries using WITH Clause | SQL CTE (Common Table Expression)
▶︎

SQL WITH Clause | How to write SQL Queries using WITH Clause | SQL CTE (Common Table Expression)

Listen and Feel the Peace | Tibetan Healing Sounds for Deep Meditation, Inner Peace & Soul Healing
▶︎

Listen and Feel the Peace | Tibetan Healing Sounds for Deep Meditation, Inner Peace & Soul Healing

SQL Recursion with CTE Part 1 | Quick Tips Ep59
▶︎

SQL Recursion with CTE Part 1 | Quick Tips Ep59

SQL CASE Statement | Quick Tips Ep61
▶︎

SQL CASE Statement | Quick Tips Ep61

SQL Stored Procedures - What They Are, Best Practices, Security, and More...
▶︎

SQL Stored Procedures - What They Are, Best Practices, Security, and More...

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
▶︎

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)

SQL Columnstore Index (Visually Explained) | Columnstore vs Rowstore | #SQL Course 36
▶︎

SQL Columnstore Index (Visually Explained) | Columnstore vs Rowstore | #SQL Course 36

SQL Tutorial - PIVOT
▶︎

SQL Tutorial - PIVOT

SQL Recursive Join with CTE Part 2 | Quick Tips Ep60
▶︎

SQL Recursive Join with CTE Part 2 | Quick Tips Ep60

SQL Views Tutorial | VIEWS in SQL Complete Tutorial
▶︎

SQL Views Tutorial | VIEWS in SQL Complete Tutorial