SQL Pivot: A Tutorial | Built In

SQL PIVOT and SQL UNPIVOT Examples to Transform Data

Understanding SQL Query Order of Execution | Built In

SQL queries to change the column type

SQL ALTER TABLE to Add, Delete and Change Columns in a Table

SQL UPDATE Statement (Transact SQL) - Essential SQL

Microsoft SQL Documentation - SQL Server

Expresiones comunes de tabla de SQL Server (CTE)

SQL PARTITION BY Clause overview