Learn your way! Get started

Exploring SQL Server 2008

with expert Don Kiely

Course at a glance

Included in these subscriptions:

Dev & IT Pro Video
Dev & IT Pro Power Pack

	Release date	11/20/2008
	Level	Intermediate
	Runtime	11h 14m
	Closed captioning	N/A
	Transcript	N/A
	eBooks / courseware	N/A
	Hands-on labs	N/A
	Sample code	Included
	Exams	Included

Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

This course looks at many of the new features within Microsoft SQL Server 2008 and will give you a first look at the new powerful database server. You will learn about new T-SQL data types and syntax enhancements, see how to store and manipulate unstructured data, and learn about the SQL CLR and new advances in client data access. You will also take a first look at the new Visual Studio Team System Edition 2008 for Database Professional, and check out the new and improved administrative features in PowerShell, security, FullText search, and many more.

Meet the expert

Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.

Course outline

Module 1

Introduction (33:34)

Introduction (02:49)
Goal for This Version (04:34)
Multitudes of Versions (03:03)
New Features (01:51)
Demo: Enhancements (21:04)
Summary (00:11)

Introduction Continued (34:10)

Introduction (00:34)
Demo: Scripting Support (00:32)
Demo: Debugging (07:29)
Demo: Help (02:55)
Demo: Templates (09:00)
Integration Services (01:41)
Reporting Services (01:27)
Service Broker (01:54)
Analysis Services (01:19)
Deprecated Features (04:46)
Feature Pack (02:05)
Summary (00:22)

Module 2

Installation (20:59)

Introduction (01:19)
Install SQL Server 2008 (01:16)
Demo: Options (03:25)
Demo: Feature Selection (01:45)
Demo: Instance (00:59)
Demo: Disk Space (00:34)
Demo: Server Config (03:52)
Demo: Database Engine (04:41)
Demo: Error Reporting (01:11)
Demo: Installing (01:37)
Summary (00:18)

Date Time (20:16)

Introduction (01:12)
Date and Time Types (01:25)
DATE (01:14)
TIME (01:20)
DATETIME2 (01:26)
DATETIMEOFFSET (01:52)
Demo: Date/Time Types (11:06)
Summary (00:37)

Spatial Data (35:08)

Introduction (00:55)
Overview (03:13)
The Mother Ship (00:42)
Map Distortion (01:43)
Spatial Data Standards (01:14)
Types of Spatial Data (01:26)
Spatial Objects (02:02)
Geospatial Data (02:10)
Demo: Spatial Data (05:56)
Demo: Shape Designer (14:58)
Summary (00:45)

Module 3

HieirarchyID (34:13)

Introduction (00:53)
Overview (02:56)
Indexing a Hierarchy (03:16)
Manipulating Hierarchies (02:04)
Demo: Hierarchy Type (16:17)
New T-SQL Syntax (02:16)
Demo: New Syntax (06:05)
Summary (00:23)

Sparse Columns (31:54)

Introduction (00:56)
Overview (02:10)
Restrictions (01:45)
Column Sets (01:08)
Restrictions (00:44)
Recommendations (00:41)
Demo: Sparse Columns (07:01)
Demo: Column Sets (07:34)
Filtered Indexes (02:07)
Using Filtered Indexes (01:46)
Demo: Filtered Indexes (05:37)
Summary (00:21)

Module 4

Table Valued Parameters (44:26)

Introduction (02:29)
Demo: A Simple TVP (05:15)
Demo: Cannot Update (03:57)
TVP Details (01:28)
Demo: TVP Examples (10:24)
Limitations & Gotchas (02:06)
Client Apps (01:54)
Object Support in ADO.NET (01:33)
Demo: ADO.NET Examples (14:54)
Summary (00:22)

Grouping Sets (56:23)

Introduction (00:59)
Overview (01:28)
Demo: Grouping Sets (11:01)
Demo: Rollup (03:03)
Demo: Cube (01:45)
Demo: Grouping ID (05:02)
MERGE Statement (03:03)
Five Clauses (01:43)
The WHEN Clause (05:02)
Demo: MERGE (22:13)
Summary (00:58)

Module 5

Unstructured Data (53:19)

Introduction (01:10)
FILESTREAM (04:26)
Access Methods (02:08)
Gotchas (01:49)
Demo: FILESTREAM (15:06)
XML Data Type (01:15)
Validating XML (03:19)
Let in FLWOR Queries (00:41)
Modifying XML (01:09)
Demo: Lax Validation (21:31)
Summary (00:40)

SQLCLR (48:43)

Introduction (01:07)
SQLCLR Enhancements (03:44)
Demo: SQLCLR (16:42)
Demo: Max Date (05:10)
Demo: Ship Lag (07:02)
Demo: String Array (05:36)
Demo: Products (08:52)
Summary (00:26)

Module 6

Entity Framework (52:04)

Introduction (00:47)
Overview (03:02)
Entity Data Model (02:28)
Model & Mapping Files (01:15)
Entity Framework (03:26)
LINQ (02:28)
Demo: EDM (28:01)
Demo: Deferred Loading (09:39)
Summary (00:54)

Client Programming (55:45)

Introduction (01:16)
SQL Native Client (01:27)
New in Version 10.0 (01:55)
Compact Edition (01:34)
New Features (01:21)
New Features in SP1 (00:55)
Sync Framework (01:33)
Team System Edition (02:08)
Database Development (04:35)
Integrated with VS (01:39)
VS Tasks (02:38)
Demo: DB App Projects (14:50)
Demo: Test Data (19:24)
Summary (00:23)

Module 7

Beyond Creating Databases (33:56)

Introduction (00:54)
Demo: Unit Test (11:54)
Demo: Test View (03:44)
Demo: Renaming (04:07)
Demo: Compare Schemas (03:55)
Demo: Partial Projects (09:02)
Summary (00:19)

Indexed Search (24:39)

Introduction (00:47)
Non-Relational Indexing (05:33)
Integrated FTS (03:41)
FTS in SQL Server 2008 (03:37)
FTS Components (02:57)
Demo: FTS (07:17)
Summary (00:44)

PowerShell (25:32)

Introduction (01:17)
Overview (01:17)
With SQL Server (01:39)
Hierarchy (01:35)
Demo: PowerShell (19:20)
Summary (00:22)

Module 8

Encryption (40:02)

Introduction (01:03)
Encryption Functions (01:29)
Demo: Certificates (07:51)
Demo: Asymmetric Keys (05:55)
Demo: Asymkeyproperty (00:54)
Demo: Symmetric Keys (08:30)
Demo: Symkeyproperty (00:29)
Demo: Key Name (11:19)
Demo: Crypt Gen Random (01:47)
Summary (00:40)

Transparent Data Encryption (29:00)

Introduction (01:06)
TDE (03:03)
How TDE Works (03:22)
Limitations of TDE (03:00)
TDE Performance (00:50)
Demo: TDE (10:05)
Cell Encryption (02:41)
Which Encryption to Use? (01:29)
Extensible Key (02:29)
Summary (00:52)