Course 10151: Installing and Configuring Microsoft SQL Server 2008

Introduction This two-hour course provides you with the skills and knowledge required for preparing for an installation of SQL Server 2008 and its components. In this course, you will learn about the pre-installation checks that you should perform before installing SQL Server 2008. You will also learn to verify the installation and configure SQL Server 2008.

Topics covered in this course include:

• Preparing to Install Microsoft SQL Server 2008
• Installing SQL Server 2008
• Managing an SQL Server 2008 Installation
• Working with SQL Server 2008 Applications

Student prerequisites:

To benefit from this course, the learner must be familiar with using Microsoft Windows. They must have knowledge of basic relational database concepts and querying data by using Transact-SQL. They must be familiar with the role of a database administrator.
Objectives At the end of the course, students will be able to:

• Prepare to install SQL Server 2008.
• Install SQL Server 2008.
• Manage an installation of SQL Server 2008.
• Work with SQL Server 2008 applications.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Installing and Configuring Microsoft SQL Server 2008 Module Overview Preparing to Install Microsoft SQL Server 2008 Introduction SQL Server 2008 Editions SQL Server 2008 Hardware and Software Requirements Operating System Support for SQL Server 2008 Using Instances in SQL Server 2008 SQL Server 2008 Licensing Options Security Considerations Collation Settings for SQL Server 2008 Self Test Installing SQL Server 2008 Introduction SQL Server 2008 Installation Process What Is Unattended Installation? Upgrading to SQL Server 2008 Installing an Instance of SQL Server 2008 Verifying the Installation of SQL Server 2008 Self Test Managing an SQL Server 2008 Installation Introduction Methods of Managing Surface Area Configuration Using SQL Server Configuration Manager Configuring the FILESTREAM Data Access Using SQL Server Installation Center Self Test Working with SQL Server 2008 Applications Introduction Using SQL Server Management Studio Setting Server-Level Instance Properties and Options SQL Server Group Management Using SQLCMD Using Windows PowerShell to Manage SQL Server 2008 Self Test Best Practices Best Practices Lab: Installing and Configuring Microsoft SQL Server 2008 Lab Overview Scenario Exercise Information Launch the Lab Lab Review Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled