SQL Server^® 2008 Database Administration: Hands-On

What is this course about?

SQL Server 2008 provides a robust platform that enables organizations to run their most demanding, mission-critical applications. It is essential that database administrators know how to manage this complex platform correctly. This hands-on course provides you with the skills you need to install SQL Server, create and modify storage structures, manage security, and back up and recover databases.

What will I learn in this course?

In this course, you gain extensive experience using SQL Server 2008 tools to perform real-world administrative tasks with SQL Server Management Studio and Transact-SQL. You learn to install SQL Server, create and modify data structures, back up and recover databases, implement login and database security, and manage permissions.

Who will benefit from this course?

This course is designed for those new to SQL Server who have not had prior training or experience in administration. This course is valuable for those whose work involves, or will involve, the administration of a SQL Server 2008 database. Typical participants include database administrators, system administrators, and application and system developers. The jobs performed by both a system administrator (primarily the custodian of resources and responsible for tuning) and a database administrator (usually responsible for security, backup and recovery, and task scheduling) are covered in-depth.

What background do I need?

It is assumed that you have relational database experience at the level of Course 137: SQL Server^® 2008: A Comprehensive Hands-On Introduction, along with a working knowledge of computers and a familiarity with Windows, or Course 960: Windows Server^® 2008: A Comprehensive Hands-On Introduction. Programming experience is helpful but not required.

I am a SQL Server 6.x administrator. My organization is migrating to SQL Server 2008. Is this course valuable to me?

Yes! There are significant differences between SQL Server 6.x and SQL Server 2008.

This course, in conjunction with Course 137: SQL Server^® 2008: A Comprehensive Hands-On Introduction, provides invaluable knowledge and experience with the enhanced administrative environment of SQL Server 2008.

My organization is planning to run SQL Server 2008 on Windows 2008. Will I still benefit from this course?

Absolutely! The underlying operating system makes little difference in the role of a database administrator.

This course provides you with the skills necessary to administer SQL Server 2008 on either Windows 2003 or Windows Server 2008.

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

Does this course cover SQL Server 2012?

No, this course solely focuses on SQL Server 2008. For coverage on SQL Server 2012 database administration, please see Course 2108: SQL Server^® 2012 Database Administration: Hands-On.

Does this course cover the components in Microsoft's Business Intelligence platform?

The focus of this course is on SQL Server 2008 database administration. For more information on BI components, please refer to Course 146: Introduction to Microsoft^® Tools for Business Intelligence: Hands-On. For more information on Analysis Services, see Course 139: SQL Server^® Analysis Services: Hands-On. For Integration Services, see Course 134: SQL Server^® Integration Services: Hands-On, and for additional information on Reporting Services, see Course 140: SQL Server^® 2008 Reporting Services: Hands-On.

How much time is spent on each topic?

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

Numerous hands-on exercises performing basic and advanced database administration tasks are conducted during the course, accounting for 40 percent of class time. These exercises are intended to reinforce the concepts taught in class and provide you with a real-world experience with SQL Server. They include installing SQL Server 2008, managing storage, back up and recovery of system and user databases, managing security, scheduling multi-step jobs, setting up alerts, performing routine maintenance, and monitoring SQL Server.

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. You may be interested in these related courses:

• 532: SQL Server Transact-SQL® Programming: Hands-On 
• 141: SQL Server® High Availability: Hands-On 
• 535: Developing High-Performance SQL Server® Databases: Hands-On 

• 134: SQL Server® Integration Services: Hands-On 
• 296: Project Management: Skills for Success 
• 960: Windows Server® 2008: A Comprehensive Hands-On Introduction 

US Dates