Course 6158C Updating Your SQL Server 2005 Skills to SQL Server 2008
English | AVI | XVID 300 kbps 25 fps | 384x288 | MP3 64 kbps 44 KHz | 3.1 GB
Genre: elearning
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
This course is intended for experienced SQL Server
2005 developers and database administrators who want to upgrade their
skills to SQL Server 2008.
Course Completion Skills:
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
Labs
Lab : Exploring SQL Server Books Online
Reviewing the SQL Server Books Online Tutorials
Reviewing SQL Server Books Online
After Completing This Goal, 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
Labs
Lab : Managing SQL Server 2008
Creating a Configuration Server
Creating and Applying a Policy
After Completing This Goal, 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
Labs
Lab : Optimizing SQL Server 2008
Using Resource Governor
Using the Data Collector
After Completing This Goal, 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
Labs
Lab : Securing a SQL Server 2008 Database
Using Transparent Data Encryption
After Completing This Goal, 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
Labs
Lab : Developing Databases with SQL Server 2008
Using Date and Time Data Types
Using Spatial Data
After Completing This Goal, 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
Labs
Lab : Maintaining High Availability
Configuring Peer-to-Peer Replication
Adding a Replication Node
After Completing This Goal, 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
Labs
Lab : Data Warehousing with SQL Server 2008
Using Change Data Capture
Using the MERGE Statement
Working with Partitioned Data
After Completing This Goal, 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
Labs
Lab : Using SQL Server 2008 Reporting Services
Creating a Report with Report Designer
Managing Reporting Services
After Completing This Goal, 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
Labs
Lab : Using SQL Server 2008 Analysis Services
Implementing Multidimensional Analysis
Implementing Data Mining
After Completing This Goal, Students will be Able To
Implement multidimensional analysis.
Implement data mining.
For USA, EU, Japan, Sing, Au, Ru, UAE, GE, CA, SA.
