Server

Pluralsight – Advanced Querying Techniques in SQL Server

Pluralsight – Advanced Querying Techniques in SQL Server
English | Tutorial | Size: 174.02 MB


SQL Server’s data engine traditionally stores relational data but it can also be used to store data in non-relational schemas. You’ll learn about one example — Entity, Attribute, Value (EAV).

Pluralsight – Working with Hierarchies in SQL Server By Pinal Dave

Pluralsight – Working with Hierarchies in SQL Server By Pinal Dave
English | Tutorial | Size: 137.19 MB


In this course, you will learn to work with hierarchical data in SQL Server using hierarchyid. You will master techniques to create, query, optimize, and traverse hierarchies efficiently.