Upgrading Your SQL Server 2000 Database Administration Skills to

							Upgrading Your SQL Server 2000 Database Administration Skills to SQL Server 2008
COMPUTER TRAINING
The key to a better future
At the end of the course the delegate will be able to complete the following:

An Introduction to SQL Server 2008

Skills:

SQL SERVER
Course No. 6317

 This module will help students to understand
the new features and overall architecture of SQL Server 2008.  The Evolution of SQL Server  SQL Server 2008 Architectural Components

 Gain exposure to new administration tools.  Use SQL Server Management Studio to  Use the sqlcmd utility to execute Transact-SQL  Use the Windows PowerShell provider for SQL
Server. from the command prompt. manage databases.

3 Days
Target Audience:
This course provides students with the knowledge and skills to upgrade their SQL Server 2000 database administration (DBA) skills to SQL Server 2008 DBA skills. It is intended for information technology (IT) professionals who administer and maintain SQL Server databases.

Skills:

 Describe the evolution of SQL Server.  Describe the overall architecture of SQL Server
2008.

Security Enhancements with SQL Server 2008
 This module will help students to understand      
enhancements and additions to SQL Server 2008 Security. SQL Server 2008 Security Overview Managing SQL Server 2008 Security Managing Permissions Managing Keys and Certificates Data Encryption Lab: Securing a SQL Server 2008 Database

Installing and Upgrading to SQL Server 2008
     

 This module will help students to understand
how to plan for a SQL Server 2008 installation, upgrade, and migration. Preparing for SQL Server 2008 Installation Installing SQL Server 2008 Upgrading a SQL Server 2000 Instance Configuring a SQL Server Installation Using SQL Server Configuration Manager Lab: Upgrading SQL Server 2000 to 2008

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

Skills:

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

Skills:

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

Purpose:
After completing this course, students will be able to describe the new features of SQL Server 2008; plan for a SQL Server 2008 installation, upgrade, and migration; understand SQL Server data types; manage SQL Server 2008; secure a SQL Server 2008 database; 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; monitor database activity; monitor and manage database performance.

SQL Server 2008 Disaster Recovery
 This module will teach student how to         
prepare for and recover from potential database disasters. Database Backup Backup Compression Database Restoration Database Snapshots Lab: SQL Server 2008 Disaster Recovery Backup a database. Implement backup compression. Restore databases and transaction logs. Use Database Snapshot to backup and restore data.

Storage Enhancements in SQL Server 2008
        

 This module will teach students about changes
to data storage, including data types, indexes, and partitions in SQL Server 2008. Data Type Enhancements Table Partitioning Indexing Enhancements Tuning Indexes (Optional) Lab: Optimizing SQL Server 2008 Understand SQL Server data types. Understand table partitioning. Create and manipulate indexes. Tune indexes.

Skills:

Skills:

High Availability in SQL Server 2008
   

 This module will teach students how to
maintain availability to their SQL Server data even through server downtime. Log Shipping Database Mirroring Determining the Best High Availability Solution Lab: SQL Server 2008 High Availability

SQL Server 2008 Administration Enhancements
    

 This module will help students to understand
administration tools that are new or enhanced with SQL Server 2008. Administration Tools Overview Using SQL Server Management Studio Using the sqlcmd Utility Using Windows PowerShell Lab: Administrating SQL Server 2008

Skills:

 Use Log Shipping to ensure high availability.  Use database mirroring to ensure high  Determine the best high availability solution.
availability.

Replication Enhancements in SQL Server 2008
the replication enhancements in SQL Server 2008.  New Types of Replication  Additional Replication Enhancements  Lab: Implementing Replication

 This module helps students to take advantage of

Skills:

 Understand the new types of replication  Understand other replication enhancements in
SQL Server 2008. available in SQL Server 2008.

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: Using Policy-Based Management

F1 COMPUTER TRAINING SERVICES
THE KEY TO A BETTER FUTURE

Skills:

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

SQL Server 2008 Monitoring Enhancements
         
2008 monitoring features. Monitoring a Database Using DDL Triggers Auditing in SQL Server Event Notifications Using Static and Dynamic Metadata Lab: Monitoring SQL Server 2008

for further information…

 This module helps students to use SQL Server

0800 169 1890
F1 COMPUTING SYSTEMS LTD
3 Kelso Place Upper Bristol Road BATH BA1 3AU

call us on

Skills:
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.

Fax: 01225 444728 training@f1comp.co.uk

SQL Server 2008 Performance
   

 This module helps students to take advantage of
the performance enhancements in SQL Server 2008. Managing Workloads with Resource Governor Monitoring Performance with the Data Collector Managing Performance with Plan Freezing Lab: Managing SQL Server Performance

www.f1comp.co.uk
LONDON BATH OR ONSITE

Skills:

 Manage workloads with Resource Governor.  Monitor performance with the Data Collector.  Manage performance with Plan Freezing.

PARTICULARS
Cost: £1050 plus VAT Platform:
Windows

Numbers:
Maximum of 6 people on each course at F1’s training facilities in London and Bath