New Horizons Computer Learning Center
410-597-9722

6158C: Updating Your SQL Server 2005 Skills to SQL Server 2008

Course Length: 3 Days

Overview:
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.

Prerequisites:
SQL 2005 Administration experience

Course Objectives:
Upon successful completion 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

Course Content

Lesson 1: Introduction to SQL Server 2008

• The Evolution of SQL Server
• Preparing for SQL Server 2008
• Lab 1: Exploring SQL Server Books Online

Lesson 2: SQL Server 2008 Manageability Enhancements

• Configuration Servers
• Policy-Based Management
• Lab 2: Managing SQL Server 2008

Lesson 3: SQL Server 2008 Performance Enhancements

• Managing Workloads with Resource Governor
• Monitoring Performance with the Data Collector
• Managing Performance with Plan Freezing
• Lab 3: Optimizing SQL Server 2008

Lesson 4: SQL Server 2008 Security Enhancements

• Encrypting Databases
• Auditing All Actions
• Lab 4: Securing a SQL Server 2008 Database

Lesson 5: SQL Server 2008 Database Development Enhancements

• Developer Tool Enhancements
• Data Type Enhancements
• Working with Spatial Data
• Lab 5: Developing Databases with SQL Server 2008

Lesson 6: SQL Server 2008 Availability Enhancements

• Always On Technologies
• Transactional Peer-to-Peer Replication
• Lab 6: Maintaining High Availability

Lesson 7: SQL Server 2008 Data Warehousing Enhancements

• ETL Enhancements
• Using Partitioned Tables
• Optimizing Data Storage
• Lab 7: Data Warehousing with SQL Server 2008

Lesson 8: SQL Server 2008 Reporting Services Enhancements

• Reporting Services Architecture and Management
• Authoring Reports
• Report Processing and Rendering
• Lab 8: Using SQL Server 2008 Reporting Services

Lesson 9: SQL Server 2008 Analysis Services Enhancements

• Multidimensional Analysis with SQL Server Analysis Services
• Data Mining with SQL Server Analysis Services
• Lab 9: Using SQL Server 2008 Analysis Services

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com