Advanced Query Techniques in SQL Server course. The SQL Server data engine traditionally stores relational data, but it can also be used to store data in non-relational schemas. You’ll learn an example – Entity, Attribute, Value (EAV). SQL Server’s Transact-SQL language provides the ability to transform relational data in many ways. In this Advanced Query Techniques in SQL Server course, you’ll gain the ability to solve four important problems with SQL Server. First, you’ll learn how to manipulate hierarchical data using recursive common table expressions (CTEs). Second, you’ll learn how to pivot tabular data while using PIVOT to capture the metrics you want. Next, you’ll learn how to use UNPIVOT to convert cross-tabulated data to relational data. Then, you’ll learn how to use semantic data modeling and the entry, attribute, and value data structures when a purely relational model limits flexibility and attributes can change frequently. Finally, you’ll learn how to create samples of SQL Server data for analysis and testing. When you complete this course, you’ll have the skills and knowledge of advanced SQL Server query techniques you need to quickly solve the problems presented here.