• Lesson.No : 53
  • 00:07:16

  • 51 PIVOT and UNPIVOT

  • Play

Course Lessons

  1. 1- 1 Course Layout
  2. 2- 2 SQL Server Overview
  3. 3- 3 SQL Server Managment Studio Overview
  4. 4- 4 TSQL Introduction
  5. 5- 5 Logical Order of Operations in SELECT Statements
  6. 6- 6 Writing SELECT Queries
  7. 7- 7 Schema In SQL Server
  8. 8- 8 CASE Expressions in SELECT
  9. 9- 9 N Char in SQL
  10. 10- 10 In Statment
  11. 11- 11 Querying with Inner Joins
  12. 12- 12 Querying with Outer Joins
  13. 13- 13 Querying with Cross Joins and Self Joins
  14. 14- 14 Working with SQL Server 2014 Data Types
  15. 15- 15 Working with SQL Server 2014 Data Types Theory
  16. 16- 16 Collation in SQL Server
  17. 17- 17 N char in SQL Query
  18. 18- 18 String Functions
  19. 19- 19 DateTime Functions
  20. 20- 20 Insert Data in SQL
  21. 21- 21 Update Data in SQL
  22. 22- 22 Delete Data in SQL
  23. 23- 23 Data Modification Overview
  24. 24- 24 Sequences in SQL
  25. 25- 25 Built In Functions in SQL
  26. 26- 26 Grouping and Aggregating Data
  27. 27- 27 Grouping and Aggregating Data Review
  28. 28- 28 Using Subqueries
  29. 29- 29 Views in SQL
  30. 30- 30 Stored Procedure in SQL
  31. 31- 30 1 Output Parameters in Stored Procedure
  32. 32- 30 2 Writing Queries with Dynamic SQL
  33. 33- 31 User Define Function
  34. 34- 32 Trigger in SQL
  35. 35- 33 Passing Arguments to Derived Tables
  36. 36- 34 How to Create Temp Table in SQL Server
  37. 37- 35 Common Table Expressions
  38. 38- 36 UNION Operator
  39. 39- 37 Using EXCEPT and INTERSECT
  40. 40- 38 CROSS APPLY and OUTER APPLY P1
  41. 41- 39 T SQL Batches P1
  42. 42- 40 T SQL Programming Demo
  43. 43- 41 MERGE in SQL Server Demo
  44. 44- 42 Try Catch and Error Handling in SQL Server Demo
  45. 45- 43 @@Error in SQL Server Demo
  46. 46- 44 Transactions in SQL Server
  47. 47- 45 Inhance Query Performance small Notes
  48. 48- 46 Cluster Index in SQL Server
  49. 49- 47 Non Cluster Index in SQL Server
  50. 50- 48 Metadata Query in SQL Overview
  51. 51- 49 Partitioning Windows AND Ranking Functions in SQL
  52. 52- 50 LAG Lead Offset Function
  53. 53- 51 PIVOT and UNPIVOT
  54. 54- 52 GROUPING SETS in SQL
  55. 55- 53 CUBE and ROLLUP in SQL Server