A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(F1003) Visual FoxPro 6.0 Upgrade - Microsoft Training Courses in London and South West
Course:(2535) Developing Board Support Packages for Windows CE .NET - Microsoft Training Courses in London and South West
Visual FoxPro Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6430) Managing and Maintaining Windows Server 2008 Servers - Microsoft Training Courses in London and South West
Course:(F1016) Upgrading to Visual FoxPro 8.0 from Visual FoxPro 7.0 - Microsoft Training Courses in London and South West
Course:(2790) Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 - Microsoft Training Courses in London and South West
SQL Server 7 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Exchange Server 2007 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2793) Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services - Microsoft Training Courses in London and South West
Course:(8523) Microsoft CRM 3.0 Service Management - Microsoft Training Courses in London and South West
Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(F1031) Overview of Microsoft SQL Server 2008 for Existing SQL Server Users - Microsoft Training Courses in London and South West
Course:(3372) First Look: Getting Started with the 2007 Microsoft Office System Hands-On Lab - Microsoft Training Courses in London and South West
Course:(5118) Supporting Windows Vista and Applications in the Enterprise - Microsoft Training Courses in London and South West
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Course:(3369) First Look: Getting Started with Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(2095) Implementing Microsoft SharePoint Portal Server 2001 - Microsoft Training Courses in London and South West
Course:(3199) First Look: Getting Started with the 2007 Microsoft Office System - Microsoft Training Courses in London and South West
Course:(1502) Designing and Implementing a Data Warehouse Using Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Course:(6157) Whats New in SQL Server 2008 - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(50048) Enterprise Search Solution Architect Workshop - Microsoft Training Courses in London and South West
Certification Fast-Track Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(3041) First Look: Deploying Microsoft Windows Vista and the 2007 Office System Client Products - Microsoft Training Courses in London and South West
Course:(2380) Developing Collaborative Solutions using Microsoft OfficeXP Developer - Microsoft Training Courses in London and South West
Course:(1631) Developing Windows CE Embedded Solutions - Microsoft Training Courses in London and South West
Course:(2282) Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure - Microsoft Training Courses in London and South West
Course:(2782) Designing Microsoft SQL Server 2005 Databases - Microsoft Training Courses in London and South West
Course:(50064) Advanced Microsoft Office SharePoint 2007 Development - Microsoft Training Courses in London and South West
Course:(2011) Troubleshooting Microsoft Exchange Server 2003 - Microsoft Training Courses in London and South West
Course:(4007) Creating Effective Presentations Using Microsoft Office PowerPoint 2003 - Microsoft Training Courses in London and South West
Course:(2072) Administering a Microsoft SQL Server 2000 Database - Microsoft Training Courses in London and South West
Course:(2099) Building Distributed Applications with COM+ Services and Microsoft Visual C++ - Microsoft Training Courses in London and South West
Course:(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(50047) Advanced IT Pro Course for Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses in London and South West

Compare Recently Viewed Course Dates


Customised
SQL Server 2008

Overview of Microsoft SQL Server 2008 for Existing SQL Server Users
(Microsoft Training Course: F1031) - 1 day - £435 exc VAT

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> 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.
> 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 Information 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
> 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.
> Supplementary Information
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.
> EXAMS
There are no exams directly associated with this course