Course
Skills
SQL Server Fundamentals
Using T-SQL, the CLR, XML, managing SQL Server operations and security in SQL Server
What you'll learn
This course is primarily for C# developers who use SQL Server in their applications. T-SQL developers and Database Administrators will also find it useful.
Table of contents
Introduction to SQL Server
76mins
- Overview 1m
- What is SQL Server 1m
- Application 3m
- Using SSMS 3m
- Drop a Database 0m
- Add a Database 5m
- Using T-SQL 5m
- sqlcmd 7m
- sqlps 5m
- T-SQL Language 3m
- Metadata 4m
- T-SQL Example 8m
- Scripting Objects 2m
- Linq To Sql 4m
- Linq to Sql Example 5m
- SMO 4m
- Analysis and Reporting 6m
- SSAS 2m
- SSIS 2m
- SSRS 2m
- Summary 3m
- References 1m
Using Group By and Having
16mins
CTE's and Ranking
57mins
- CTE and Ranking Overview 2m
- Common Table Expressions 3m
- Demo: CTE 12m
- Top 1m
- Demo: Top 6m
- Ranking 2m
- Row Number 1m
- Demo: Row Number 6m
- Rank and DenseRank 2m
- Demo: Rank and DenseRank 2m
- NTile 2m
- Demo: Ntile 4m
- Partitioning 2m
- Demo: Partitioning 3m
- Aggregate Partitions 2m
- Demo: Aggregate Partitions 5m
- Summary 2m
Hierarchies
68mins
- Title 0m
- Overview 1m
- Hierarchyid/Tree 2m
- Why use hierarchyid? 2m
- Hierarchyid properties 3m
- Demo: Basic Properties 5m
- Demo: Manually finding descendants 4m
- Finding Descendents 2m
- Demo: IsDescendantOf 5m
- Adding Nodes 2m
- Demo: Adding nodes between 4m
- Demo: Adding nodes before/after 5m
- Demo: Adding hierarchyid column to table 10m
- Demo:Incrementally adding hierarchyid to table 6m
- GetReparentedValue 2m
- Demo: Moving node 3m
- Depth & Breadth 3m
- Demo: Indexes and triggers 8m
- Summary 1m
Managing Query Plans
76mins
- Overview 1m
- Query Plans 1m
- Query Optimizer 1m
- Plan Reuse 2m
- Example Plan Cache 6m
- Example Stored Procedure Plan 7m
- Ad hoc Expressions 2m
- Example Ad hoc Optimization 5m
- Example Ad hoc Off 1m
- Parameterization 2m
- Example Parameterization 11m
- Example ADO.NET Parameters 4m
- Plan Guides 2m
- Kinds of Plan Guides 3m
- Example Plan Guide 5m
- Managing Plan Guides 1m
- Example Managing Plan Guides 6m
- Example Plan Guide From Handle 3m
- Example Object Plan Guide 3m
- Example Optimize For 4m
- Example Template Plan Guide 5m
- Summary 1m
Recursion, Pivoting, and Sampling
58mins
Security I
63mins
- Overview 1m
- Databases and Security 1m
- Authentication and Authorization 1m
- Principals 3m
- Example Managing Principals 1m
- Example Server Principals 5m
- Example Database Principals 10m
- Example Role Principals 1m
- Objects 3m
- Authorization and Permissions 3m
- Covering Permissions 1m
- Example Authorizing Principals 5m
- Example Using Permissions 10m
- Example Impersonation 6m
- Groups and Roles 1m
- Example Groups and Roles 9m
- Summary 1m
- References 1m
Security II
80mins
About the author
Dan is an independent consultant, author, and speaker. He likes data; pointy data, rectangular data, even data just lying around on the floor. He is a co-author of the book "A Developers Guide to SQL Server 2005". His articles have been published in MSDN Magazine and SQL Server Magazine and he has spoken at WinDev, Microsoft events, as well as to various developer groups.