Updating Your SQL Server 2005 Skills to SQL Server 2008
Five days • Instructor-led & Virtual Training
|
Type |
Location |
Start Date
Every Month |
Fees |
Material |
Placement Assistance |
Job Reference |
Project (Real-Life) |
Registration |
|
Instructor-Led |
Bellevue - WA |
2nd and 4th Monday of every month |
$1199.00 |
Provided |
Provided |
Provided |
Provided |
|
|
|
|
Virtual Training |
Online |
Open |
$399.00 |
Provided |
Provided |
Provided |
Provided |
|
Competitive Advantage Download the Curriculum
Elements of this syllabus are subject to change.
This is a 1 week instructor-led course that provides students with knowledge and skills to Upgrade their skills from SQL Server 2005 to SQL Server 2008. This course covers Managing, Optimizing, Securing, Developing, Creating and maintaining Highly Available servers, Create and Use SQL Server 2008 Data Warehouse, Reporting Services and Analysis Services.
This training prepares students for certification exam 70-453
Audience
This training is designed to help DBA’s, Developers, SQL Server Support staff and IT Professionals working with SQL Server. This is also applicable for individuals planning on upgrading their skills form an older version of SQL Server to SQL Server 2008.
|
Module 1: Introduction to SQL Server 2008
ü The Evolution of SQL Server
ü Preparing for SQL Server 2008
|
|
Module 2: SQL Server 2008 Manageability Enhancements
ü Configuration Servers
ü Policy-Based Management |
|
Module 3: SQL Server 2008 Performance Enhancements
ü Managing Workloads with Resource Governor
ü Monitoring Performance with the Data Collector
ü Managing Performance with Plan Freezing |
|
Module 4: SQL Server 2008 Security Enhancements
ü Encrypting Databases
ü Auditing All Actions |
|
Module 5: SQL Server 2008 Database Development Enhancements
ü Developer Tool Enhancements
ü Data Type Enhancements
ü Working with Spatial Data |
|
Module 6: SQL Server 2008 Availability Enhancements
ü Always On Technologies
ü Transactional Peer-to-Peer Replication |
|
Module 7: SQL Server 2008 Data Warehousing Enhancements
ü ETL Enhancements
ü Using Partitioned Tables
ü Optimizing Data Storage |
|
Module 8: SQL Server 2008 Reporting Services Enhancements
ü Reporting Services Architecture and Management
ü Authoring Reports
ü Report Processing and Rendering |
|
Module 9: SQL Server 2008 Analysis Services Enhancements
ü Multidimensional Analysis with SQL Server Analysis Services
ü Data Mining with SQL Server Analysis Services |