SQL Server 2008 Training Course UK:
Comprehensive DBA & Programming Upgrade

SQL Server 2008 Comprehensive DBA & Programming Upgrade Training Course Overview

Course Code:	SQL0120
Price:	£1995
Duration:	5 Days - custom / on-site options available - please call.
Date:
Who should attend:	Database professionals who need to get quickly up to speed with the powerful new features of Microsoft SQL Server 2008
Prerequisite Skills:	Delegates will ideally have a background knowledge of SQL Server 2005 Administration and developing SQL Server 2005 applications, or equivalent skills in other SQL-based relational databases such as Sybase or Oracle.

The full 5-day Comprehensive Upgrade, primarily aimed at SQL Server 2000 and 2005 Developers and Database Administrators will give delegates intensive hands-on experience of utilising the new features of SQL Server 2008. Relational Database professionals from backgrounds such as Oracle and Sybase should also gain a lot from this course.

Course Content

This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email

SQL Server 2008 Comprehensive DBA & Programming Upgrade Training Course Outline

SQL Server 2008 Overview

SQL Server 2008 Editions
SQL Server Requirements
Upgrading to SQL Server 2008

Enterprise Data Platform

Policy Management
Needs Addressed by Policy Management
Policy Management Components
Sample Policies
Policy Management Administration

High Availability

High Availability Defined
Database Mirroring
Database Snapshots and Mirroring
Windows Clustering in SQL Server
SQL Server Replication
Reducing Planned Downtime

Performance

Managing and Monitoring Resources
Data Collector
Resource Governor
Optimising Storage
Back-up Compression
Data Compression
Improving Query Performance

Security

Disabled Database Engine Features
Remote Connections
.NET Framework
Database and SQLMail
Service Broker
Principals and Securables
Permissions
Types of Permissions
Managing Permissions
Code Access Security
Imperative and Declarative CAS
Auditing in SQL Server 2008

SQL Server Encryption

Encryption Keys
Transparent Data Encryption
Extensible Key Management
Encryption Without Keys
Hashing and Signing Data
Security Catalogue Views
Query Efficiency

Automation and Monitoring

SQL Server Agent
Maintenance Plans
SQLCMD
PowerShell for SQL Server
Database Mail
SQL Profiler
Extended Events

Service Broker

What is Service Broker?
Architecture
Scenarios
Creating Service Broker Applications
Service Broker Routing and Security
Message Priorities
Troubleshooting using SSBDiagnose

Integrated Full-Text Search

Creating Full-Test Catalogues and Indexes
Querying with iFTS
Managing Thesaurus Files
Using Stoplists
Searching Documents
Managing iFTS

New Datatypes in SQL Server 2008

Spatial Support in SQL Server 2008
GEOMETRY type
GEOGRAPHY type
How Time Has Changed in SQL Server
New Hierarchical Datatype
Filestream Support

T-SQL Enhancement for Developers

Notable DML Features
General Development

T-SQL Enhancements for DBAs

Locking Enhancements
Metadata Views
Notable SQL Server Performance Monitor Counters
DDL Triggers
Indexing and Performance Enhancements
Snapshots
Data-Integrity Enhancements

.NET Integration

Introduction to SQL Server .NET Integration
SQL Server .NET Programming Model
Deploying CLR Routines

Programming Assemblies

CLR User-Defined Types
CLR User-Defined Functions
CLR User-Defined Aggregates
CLR User-Defined Triggers
Managing Assemblies

SQL Server and XML

What is XML?
What Are Xpath and the XMLDOM?
Getting XML into the Database
Getting XML out of the Database
Working with XML Data
Programming SQLXML for .NET and COM

SQL Server XML and XQuery Support

Using the XML Datatype
Inserting Data into XML Columns
Querying XML Data
Modifying XML Data
Indexing XML for Performance
Full-Text Search and the XML Datatype
Catalogue Views and XML
Applications and XML
XML Web Services Support

LINQ to SQL

Object/Relational Mapping
Entity-Generation Tools
Rnning LINQ Queries
The DataContext Class

Reporting Services

Reporting Services Components
Building a Basic Report
Report Design Advanced Features
Visual Studio Integration and ReportViewer Controls
Sharepoint Integration
End-User Ad Hoc Query and Reporting
Report Rendering
Data Regions

Analysis Services

New Analysis Service Features in SQL Server 2008
Analysis Service Fundamentals
OLAP, OLTP and Data Warehouses
Analysis Services Projects
Working with Cubes
Analysis Services Projects
Working with Cubes
Using Analysis Services Scripting Language

Integration Services

Overview of SSIS features
What’s new in SSIS
The SSIS Integrated Development Environment
Connecting to SSIS in Management Studio
Creating a New SSIS Project in BIDS
SSIS Fundamentals
Control Flow and Data Flow Designer Tasks
Control Flow Containers and Tasks
Data Flow Designer Tasks
Change Data Capture
Enabling Change Data Capture
Extracting Change Data with SSIS
Logging
Dynamic Package Configuration
Variables
Precedence Constraints
Checkpoints
Transactions
Debugging
Control Flow and Data Flow Visual Debugging
DataViewers
Breakpoints
SSIS Package Handling
The SSIS Package Deployment Utility
Scheduling an SSIS Package