Overview of Microsoft SQL Server 2008 for Existing SQL Server Users

Short course

In Bath and London

£ 149 + VAT

Description

  • Duration

    1 Day

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. Suitable for: 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.

Facilities

Location

Start date

Bath (Somerset)
3 Kelso Place, Upper Bristol Road, BA1 3AU

Start date

On request
London
See map
Valiant House, 4-10 Heneage Lane, EC3A 5DQ

Start date

On request

About this course

Before attending this course, students must have the following pre-requisites:Experience developing or administering SQL Server databases.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Target Audience
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.

Pre-Requisites
Before attending this course, students must have the following pre-requisites:Experience developing or administering SQL Server databases.

Purpose
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.

Course outline
  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 InformationWhen 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
  • Describe the overall architecture of SQL Server 2008.
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.
  • 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.
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
  • Use SQL Server Management Studio to manage databases.
  • Create a SQL Server Management Studio Solution.
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
  • Understand SQL Server data types.
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
  • Customise the data storage structure.
  • Optimise query performance.
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
  • Understand the benefits and limitations of Database Snapshot.
  • Create a Database Snapshot.
  • Use Database Snapshot to restore data.
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
  • Configure database mirroring.
  • Use database mirroring to ensure high availability.
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
  • Understand Central Management Servers.
  • Understand Policy-Based Management.
  • Implement Policy-Based Management.
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
  • Create DDL triggers to monitor the database.
  • Use DDL triggers to respond to DDL events.
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
  • Understand the Business Problems Addressed by Resource Governor.
  • Manage workloads with Resource Governor.
Module 11:..
  • ..
  • ..

Overview of Microsoft SQL Server 2008 for Existing SQL Server Users

£ 149 + VAT