SQL Server^® 2008 Skills Upgrade:
Hands-On

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 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 132: SQL Server^® 2005 Database Administration: Hands-On or 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.

How much time is spent on each topic?

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.

Why should I take this course instead of one offered by Microsoft?

Learning Tree is dedicated to helping accelerate the careers of our clients by providing them with world-class technology and management training. Our independence from Microsoft (and any other vendor) allows us to give an unbiased view of what works and what does not. This course is objective in its approach, having been developed independently from Microsoft by industry experts who bring their real-world experience to the classroom.

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.

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.

• 139: SQL Server® Analysis Services: Hands-On 
• 134: SQL Server® Integration Services: Hands-On 
• 138: SQL Server® 2008 Database Administration: Hands-On 
• 140: SQL Server® 2008 Reporting Services: Hands-On 
• 535: Developing High-Performance SQL Server® Databases: Hands-On 
• 1501: SharePoint® 2010 Technologies: A Comprehensive Hands-On Introduction 
• 1510: Administering SharePoint® Server 2010: Hands-On 

US Dates