Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


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


 
Course Outline
Description

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

Objectives

At the end of 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
Topics
  • Introduction to SQL Server 2008
  • SQL Server 2008 Manageability Enhancements
  • SQL Server 2008 Performance Enhancements
  • SQL Server 2008 Security Enhancements
  • SQL Server 2008 Database Development Enhancements
  • SQL Server 2008 Availability Enhancements
  • SQL Server 2008 Data Warehousing Enhancements
  • SQL Server 2008 Reporting Services Enhancements
  • SQL Server 2008 Analysis Services Enhancements
Audience

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

Course Outline

I. Introduction to SQL Server 2008


A. The Evolution of SQL Server
B. Preparing for SQL Server 2008

Lab: Exploring SQL Server Books Online Reviewing the SQL Server Books Online Tutorials Reviewing SQL Server Books Online

After completing this module, students will be able to:

Describe the evolution of SQL Server. Prepare for SQL Server 2008.

II. SQL Server 2008 Manageability Enhancements

A. Configuration Servers
B. Policy-Based Management

Lab: Managing SQL Server 2008 Creating a Configuration Server Creating and Applying a Policy

After completing this module, students will be able to:

Create and use a configuration server
Create and use policies

III. SQL Server 2008 Performance Enhancements

A. Managing Workloads with Resource Governor
B. Monitoring Performance with the Data Collector
C. Managing Performance with Plan Freezing

Lab: Optimizing SQL Server 2008 Using Resource Governor Using the Data Collector

After completing this module, students will be able to:
Manage workloads with Resource Governor
Monitor performance with the Data Collector
Manage performance with Plan Freezing.

IV. SQL Server 2008 Security Enhancements

A. Encrypting Databases
B. Auditing All Actions

Lab: Securing a SQL Server 2008 Database Using Transparent Data Encryption

After completing this module, students will be able to:
Encrypt databases
Audit all actions.

V. SQL Server 2008 Database Development Enhancements

A. Developer Tool Enhancements
B. Data Type Enhancements
C. Working with Spatial Data

Lab: Developing Databases with SQL Server 2008 Using Date and Time Data Types Using Spatial Data

After completing this module, students will be able to:
Describe the developer tool enhancements in SQL Server 2008
Use the data type enhancements in SQL Server 2008
Work with spatial data.

VI. SQL Server 2008 Availability Enhancements

A. Always On Technologies
B. Transactional Peer-to-Peer Replication

Lab: Maintaining High Availability Configuring Peer-to-Peer Replication Adding a Replication Node

After completing this module, students will be able to:
Describe the SQL Server 2008 always on technologies
Implement transactional peer-to-peer replication

VII. SQL Server 2008 Data Warehousing Enhancements


A. ETL Enhancements
B. Using Partitioned Tables
C. Optimizing Data Storage

Lab: Data Warehousing with SQL Server 2008 Using Change Data Capture Using the MERGE Statement Working with Partitioned Data

After completing this module, students will be able to:
Describe the ETL enhancements in SQL Server 2008
Use partitioned tables
Optimize data storage

VIII. SQL Server 2008 Reporting Services Enhancements

A. Reporting Services Architecture and Management
B. Authoring Reports
C. Report Processing and Rendering

Lab: Using SQL Server 2008 Reporting Services Creating a Report with Report Designer Managing Reporting Services

After completing this module, students will be able to:
Describe the Reporting Services architecture and management Author reports
Understand report processing and rendering

Module 9: SQL Server 2008 Analysis Services Enhancements


A. Multidimensional Analysis with SQL Server Analysis Services
B. Data Mining with SQL Server Analysis Services

Lab: Using SQL Server 2008 Analysis Services Implementing Multidimensional Analysis Implementing Data Mining

After completing this module, students will be able to: Implement multidimensional analysis
Implement data mining


Prerequisites & Certificates
Pre-Requisites

Before attending this course, students must have experience developing or administering SQL Server 2005 databases.

Certificates offered

Certificate of Completion


Cancellation Policy
10 Day cancellation required for all courses in order to get a full refund.
Map & Reviews
Protech Training
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
I took the training remotely so I cannot comment on some of the questions. I think that this seminar has too much content to squeeze it into one week.... might be better as a two week course?
Reviewed by 2013
found the material very helpful - although there was a lot of material covered - the pace was well set. Would definitely recommend people to have explored Microsoft Access beforehand to be familiarized with the program before taking the course. I would imagine someone without any exposure would find it confusing. Environment really good - people very, very nice and helpful. Would definitely take the next level of access with the same training facility.
Reviewed by 2013
I was not in the physical classroom. Feedback centered around online training would be good because now I have to rate items that I was not present for. Those items are getting half a star because I was not there to rate them. The course material must go through an editing process. There are a lot of grammar mistakes, but also a lot of actual procedure/activity mistakes.
Reviewed by 2012
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 107 times.