SQL Server Fundamentals

—CTE and Ranking Overview 1m 55s
—Common Table Expressions 2m 44s
—Demo: CTE 11m 49s
—Top 1m 15s
—Demo: Top 5m 33s
—Ranking 1m 52s
—Row Number 1m 24s
—Demo: Row Number 5m 49s
—Rank and DenseRank 1m 52s
—Demo: Rank and DenseRank 2m 8s
—NTile 1m 31s
—Demo: Ntile 3m 32s
—Partitioning 1m 58s
—Demo: Partitioning 2m 31s
—Aggregate Partitions 1m 32s
—Demo: Aggregate Partitions 5m 8s
—Summary 2m 26s

—Title 0m 8s
—Overview 1m 29s
—Hierarchyid/Tree 2m 17s
—Why use hierarchyid? 1m 38s
—Hierarchyid properties 2m 54s
—Demo: Basic Properties 4m 51s
—Demo: Manually finding descendants 4m 5s
—Finding Descendents 2m 0s
—Demo: IsDescendantOf 4m 52s
—Adding Nodes 2m 26s
—Demo: Adding nodes between 4m 26s
—Demo: Adding nodes before/after 5m 23s
—Demo: Adding hierarchyid column to table 10m 25s
—Demo:Incrementally adding hierarchyid to table 5m 33s
—GetReparentedValue 2m 11s
—Demo: Moving node 2m 54s
—Depth & Breadth 2m 30s
—Demo: Indexes and triggers 7m 55s
—Summary 1m 24s

—Overview 0m 34s
—Query Plans 1m 21s
—Query Optimizer 1m 12s
—Plan Reuse 1m 50s
—Example Plan Cache 5m 45s
—Example Stored Procedure Plan 6m 47s
—Ad hoc Expressions 2m 13s
—Example Ad hoc Optimization 4m 56s
—Example Ad hoc Off 0m 37s
—Parameterization 1m 58s
—Example Parameterization 11m 14s
—Example ADO.NET Parameters 3m 33s
—Plan Guides 1m 59s
—Kinds of Plan Guides 2m 43s
—Example Plan Guide 5m 18s
—Managing Plan Guides 0m 46s
—Example Managing Plan Guides 6m 25s
—Example Plan Guide From Handle 3m 12s
—Example Object Plan Guide 2m 30s
—Example Optimize For 4m 20s
—Example Template Plan Guide 5m 4s
—Summary 1m 9s

—Overview 2m 8s
—Recursive Query 2m 56s
—Numeric Recursion Example 4m 22s
—Tabular Recursion Example 7m 30s
—Aggregate Recursion Example 1m 52s
—Pivot 1m 51s
—Cross-Tab Example 7m 55s
—Group By Equivalent 2m 53s
—Unpivot 4m 24s
—Entity Attribute Value 4m 20s
—Entity Attribute Example 5m 12s
—Sampling 2m 25s
—Sampling Example 10m 21s
—Summary 1m 13s

—Overview 1m 9s
—Databases and Security 1m 18s
—Authentication and Authorization 1m 24s
—Principals 3m 0s
—Example Managing Principals 0m 44s
—Example Server Principals 5m 1s
—Example Database Principals 10m 26s
—Example Role Principals 1m 15s
—Objects 3m 24s
—Authorization and Permissions 3m 15s
—Covering Permissions 1m 3s
—Example Authorizing Principals 4m 34s
—Example Using Permissions 9m 30s
—Example Impersonation 6m 9s
—Groups and Roles 0m 45s
—Example Groups and Roles 9m 3s
—Summary 1m 13s
—References 0m 30s

—Overview 2m 40s
—Schemas 1m 37s
—Schemas Example 22m 47s
—Schemas Summary 4m 23s
—Roles 1m 28s
—Server Roles 0m 52s
—Database Roles 0m 50s
—Roles Example 20m 20s
—Roles Summary 1m 47s
—Execution Context 0m 45s
—Changing Execution Context 0m 51s
—Execution Context Scope 1m 0s
—Execution Context Example 17m 10s
—Execution Context Summary 1m 37s
—Summary 1m 4s