Request Info

Salutation

First Name

Last Name

Job Title

Department

Mailstop

Company

Address

P.O. Box

City

Province

Postal Code

Country
List

Work Telephone

Ext.

E-mail Address

Information provided will be used to communicate with you about our products.
Privacy Statement

A representative will contact you to follow up your request.

 
Special offer: Training Vouchers - Free Courses with purchase.

 

SQL Server® 2008 Skills Upgrade:
Hands-On

Updating Your SQL Server 2005 Skills to 2008

Course 136 • 3 Days

 E-mail E-mail a Colleague Course Details Course Details Course Details PDF Course Details PDF

Frequently Asked Questions

What is this course about?

This course provides comprehensive coverage of the new database developer and administrator features in MS SQL Server 2008 Enterprise Edition.

You learn how to use the enhanced Transact-SQL, policy-based management, transparent data encryption and Resource Governor.

You upgrade an instance from SQL Server 2005 to 2008, gain the skills needed to proactively monitor your data with CDC and pinpoint performance bottlenecks.

Finally, you take away the knowledge and skills to control your application and database servers in an enterprise with Multi-Server Management.

What skills will I gain from this course?

SQL Server 2008 Enterprise edition offers cutting-edge capabilities for database administration and development.

This skills upgrade course provides hands-on experience that ranges from coding new statements in T-SQL to managing SQL Servers with new capabilities.

Throughout this course, you learn to translate the strengths of SQL Server 2008 into improvements in your organization's data processes.

What background knowledge do I need?

To succeed in this course, you should be proficient with development or administration in a SQL Server 2005 environment or have completed Course 532: SQL Server Transact-SQL® Programming: Hands-On.

Who will benefit from this course?

Experienced SQL Server 2005 administrators and developers considering or currently migrating to SQL Server 2008 Enterprise Edition. Typical participants include:

  • Administrators
  • Analysts
  • Programmers
  • Developers
  • Designers
  • Consultants

Do I need to know the SQL language prior to attending this course?

Yes. This course assumes a basic knowledge of the SQL SELECT statement. Knowledge of the SQL INSERT, UPDATE, and DELETE statements is also required.

Which edition of SQL Server 2008 does this course feature?

This course covers many of the new features from SQL Server 2008. Many of the new features are available in the Enterprise Edition only.

What platform is used for the hands-on exercises?

This course uses Microsoft SQL Server 2008 R2 running on Windows Server 2008. In addition, there is a domain controller running Windows Server 2008.

I am migrating from SQL Server 2000 to SQL Server 2008. Is this course useful for me?

This course covers features added to SQL Server after SQL Server 2005, and a knowledge of these features will be useful. However, there were many additions to the SQL Server product in SQL Server 2005. Those are not covered in this course, so you will have to do additional study to acquaint yourself with those features.

I am a SQL Server 2000/2005 administrator and my organization is moving to SQL Server 2008. Is this course valuable to me?

Absolutely. Experienced administrators currently working in SQL Server 2000 or SQL Server 2005 will need a solid foundation in the new feature set and significant enhancements of SQL Server 2008 to ensure a successful migration. This course is designed to meet these specific needs.

How much time is spent on each topic?

ContentHours
Introducing SQL Server 2008 new features1.0
Easing development with Transact-SQL4.0
Improving data management3.0
Policy Based Management (PBM)3.5
Proactively monitoring data3.5
Data protection1.5
Boosting SQL Server performance3.5
Times, including the workshops, are estimates; exact times may vary according to the needs of each class.

What kinds of hands-on exercises are performed in this course?

Hands-on exercises account for 40 percent of class time, reinforce the concepts taught and provide you with the opportunity to explore the new features and administrative tools of SQL Server 2008. These exercises include:

  • Upgrading from SQL Server 2005 to SQL Server 2008
  • Saving storage with backup compression
  • Querying Geo-Spatial data to plot demographics
  • Configuring and using FILESTREAM
  • Setting up Resource Governor
  • Setting up CDC with Management Studio
  • Setting up Management Data Warehouse (MDW) to collect and store historical data in SQL Server
  • Setting up a Utility Management Data Warehouse (UMDW)

How does this course relate to other Learning Tree courses?

Learning Tree offers a complete SQL Server 2008 curriculum. The courses you may take depend on the role you play in your organization. Please refer to The Learning Tree SQL Server 2008 Curriculum Q&A for more details.

SQL Server 2008 is a registered trademark of Microsoft Corporation.

Learning Tree AnyWareTM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.
  
SQL Server 2008 Skills Upgrade: Hands-On

Training Dates

Live online classroom training.Most events below can be taken in-class or live, online from your home or office with AnyWare.

US Dates

May 30 - Jun 1Rockville, MD enrol
Sep 12 - 14New York enrol

For AnyWare enrolments, please register at least 7 days prior to the start of the course.

More Dates and locations.

Bring this or any Learning Tree Course on-site to your location!

Your Course Tuition
EntitlesYou to...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification