Want to supercharge your creative skills?
Pluralsight has acquired Digital-Tutors, giving you access to its 1,500+ creative skills courses.
Please enable Javascript, which is required for this site.
sql-server-fundamentals

SQL Server Fundamentals

Using T-SQL, the CLR, XML, managing SQL Server operations and security in SQL Server

Authored by: Dan Sullivan
Duration: 8h 12m
Level: Beginner
Released: 6/15/2010
Features: Closed captions
Course Rating:
You are currently not signed in. Please sign in to access subscriber-only content.
expand all | collapse all Progress Duration
This module is unavailableIntroduction to SQL Server
 You have not watched this Module. 01:14:29
Overview
You have not watched this Clip. 00:54
What is SQL Server
You have not watched this Clip. 00:55
Application
You have not watched this Clip. 03:22
Using SSMS
You have not watched this Clip. 02:47
Drop a Database
You have not watched this Clip. 00:23
Add a Database
You have not watched this Clip. 04:35
Using T-SQL
You have not watched this Clip. 05:25
sqlcmd
You have not watched this Clip. 07:20
sqlps
You have not watched this Clip. 04:42
T-SQL Language
You have not watched this Clip. 03:02
Metadata
You have not watched this Clip. 03:52
T-SQL Example
You have not watched this Clip. 08:00
Scripting Objects
You have not watched this Clip. 01:52
Linq To Sql
You have not watched this Clip. 03:32
Linq to Sql Example
You have not watched this Clip. 05:20
SMO
You have not watched this Clip. 03:31
Analysis and Reporting
You have not watched this Clip. 05:33
SSAS
You have not watched this Clip. 02:01
SSIS
You have not watched this Clip. 01:40
SSRS
You have not watched this Clip. 01:34
Summary
You have not watched this Clip. 03:09
References
You have not watched this Clip. 01:00
This module is unavailableUsing Group By and Having
 You have not watched this Module. 00:16:07
Overview and Examples
You have not watched this Clip. 02:12
Basic Group By
You have not watched this Clip. 04:13
Using Aggregate Functions and Having
You have not watched this Clip. 04:36
Trimming Input And Summary
You have not watched this Clip. 05:06
This module is unavailableCTE's and Ranking
 You have not watched this Module. 00:54:59
CTE and Ranking Overview
You have not watched this Clip. 01:55
Common Table Expressions
You have not watched this Clip. 02:44
Demo: CTE
You have not watched this Clip. 11:49
Top
You have not watched this Clip. 01:15
Demo: Top
You have not watched this Clip. 05:33
Ranking
You have not watched this Clip. 01:52
Row Number
You have not watched this Clip. 01:24
Demo: Row Number
You have not watched this Clip. 05:49
Rank and DenseRank
You have not watched this Clip. 01:52
Demo: Rank and DenseRank
You have not watched this Clip. 02:08
NTile
You have not watched this Clip. 01:31
Demo: Ntile
You have not watched this Clip. 03:32
Partitioning
You have not watched this Clip. 01:58
Demo: Partitioning
You have not watched this Clip. 02:31
Aggregate Partitions
You have not watched this Clip. 01:32
Demo: Aggregate Partitions
You have not watched this Clip. 05:08
Summary
You have not watched this Clip. 02:26
This module is unavailableHierarchies
 You have not watched this Module. 01:09:21
Title
You have not watched this Clip. 00:08
Overview
You have not watched this Clip. 01:29
Hierarchyid/Tree
You have not watched this Clip. 02:17
Why use hierarchyid?
You have not watched this Clip. 01:38
Hierarchyid properties
You have not watched this Clip. 02:54
Demo: Basic Properties
You have not watched this Clip. 04:51
Demo: Manually finding descendants
You have not watched this Clip. 04:05
Finding Descendents
You have not watched this Clip. 02:00
Demo: IsDescendantOf
You have not watched this Clip. 04:52
Adding Nodes
You have not watched this Clip. 02:26
Demo: Adding nodes between
You have not watched this Clip. 04:26
Demo: Adding nodes before/after
You have not watched this Clip. 05:23
Demo: Adding hierarchyid column to table
You have not watched this Clip. 10:25
Demo:Incrementally adding hierarchyid to table
You have not watched this Clip. 05:33
GetReparentedValue
You have not watched this Clip. 02:11
Demo: Moving node
You have not watched this Clip. 02:54
Depth & Breadth
You have not watched this Clip. 02:30
Demo: Indexes and triggers
You have not watched this Clip. 07:55
Summary
You have not watched this Clip. 01:24
This module is unavailableManaging Query Plans
 You have not watched this Module. 01:15:26
Overview
You have not watched this Clip. 00:34
Query Plans
You have not watched this Clip. 01:21
Query Optimizer
You have not watched this Clip. 01:12
Plan Reuse
You have not watched this Clip. 01:50
Example Plan Cache
You have not watched this Clip. 05:45
Example Stored Procedure Plan
You have not watched this Clip. 06:47
Ad hoc Expressions
You have not watched this Clip. 02:13
Example Ad hoc Optimization
You have not watched this Clip. 04:56
Example Ad hoc Off
You have not watched this Clip. 00:37
Parameterization
You have not watched this Clip. 01:58
Example Parameterization
You have not watched this Clip. 11:14
Example ADO.NET Parameters
You have not watched this Clip. 03:33
Plan Guides
You have not watched this Clip. 01:59
Kinds of Plan Guides
You have not watched this Clip. 02:43
Example Plan Guide
You have not watched this Clip. 05:18
Managing Plan Guides
You have not watched this Clip. 00:46
Example Managing Plan Guides
You have not watched this Clip. 06:25
Example Plan Guide From Handle
You have not watched this Clip. 03:12
Example Object Plan Guide
You have not watched this Clip. 02:30
Example Optimize For
You have not watched this Clip. 04:20
Example Template Plan Guide
You have not watched this Clip. 05:04
Summary
You have not watched this Clip. 01:09
This module is unavailableRecursion, Pivoting, and Sampling
 You have not watched this Module. 00:59:22
Overview
You have not watched this Clip. 02:08
Recursive Query
You have not watched this Clip. 02:56
Numeric Recursion Example
You have not watched this Clip. 04:22
Tabular Recursion Example
You have not watched this Clip. 07:30
Aggregate Recursion Example
You have not watched this Clip. 01:52
Pivot
You have not watched this Clip. 01:51
Cross-Tab Example
You have not watched this Clip. 07:55
Group By Equivalent
You have not watched this Clip. 02:53
Unpivot
You have not watched this Clip. 04:24
Entity Attribute Value
You have not watched this Clip. 04:20
Entity Attribute Example
You have not watched this Clip. 05:12
Sampling
You have not watched this Clip. 02:25
Sampling Example
You have not watched this Clip. 10:21
Summary
You have not watched this Clip. 01:13
This module is unavailableSecurity I
 You have not watched this Module. 01:03:43
Overview
You have not watched this Clip. 01:09
Databases and Security
You have not watched this Clip. 01:18
Authentication and Authorization
You have not watched this Clip. 01:24
Principals
You have not watched this Clip. 03:00
Example Managing Principals
You have not watched this Clip. 00:44
Example Server Principals
You have not watched this Clip. 05:01
Example Database Principals
You have not watched this Clip. 10:26
Example Role Principals
You have not watched this Clip. 01:15
Objects
You have not watched this Clip. 03:24
Authorization and Permissions
You have not watched this Clip. 03:15
Covering Permissions
You have not watched this Clip. 01:03
Example Authorizing Principals
You have not watched this Clip. 04:34
Example Using Permissions
You have not watched this Clip. 09:30
Example Impersonation
You have not watched this Clip. 06:09
Groups and Roles
You have not watched this Clip. 00:45
Example Groups and Roles
You have not watched this Clip. 09:03
Summary
You have not watched this Clip. 01:13
References
You have not watched this Clip. 00:30
This module is unavailableSecurity II
 You have not watched this Module. 01:19:11
Overview
You have not watched this Clip. 02:40
Schemas
You have not watched this Clip. 01:37
Schemas Example
You have not watched this Clip. 22:47
Schemas Summary
You have not watched this Clip. 04:23
Roles
You have not watched this Clip. 01:28
Server Roles
You have not watched this Clip. 00:52
Database Roles
You have not watched this Clip. 00:50
Roles Example
You have not watched this Clip. 20:20
Roles Summary
You have not watched this Clip. 01:47
Execution Context
You have not watched this Clip. 00:45
Changing Execution Context
You have not watched this Clip. 00:51
Execution Context Scope
You have not watched this Clip. 01:00
Execution Context Example
You have not watched this Clip. 17:10
Execution Context Summary
You have not watched this Clip. 01:37
Summary
You have not watched this Clip. 01:04