How to update SQL Server 2005 Skills to SQL Server 2008
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.
Course Outline:
Module 1: Introduction to SQL Server 2008Lessons
*
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 EnhancementsLessons
*
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 EnhancementsLessons
*
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 EnhancementsLessons
*
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 EnhancementsLessons
*
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 EnhancementsLessons
*
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 EnhancementsLessons
*
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 EnhancementsLessons
*
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 EnhancementsLessons
*
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.
Download
http://www.filesonic.com/file/940786154/UpdatingYourSQLServer2005SkillstoSQLServer2008.part01.rar
http://www.filesonic.com/file/940786164/UpdatingYourSQLServer2005SkillstoSQLServer2008.part02.rar
http://www.filesonic.com/file/941052884/UpdatingYourSQLServer2005SkillstoSQLServer2008.part03.rar
http://www.filesonic.com/file/941052524/UpdatingYourSQLServer2005SkillstoSQLServer2008.part04.rar
http://www.filesonic.com/file/941052824/UpdatingYourSQLServer2005SkillstoSQLServer2008.part05.rar
http://www.filesonic.com/file/941057674/UpdatingYourSQLServer2005SkillstoSQLServer2008.part06.rar
http://www.filesonic.com/file/941057644/UpdatingYourSQLServer2005SkillstoSQLServer2008.part07.rar
http://www.filesonic.com/file/941063554/UpdatingYourSQLServer2005SkillstoSQLServer2008.part08.rar
http://www.filesonic.com/file/941063534/UpdatingYourSQLServer2005SkillstoSQLServer2008.part09.rar
http://www.filesonic.com/file/941063664/UpdatingYourSQLServer2005SkillstoSQLServer2008.part10.rar
http://www.filesonic.com/file/941063744/UpdatingYourSQLServer2005SkillstoSQLServer2008.part11.rar
http://www.filesonic.com/file/941068414/UpdatingYourSQLServer2005SkillstoSQLServer2008.part12.rar
http://www.filesonic.com/file/941068464/UpdatingYourSQLServer2005SkillstoSQLServer2008.part13.rar
http://www.filesonic.com/file/941068604/UpdatingYourSQLServer2005SkillstoSQLServer2008.part14.rar
http://www.filesonic.com/file/941072494/UpdatingYourSQLServer2005SkillstoSQLServer2008.part15.rar
http://www.filesonic.com/file/941072614/UpdatingYourSQLServer2005SkillstoSQLServer2008.part16.rar
http://www.filesonic.com/file/941072724/UpdatingYourSQLServer2005SkillstoSQLServer2008.part17.rar
http://www.filesonic.com/file/941078604/UpdatingYourSQLServer2005SkillstoSQLServer2008.part18.rar
http://www.filesonic.com/file/941078664/UpdatingYourSQLServer2005SkillstoSQLServer2008.part19.rar
http://www.filesonic.com/file/941078814/UpdatingYourSQLServer2005SkillstoSQLServer2008.part20.rar
http://www.filesonic.com/file/941084324/UpdatingYourSQLServer2005SkillstoSQLServer2008.part21.rar
http://www.filesonic.com/file/941084384/UpdatingYourSQLServer2005SkillstoSQLServer2008.part22.rar
http://www.filesonic.com/file/941092174/UpdatingYourSQLServer2005SkillstoSQLServer2008.part23.rar
http://www.filesonic.com/file/941092384/UpdatingYourSQLServer2005SkillstoSQLServer2008.part24.rar
http://www.filesonic.com/file/941092424/UpdatingYourSQLServer2005SkillstoSQLServer2008.part25.rar
http://www.filesonic.com/file/941092444/UpdatingYourSQLServer2005SkillstoSQLServer2008.part26.rar
