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

Course Categorization:
Microsoft,
Databases,
Course Provider:
New Horizons Computer Learning Centers
Learning Method:
Classroom Learning
This course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.

Lesson 1: Introduction to SQL Server 2008

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

Lesson 2: SQL Server 2008 Manageability Enhancements

  • Configuration Servers
  • Policy-Based Management

Lesson 3: SQL Server 2008 Performance Enhancements

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

Lesson 4: SQL Server 2008 Security Enhancements

  • Encrypting Databases
  • Auditing All Actions

Lesson 5: SQL Server 2008 Database Development Enhancements

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

Lesson 6: SQL Server 2008 Availability Enhancements

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

Lesson 7: SQL Server 2008 Data Warehousing Enhancements

  • ETL Enhancements
  • Using Partitioned Tables
  • Optimizing Data Storage

Lesson 8: SQL Server 2008 Reporting Services Enhancements

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

Lesson 9: SQL Server 2008 Analysis Services Enhancements

  • Multidimensional Analysis with SQL Server Analysis Services
  • Data Mining with SQL Server Analysis Services
  • Charleston, SC - April 30, 2012
  • Columbia, SC - April 30, 2012
  • Greenville, SC - April 30, 2012
  • Chattanooga, TN - April 30, 2012
  • Greensboro, NC - April 30, 2012
  • Charleston, WV - April 30, 2012
  • Charleston, SC - July 16, 2012
  • Columbia, SC - July 16, 2012
  • Greenville, SC - July 16, 2012
  • Charleston, WV - July 16, 2012
  • Charleston, SC - October 1, 2012
  • Columbia, SC - October 1, 2012
  • Greenville, SC - October 1, 2012
  • Charleston, WV - October 1, 2012
  • Charleston, SC - December 17, 2012
  • Columbia, SC - December 17, 2012
  • Greenville, SC - December 17, 2012
  • Charleston, WV - December 17, 2012

Popular Courses

Demo: Maximo Transportation Demo

IBM Maximo for Transportation helps you take a strategic role in how you manage the performance of your transportation assets. In this demo you'll see how routine tasks like maintenance,...

Related Courses

10337 Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2

This course focuses on the new features SQL Server 2008 R2 for BI specialists.

50027 Querying and Processing SQL Server Data with SQL Statements

This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.

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

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

2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services

This course teaches how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use...

6231 Maintaining a Microsoft SQL Server 2008 R2 Database

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product...

6232 Implementing a Microsoft SQL Server 2008 R2 Database

This course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best...

6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

This course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis...

6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the...