6317 - Upgrading Your SQL Server 2000 DBA Skills to SQL Server 2008 DBA Skills |
|
|---|---|
| Course Code: | 6317 |
| Course Duration: | 3 days |
| Course Price: | 2040.00 |
| Availability: | |
After completing this course students will be able to:
Module 1: An Introduction to SQL Server 2008
This module will help students to understand the new features and overall architecture of SQL Server 2008.
Lessons
• Lesson 1: The Evolution of SQL Server After completing this module students will be able to: Module 2: Installing and Upgrading to SQL Server 2008 Lessons • Lesson 1: Preparing for SQL Server 2008 Installation Lab : Upgrading SQL Server 2000 to 2008 • Exercise 1: Analyzing the SQL Server 2000 Instance After completing this module students will be able to: Module 3: Storage Enhancements in SQL Server 2008 Lessons • Lesson 1: Data Type Enhancements Lab : Optimising SQL Server 2008 • Exercise 1: Partitioning Tables • After completing this module students will be able to: Module 4: SQL Server 2008 Administration Enhancements Lessons • Lesson 1: Administration Tools Overview Lab : Administrating SQL Server 2008 • Exercise 1: Using SQL Server Management Studio After completing this module students will be able to: Module 5: Security Enhancements with SQL Server 2008 Lessons • Lesson 1: SQL Server 2008 Security Overview Lab : Securing a SQL Server 2008 Database • Exercise 1: Managing Principals After completing this module students will be able to: Module 6: SQL Server 2008 Disaster Recovery • Lesson 1: Database Backup Lab : SQL Server 2008 Disaster Recovery • Exercise 1: Making a Copy-Only Backup After completing this module students will be able to: Module 7: High Availability in SQL Server 2008 Lessons • Lesson 1: Log Shipping Lab : SQL Server 2008 High Availability • Exercise 1: Implementing Log Shipping After completing this module students will be able to: Module 8: Replication Enhancements in SQL Server 2008 Lessons • Lesson 1: New Types of Replication Lab : Implementing Replication • Exercise 1: Implementing Peer-to-Peer Transactional Replication After completing this module students will be able to: Module 9: SQL Server 2008 Policy-Based Management Lessons • Lesson 1: Understanding Central Management Servers Lab : Using Policy-Based Management • Exercise 1: Creating a Central Management Server and Server Group After completing this module students will be able to: Module 10: SQL Server 2008 Monitoring Enhancements Lessons • Lesson 1: Monitoring a Database Lab : Monitoring SQL Server 2008 • Exercise 1: Monitoring SQL Server Activity After completing this module students will be able to: Module 11: SQL Server 2008 Performance Lessons • Lesson 1: Managing Workloads with Resource Governor Lab : Managing SQL Server Performance • Exercise 1: Using Resource Governor After completing this module students will be able to:
• Lesson 2: SQL Server 2008 Architectural Components
• Describe the evolution of SQL Server
• Describe the overall architecture of SQL Server 2008
This module will help students to understand how to plan for a SQL Server 2008 installation, upgrade and migration.
• Lesson 2: Installing SQL Server 2008
• Lesson 3: Upgrading a SQL Server 2000 Instance
• Lesson 4: Configuring a SQL Server Installation
• Lesson 5: Using SQL Server Configuration Manager
• Exercise 2: Upgrading to SQL Server 2008
• Exercise 3: Validating the Upgrade
• Exercise 4: Reviewing SQL Server Books Online
• Explain how to prepare the hardware and other resources necessary to install SQL Server 2008
• Install SQL Server 2008
• Upgrade to SQL Server 2008
• Configure SQL server options with sp_configure
• Use SQL Server Configuration Manager
This module will teach students about changes to data storage, including data types, indexes and partitions in SQL Server 2008.
• Lesson 2: Table Partitioning
• Lesson 3: Indexing Enhancements
• Lesson 4: Tuning Indexes (Optional)
• Exercise 2: Using the Database Engine Tuning Advisor (Optional)
• Understand SQL Server data types
• Understand table partitioning
• Create and manipulate indexes
• Tune indexes
This module will help students to understand administration tools that are new or enhanced with SQL Server 2008.
• Lesson 2: Using SQL Server Management Studio
• Lesson 3: Using the sqlcmd Utility
• Lesson 4: Using Windows PowerShell
• Exercise 2: Using SQL Server Command-Line Management
• Exercise 3: Using PowerShell
• Gain exposure to new administration tools
• Use SQL Server Management Studio to manage databases
• Use the sqlcmd utility to execute Transact-SQL from the command prompt
• Use the Windows PowerShell provider for SQL Server
This module will help students to understand enhancements and additions to SQL Server 2008 Security.
• Lesson 2: Managing SQL Server 2008 Security
• Lesson 3: Managing Permissions
• Lesson 4: Managing Keys and Certificates
• Lesson 5: Data Encryption
• Exercise 2: Managing Securables
• Exercise 3: Managing Permissions
• Exercise 4: Configuring Column Encryption
• Exercise 5: Transparent Data Encryption
• Describe the security architecture of SQL Server 2008
• Manage securables and principals
• Manage permissions
• Use keys and certificates in SQL Server 2008
• Encrypt SQL Server data
This module will teach student how to prepare for and recover from potential database disasters
Lessons
• Lesson 2: Backup Compression
• Lesson 3: Database Restoration
• Lesson 4: Database Snapshots
• Exercise 2: Using Compression for Backup Files
• Exercise 3: Creating the Database Snapshot
• Exercise 4: Restoring From a Database Snapshot
• Backup a database
• Implement backup compression
• Restore databases and transaction logs
• Use Database Snapshot to backup and restore data
This module will teach students how to maintain availability to their SQL Server data even through server downtime.
• Lesson 2: Database Mirroring
• Lesson 3: Determining the Best High Availability Solution
• Exercise 2: Implementing Database Mirroring
• Exercise 3: Implementing Peer-to-Peer Replication
• Use Log Shipping to ensure high availability
• Use database mirroring to ensure high availability
• Determine the best high availability solution
This module helps students to take advantage of the replication enhancements in SQL Server 2008.
• Lesson 2: Additional Replication Enhancements
• Exercise 2: Implementing HTTP Replication
• Understand the new types of replication available in SQL Server 2008
• Understand other replication enhancements in SQL Server 2008
The students will be introduced to new SQL Server 2008 policy-based management features.
• Lesson 2: Understanding Policy-Based Management
• Lesson 3: Implementing Policy-Based Management
• Exercise 2: Creating and Applying a Policy
• Understand Central Management Servers
• Understand Policy-Based Management
• Implement Policy-Based Management
This module helps students to use SQL Server 2008 monitoring features.
• Lesson 2: Using DDL Triggers
• Lesson 3: Auditing in SQL Server
• Lesson 4: Event Notifications
• Lesson 5: Using Static and Dynamic Metadata
• Exercise 2: Tracing SQL Server Activity
• Exercise 3: Using DLL Triggers
• Exercise 4: Using Event Notification
• Monitor database activity
• Use DDL triggers to respond to DDL events
• Use SQL Server audit
• Use event notifications to capture database events
• Query SQL Server metadata
This module helps students to take advantage of the performance enhancements in SQL Server 2008.
• Lesson 2: Monitoring Performance with the Data Collector
• Lesson 3: Managing Performance with Plan Freezing
• Exercise 2: Using the Data Collector
• Exercise 3: Using Plan Freezing
• Manage workloads with Resource Governor
• Monitor performance with the Data Collector
• Manage performance with Plan Freezing
Before attending this course students must have:
• Experience developing or administering SQL Server 2000 databases