| About this Course This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008 |
| Audience Profile This course is intended for experienced SQL Server 2005 developers and database administrators who want to upgrade their skills to SQL Server 2008. |
| At Course Completion After completing this course, students will be able to:
|
- The Evolution of SQL Server
- Preparing for SQL Server 2008
- 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.
- Configuration Servers
- Policy-Based Management
- 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.
- Managing Workloads with Resource Governor
- Monitoring Performance with the Data Collector
- Managing Performance with Plan Freezing
- 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.
- Encrypting Databases
- Auditing All Actions
- Using Transparent Data Encryption
After completing this module, students will be able to:
- Encrypt databases.
- Audit all actions.
- Developer Tool Enhancements
- Data Type Enhancements
- Working with Spatial Data
- 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.
- Always On Technologies
- Transactional Peer-to-Peer Replication
- 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.
- ETL Enhancements
- Using Partitioned Tables
- Optimizing Data Storage
- 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.
- Reporting Services Architecture and Management
- Authoring Reports
- Report Processing and Rendering
- 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.
- Multidimensional Analysis with SQL Server Analysis Services
- Data Mining with SQL Server Analysis Services
- Implementing Multidimensional Analysis
- Implementing Data Mining
After completing this module, students will be able to:
- Implement multidimensional analysis.
- Implement data mining.
D0wn10ad
http://www.easy-share.com/1905145273/ebook_Udovice6158A.rar
http://www.uploading.com/files/P6ZTX2S9/ebook_Udovice6158A.rar.html
http://hotfile.com/dl/2365073/e95095d/ebook_Udovice6158A.rar.html
http://rapidshare.com/files/231949099/ebook_Udovice6158A.rar
No comments:
Post a Comment