SQL Server 2008

This course provides students with an introduction to the features and benefits of SQL Server 2008. It is intended for information technology (IT) professionals who administer and maintain SQL Server databases.

1. An Introduction to SQL Server 2008
2. Upgrading to SQL Server 2008
3. SQL Server 2008 Management Studio
4. New Data Types in SQL Server 2008
5. Table Partitioning
6. Database Snapshots
7. Database Mirroring
8. SQL Server 2008 Policy-Based Management
9. DDL Triggers in SQL Server 2008
10. SQL Server 2008 Resource Governor

---

Supplementary Information When you attend this special F1 course, you will not only receive a Microsoft manual with additional content but also a fully-licensed copy of SQL Server 2008 Standard Edition with 1 CAL (while supplies last). Get this course FREE when you pay with your Software Assurance Training Vouchers! PLEASE CALL 0800 169 1890 FOR ADDITIONAL DATE AVAILABILITY FOR THIS COURSE.

---

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.
• SQL Server 2008 Database Engine
• SQL Server 2008 Reporting Services
• SQL Server 2008 Analysis Services
• SQL Server 2008 Integration Services
• SQL Server 2008 Service Broker and Replication

Skills

• Describe the overall architecture of SQL Server 2008.
  

top

---

Module 2: Upgrading to SQL Server 2008

• This module will help students to understand how to plan for a SQL Server 2008 upgrade.
• Upgrading a SQL Server 2000 Instance
• Lab: Analyze a SQL Server Instance for Potential Upgrade Problems.

Skills

• Explain how to prepare the hardware and other resources necessary to install SQL Server 2008.
  
• Upgrade to SQL Server 2008.
  
• Use Upgrade Advisor.
  
• Understand the difference between in-place and side-by-side installations.
  

top

---

Module 3: SQL Server 2008 Management Studio

• This module will help students to understand administration tools that are new or enhanced with SQL Server 2008.
• Overview of SQL Server Management Studio
• Using SQL Server Management Studio
• Executing Transact-SQL Queries

Skills

• Use SQL Server Management Studio to manage databases.
  
• Create a SQL Server Management Studio Solution.
  

top

---

Module 4: New Data Types in SQL Server 2008

• This module will teach students about the changes to data types in SQL Server 2008 and the new data types that have been introduced.
• Data Type Enhancements
• New Data Types

Skills

• Understand SQL Server data types.
  

top

---

Module 5: Table Partitioning

• This module will help students to understand the benefits of SQL Server 2008 Partitioning.
• Partitioning Overview
• Performance and Scalability
• Processing Queries
• Lab: Partitioning SQL Server 2008 Tables

Skills

• Customise the data storage structure.
  
• Optimise query performance.
  

top

---

Module 6: Database Snapshots

• This module will teach students about database snapshots and how they can be used in database recovery.
• Creating a Database Snapshot
• Restoring from a Database Snapshot
• Lab: Creating the Database Snapshot

Skills

• Understand the benefits and limitations of Database Snapshot.
  
• Create a Database Snapshot.
  
• Use Database Snapshot to restore data.
  

top

---

Module 7: Database Mirroring

• This module will teach students how database mirroring maintains availability to their SQL Server data even through server downtime.
• States of Database Mirroring
• Mirror Monitoring
• Operating Modes
• Enhancements to Database Mirroring in SQL Server 2008

Skills

• Configure database mirroring.
  
• Use database mirroring to ensure high availability.
  

top

---

Module 8: SQL Server 2008 Policy-Based Management

• This module introduces students to new SQL Server 2008 policy-based management features.
• Understanding Central Management Servers
• Understanding Policy-Based Management
• Implementing Policy-Based Management
• Lab: Creating and Applying a Policy

Skills

• Understand Central Management Servers.
  
• Understand Policy-Based Management.
  
• Implement Policy-Based Management.
  

top

---

Module 9: DDL Triggers in SQL Server 2008

• This module helps students to use DDL triggers to monitor SQL Server 2008.
• Creating DDL Triggers
• Managing DDL Triggers

Skills

• Create DDL triggers to monitor the database.
  
• Use DDL triggers to respond to DDL events.
  

top

---

Module 10: SQL Server 2008 Resource Governor

• This module helps students to take advantage of the performance enhancements in SQL Server 2008.
• Components of Resource Governor
• Managing Workloads with Resource Governor

Skills

• Understand the Business Problems Addressed by Resource Governor.
  
• Manage workloads with Resource Governor.
  

top

---

Before attending this course, students must have the following pre-requisites:

• Experience developing or administering SQL Server databases.

After completing this course, students will be able to describe the new features of SQL Server 2008; plan for a SQL Server 2008 upgrade; understand SQL Server data types; manage SQL Server 2008; prepare for and recover from potential database disasters; maintain availability to their SQL Server data even through server downtime; configure replication of SQL Server 2008 databases; implement policy-based management and manage database performance.

When you attend this special F1 course, you will not only receive a Microsoft manual with additional content but also a fully-licensed copy of SQL Server 2008 Standard Edition with 1 CAL (while supplies last). Get this course FREE when you pay with your Software Assurance Training Vouchers! PLEASE CALL 0800 169 1890 FOR ADDITIONAL DATE AVAILABILITY FOR THIS COURSE.