Updating Your SQL Server 2000 Skills to SQL Server 2008

Infos Générales Public visé : This course is intended for experienced SQL Server 2000 developers and database administrators who want to upgrade their skills to SQL Server 2008. Objectifs : 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. Use SQL Server 2008 Integration Services. Prérequis : Before attending this course, students must have experience developing or administering SQL Server 2000 databases

Références MS6317 Vos contacts Christelle et Caroline au 04.92.27.02.24 Formateur MCDBA Support Microsoft Officiel

---

Accès rapides

---

Plan détaillé

An Introduction to SQL Server 2008

• The Evolution of SQL Server
• SQL Server 2008 Architectural Enhancements

Installing and Upgrading to SQL Server 2008

• Preparing for SQL Server 2008 Installation
• Installing SQL Server 2008
• Upgrading a SQL Server 2000 Instance
• Configuring a SQL Server Installation
• Using SQL Configuration Manager

Storage Enhancements in SQL Server 2008

• Data Types
• Table Partitioning
• Indexing Enhancements
• Tuning Indexes

SQL Server 2008 Administration Enhancements

• Administration Tools Overview
• Using SQL Server Management Studio
• Using the sqlcmd Utility
• Using the SQL Management Objects
• Using Windows PowerShell

Security Enhancements with SQL Server 2008

• SQL Server 2008 Security Overview
• Managing SQL Server 2008 Security
• Managing Permissions
• Managing Keys and Certificates
• Data Encryption

SQL Server 2008 Disaster Recovery

• Database Backup
• Backup Compression
• Database Restoration
• Database Snapshots

High Availability in SQL Server 2008

• Log Shipping
• Database Mirroring
• Determining the Best High Availability Solution

Replication Enhancements in Microsoft SQL Server 2008

• New Types of Replication
• Additional Replication Enhancements

SQL Server 2008 Policy Based Management

• Understanding Central Management Servers
• Understanding Policy-Based Management
• Implementing Policy Based Management

SQL Server 2008 Monitoring Enhancements

• Monitoring a Database
• Using DDL Triggers
• SQL Server Audit
• Event Notifications
• Using Static and Dynamic Metadata

SQL Server 2008 Performance

• Managing Workloads with Resource Governor
• Monitoring Performance with the Data Collector
• Managing Performance with Plan Freezing

SQL Server 2008 Database Development Enhancements

• Developer Tool Enhancements
• Working with Enhanced Data Types
• Working with XML Data
• Additional Enhancements

SQL Server 2008 Data Warehousing

• Business Intelligence Development Studio
• SQL Server Integration Services (SSIS)
• ETL Enhancements
• Query Performance Enhancements

SQL Server 2008 Reporting Services Enhancements

• Reporting Services Architecture and Management
• Authoring Reports
• Report Processing and Rendering

SQL Server 2008 Analysis Services Enhancements

• Multidimensional Analysis with SQL Server Analysis Services
• Data Mining with SQL Server Analysis Services
• Creating a Data Mining Solution

634d7268-b8af-4457-b215-a2d9f7293404

6317