6158 - Updating Your SQL Server 2005 Skills to SQL Server 2008
 |
 |
 |
 |
 |
 |
 |
|
|
|
|
|
|
Location: |
|
| Date: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Duration: |
3 Days |
|
|
|
|
|
|
|
|
|
|
Price: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
 |
|
Print Preview |
Send to a friend |
| Learning Method: |
Instructor Led |
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 |
Target Audience: |
| This course is intended for experienced SQL Server 2005 developers and database administrators who want to upgrade their skills to SQL Server 2008. |
Pre-requisites: |
| Before attending this course, students must have experience developing or administering SQL Server 2005 databases.
|
At Course Completion: |
| 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.
|
|
Module 1: Introduction to SQL Server 2008 |
|
|
| Lessons |
- The Evolution of SQL Server
- 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.
|
|
|
Module 2: SQL Server 2008 Manageability Enhancements |
|
|
| Lessons |
- Configuration Servers
- 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.
|
|
|
Module 3: SQL Server 2008 Performance Enhancements |
|
|
| Lessons |
- Managing Workloads with Resource Governor
- Monitoring Performance with the Data Collector
- 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.
|
|
|
Module 4: SQL Server 2008 Security Enhancements |
|
|
| Lessons |
- Encrypting Databases
- 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.
|
|
|
Module 5: SQL Server 2008 Database Development Enhancements |
|
|
| Lessons |
- Developer Tool Enhancements
- Data Type Enhancements
- 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.
|
|
|
Module 6: SQL Server 2008 Availability Enhancements |
|
|
| Lessons |
- Always On Technologies
- 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.
|
|
|
Module 7: SQL Server 2008 Data Warehousing Enhancements |
|
|
| Lessons |
- ETL Enhancements
- Using Partitioned Tables
- 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.
|
|
|
Module 8: SQL Server 2008 Reporting Services Enhancements |
|
|
| Lessons |
- Reporting Services Architecture and Management
- Authoring Reports
- 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 |
|
|
| Lessons |
- Multidimensional Analysis with SQL Server Analysis Services
- 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.
|
|
|
 |
|
|
| Course Ratings | | Averaged from 136 responses. | | Instructor's Knowledge |  | | Training Quality |  | | Training Objectives |  | | Training Overall | | | Courseware Quality | |
|
| Extraordinary |  | | Great |  | | Good |  | | Average |  | | Poor |  |
|
|
|
