6158C Updating Your SQL Server 2005 Skills to SQL Server 2008
Curso
Online
Preço para verificar
Descrição
-
Tipologia
Curso
-
Metodologia
Online
A ter em conta
Before attending this course, students must have experience developing or administering SQL Server 2005 databases.
Opiniões
Você fez este curso?
Programa
Pré-requisitos:
Before attending this course, students must have experience developing or administering SQL Server 2005 databases.
Module 1: Introduction to SQL Server 2008
Lessons
· 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
Module 2: SQL Server 2008 Manageability Enhancements
Lessons
· Configuration Servers
· Policy-Based Management
Lab : Managing SQL Server 2008
· Creating a Configuration Server
· Creating and Applying a Policy
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 : Optimizing SQL Server 2008
· Using Resource Governor
· Using the Data Collector
Module 4: SQL Server 2008 Security Enhancements
Lessons
· Encrypting Databases
· Auditing All Actions
Lab : Securing a SQL Server 2008 Database
· Using Transparent Data Encryption
Module 5: SQL Server 2008 Database Development Enhancements
Lessons
· 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
Module 6: SQL Server 2008 Availability Enhancements
Lessons
· Always On Technologies
· Transactional Peer-to-Peer Replication
Lab : Maintaining High Availability
· Configuring Peer-to-Peer Replication
· Adding a Replication Node
Module 7: SQL Server 2008 Data Warehousing Enhancements
Lessons
· 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
Module 8: SQL Server 2008 Reporting Services Enhancements
Lessons
· 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
Module 9: SQL Server 2008 Analysis Services Enhancements
Lessons
· 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
Before attending this course, students must have experience developing or administering SQL Server 2005 databases.
Module 1: Introduction to SQL Server 2008
Lessons
· 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
Module 2: SQL Server 2008 Manageability Enhancements
Lessons
· Configuration Servers
· Policy-Based Management
Lab : Managing SQL Server 2008
· Creating a Configuration Server
· Creating and Applying a Policy
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 : Optimizing SQL Server 2008
· Using Resource Governor
· Using the Data Collector
Module 4: SQL Server 2008 Security Enhancements
Lessons
· Encrypting Databases
· Auditing All Actions
Lab : Securing a SQL Server 2008 Database
· Using Transparent Data Encryption
Module 5: SQL Server 2008 Database Development Enhancements
Lessons
· 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
Module 6: SQL Server 2008 Availability Enhancements
Lessons
· Always On Technologies
· Transactional Peer-to-Peer Replication
Lab : Maintaining High Availability
· Configuring Peer-to-Peer Replication
· Adding a Replication Node
Module 7: SQL Server 2008 Data Warehousing Enhancements
Lessons
· 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
Module 8: SQL Server 2008 Reporting Services Enhancements
Lessons
· 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
Module 9: SQL Server 2008 Analysis Services Enhancements
Lessons
· 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
6158C Updating Your SQL Server 2005 Skills to SQL Server 2008
Preço para verificar