To speak to a training advisor please call

training@coursemonster.com

All Courses / Microsoft Courses / Microsoft SQL Server 2008: New Features for SQL Server 2005 Administrators and Developers

Share: Follow us:

Bookmark with:

twiter

Print Page:

Microsoft SQL Server 2008: New Features for SQL Server 2005 Administrators and Developers

Online Training

Time stretched?

If you would prefer something more flexible, we can now offer Online Training related to this topic.

Click to see a list of courses »

Course Overview

The course will introduce delegates to the new feature of Microsoft SQL Server 2008 for existing SQL Server 2005 administrators and Transact SQL developers. The topics covered will include installation, using policies, new data types and apply joins. The course will include lectures, demonstrations and exercises to consolidate the topics covered.

CourseMonster are unbiased and "vendor neutral" which means that we can find the right course for you or your company by looking at our entire database of Microsoft training providers.

Related Courses

Audience

Database administrators, support staff and Transact SQL developers who need to know the new features of Microsoft SQL Server 2008.

Prerequisites

Delegates must have extensive experience of Microsoft SQL Server 2005. This can be gained from our SQL Server 2005 Administration and SQL Server 2005 SQL Server 2005 Querying and Programming courses.

Course Outline

INTRODUCTION, INSTALLATION & UPGRADING

Introduction to Microsoft SQL Server 2008
SQL Server 2008 Editions
SQL Server 2008 Hardware and Software Requirement
Installing SQL Server 2008
Installation Based on a Configuration File
SQL Server Configuration Manager
Upgrading From Previous Versions of SQL Server

MANAGEMENT

Management Studio Enhancements
Policy Based Management
Central management Servers
Registering Servers
Multi Server Queries
PowerShell

SECURITY ENHANCEMENTS

Transparent Data Encryption
Auditing

PERFORMANCE

Introduction
Resource Governor
Performance Data Collection
Data Compression

RECOVERY & AVAILABILITY

Introduction
Backup Compression
Rebuilding the Master and Resource Databases
Database Mirroring
Mirroring Data Page Recovery
Peer to Peer Replication

NEW DATA TYPES

Introduction
Date and Time Enhancements
Filestream Data
Sparse Columns
HierarchyID Data Type
Spatial Data Types
User Defined Tables

TRANSACT SQL

TSQL New Features
New Statement
Overview of LINQ to SQL
Change Data Capture
Filtered Indexes

SQL SERVER INTEGRATION SERVICES

What's New in Integration Services
Import/Export Wizard Improvements
Performance Improvements
Upgrading SQL Server 2005 SSIS Packages
Data Profiler Task and Viewer

SQL SERVER REPORTING SERVICES

SQL 2008 Reporting Services
Working with BIDS
Gauges and Improved Charts
Adding a Gauge to a Report
Tablix
Upgrading SQL 2005 Reports
The Report Builder
Report Builder Using Models

Related Online Training

If you would prefer the flexibility of online training, use the link(s) below:

More Online Training>>

Top Selling Brands

How to make a booking for the SQ8K3NEW course

Scheduled Dates

Request availability or enquire by clicking a date:

Sort by Location

West Midlands

Worcestershire

£

995

Sort by Date

West Midlands

£

995

No Suitable Dates?

Please click above and we will take care of the rest.

Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.

CourseMonster books thousands of public training courses, classes and boot camps both in London, City of London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Aylesbury, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Newcastle, Norwich, Nottingham, Plymouth, Reading, Sheffield, Southampton, Surrey, Sussex, Midlands and Yorkshire. Topics range from software to administration, project management and development.