Overview of Microsoft SQL Server 2008 for Existing SQL Server Users
Short course
In Bath and London
Description
-
Type
Short course
-
Location
-
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
Start date
Start date
About this course
Before attending this course, students must have the following pre-requisites:Experience developing or administering SQL Server databases.
Reviews
Course programme
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
- An Introduction to SQL Server 2008
- Upgrading to SQL Server 2008
- SQL Server 2008 Management Studio
- New Data Types in SQL Server 2008
- Table Partitioning
- Database Snapshots
- Database Mirroring
- SQL Server 2008 Policy-Based Management
- DDL Triggers in SQL Server 2008
- SQL Server 2008 Resource Governor
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- ..
- ..
Overview of Microsoft SQL Server 2008 for Existing SQL Server Users