SQL Server 2008 Database Administration: Hands-On

Frequently Asked Questions

What is this course about? 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 at the level of Course 595, Windows Server® 2003: A Comprehensive Hands-On Introduction, or Course 960, Windows Server® 2008: A Comprehensive Hands-On Introduction. Programming experience is helpful but not required. I have taken Course 132, SQL Server® 2005 Database Administration: Hands-On. Should I take this course? No. Course 132 covers many of the same fundamental elements of database administration that this course covers. Those with a background in SQL Server 2005 administration should take Course 136, SQL Server® 2008 Skills Upgrade: Hands-On instead. 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. 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. 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. What platform is used for the hands-on exercises? This course uses Microsoft SQL Server 2008 running on Windows Server 2003. In addition, there is a domain controller running Windows Server 2003. How much time is spent on each topic? Content Hours SQL Server 2008 installation and new features 2.5 Creating and managing databases 3.5 Implementing server and database security 4.5 Migrating data 2.5 Recovering from disasters 2.5 Automating tasks with jobs and alerts 2.5 Performing database maintenance 2.5 Monitoring SQL Server 2.5 Times, including the workshops, are estimates; exact times may vary according to the needs of each class. 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. Why should I take this course instead of one offered by Microsoft? Learning Tree is dedicated to accelerating the careers of our clients by providing them with world-class technology and management training. Our independence from Microsoft (and every 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. 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. The portion of the SQL Server 2008 curriculum related to this course includes: 137, SQL Server® 2008: A Comprehensive Hands-On Introduction  532, SQL Server Transact-SQL® Programming: Hands-On  Other courses of interest include: 595, Windows Server® 2003: A Comprehensive Hands-On Introduction  134, SQL Server® 2005 Integration Services: Hands-On  296, Project Management: Skills for Success  960, Windows Server® 2008: A Comprehensive Hands-On Introduction

SQL Server 2008 is a registered trademark of Microsoft Corporation.