   |
| 6158 - Updating SQL Server 2005 Skills to SQL Server 2008 |
| Vendor Course Code: | 6158 |
| Course Length: | 3 days |
| Course Price: | $2,040.00 |
| Availability: | |
| | If your preferred city or time is not currently listed, please call DDLS on 1800 U LEARN (1800 853 276) and we can try to accommodate your needs. |
| 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
|
| Skills Gained: | 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.
|
| Key Topics: | Module 1: Introduction to SQL Server 2008
Lessons
• The Evolution of SQL Server
• Preparing for SQL Server 2008
Lab 1: 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 2: 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 3: 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 4: 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 5: 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 6: 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 7: 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 8: 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 9: 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.
|
| 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. |
| Prerequisites: | Before attending this course, students must have experience developing or administering SQL Server 2005 databases.
|
