|
|
|
Frequently Asked Questions
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?| Content | Hours | | SQL Server 2008 installation and new features | 3.0 | | Creating and managing databases | 3.5 | | Implementing server and database security | 4.5 | | Recovering from disasters | 4.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.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:
|
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.
|
|
Training Dates
 | Most events below can be taken in-class or live, online from your home or office with AnyWare. |
For AnyWare enrollments, please register at least 7 days prior to the start of the course.
More Dates and Locations.
Tuition for Course 138 (4 Days)
Bring this or any Learning Tree Course on-site to your location!
Your Course Tuition
Entitles You 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
- FREE participation in College Credit programs (including related exams)
|
E-mail a Colleague
Course Details
Course Details PDF