6158 Updating Your SQL Server® 2005 Skills to SQL Server 2008

Displaying courses for United States [Change]

Overview

This course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.

Objectives

After completing this course, students will be able to:
  • Describe the new features of SQL Server 2008.
  • Manage SQL Server 2008.
  • Optimize SQL Server 2008.
  • Secure a SQL Server 2008 Database.
  • Develop databases with SQL Server 2008.
  • Create and maintain highly available SQL Server 2008 databases.
  • Create and use a SQL Server 2008 data warehouse.
  • Use SQL Server 2008 Reporting Services.
  • Use SQL Server 2008 Analysis Services.

Audience

This course is intended for experienced SQL Server 2005 developers and database administrators who want to upgrade their skills to SQL Server 2008.

Syllabus

Introduction to SQL Server 2008

  • The Evolution of SQL Server
  • Preparing for SQL Server 2008

SQL Server 2008 Manageability Enhancements

  • Configuration Servers
  • Policy-Based Management

SQL Server 2008 Performance Enhancements

  • Managing Workloads with Resource Governor
  • Monitoring Performance with the Data Collector
  • Managing Performance with Plan Freezing

SQL Server 2008 Security Enhancements

  • Encrypting Databases
  • Auditing All Actions

SQL Server 2008 Database Development Enhancements

  • Developer Tool Enhancements
  • Data Type Enhancements
  • Working with Spatial Data

SQL Server 2008 Availability Enhancements

  • Always On Technologies
  • Transactional Peer-to-Peer Replication

SQL Server 2008 Data Warehousing Enhancements

  • ETL Enhancements
  • Using Partitioned Tables
  • Optimizing Data Storage

SQL Server 2008 Reporting Services Enhancements

  • Reporting Services Architecture and Management
  • Authoring Reports
  • Report Processing and Rendering

SQL Server 2008 Analysis Services Enhancements

  • Multidimensional Analysis with SQL Server Analysis Services
  • Data Mining with SQL Server Analysis Services

Training provider

Teaching mode:
Online - Self paced
Classroom - Instructor Led
Online - Instructor Led
Duration: 3 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Microsoft Analysis Services
United States
This skill has an average salary of
US$85,000
and is mentioned in
0.19%
of job ads in this area.
Analysis
United States
This skill has an average salary of
US$79,959
and is mentioned in
23.88%
of job ads in this area.
Microsoft SQL Server
United States
This skill has an average salary of
US$96,217
and is mentioned in
2.05%
of job ads in this area.
Database
United States
This skill has an average salary of
US$77,975
and is mentioned in
13.88%
of job ads in this area.