Master the SQL SELECT statement part 11: PIVOT and UNPIVOT

Описание: This video is part of a multi-part series on mastering the SQL SELECT statement. The SELECT statement, the most often used SQL command, is easy to learn yet difficult to master. Follow along with me and level up your database query super powers!

This video covers the PIVOT and UNPIVOT keywords which are part of the FROM clause. PIVOT is used to transform rows into columns, and UNPIVOT does the reverse transforming columns of data into rows. PIVOT is often used to provide summarized tabulations of data, while UNPIVOT is used to fixed unnormalized or non-queryable data.

The SQL code is available here: https://github.com/mafudge/learn-data...

If you need to setup your own database environment, check out learn-databases! The easy way to get going and follow along with these videos.    • Learn Databases Walkthrough  

This video is part of the textbook Applied Database Management https://applieddb.com

Here's the entire playlist:    • Applied Database Management with SQL