SQL Server 2008 R2: Installation

This course is included in our On-demand training solution.

Overview

SQL Server 2008 R2 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, Business Intelligence Development studio, and the SQL Server Database Engine. These tools allow administrators and developers to build and maintain software solutions, and perform required functions in a server environment. This course identifies SQL Server 2008 R2 components and management tools, and outlines the requirements for installing SQL Server 2008 R2. The steps required to complete a fresh installation of a SQL Server 2008 R2 instance and how to upgrade a SQL Server instance are also explored. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.

Target Audience

Professionals typically pursuing a career as a Database Administrator; individuals who don’t work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.

Prerequisites

One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server

Expected Duration

90 min.

Course Objectives

SQL Server 2008 R2 Introduction

  • recognize how SQL Server 2008 R2 improves business solutions
  • recognize the purpose of the various editions of SQL Server 2008 R2
  • SQL Server 2008 R2 Requirements

  • identify the requirements for installing SQL Server 2008 R2
  • recognize the considerations for installing SQL Server 2008 R2
  • SQL Server 2008 R2 Installation

  • recognize how to install a SQL Server 2008 R2 instance in a given scenario
  • Preparing to Upgrade to SQL Server 2008 R2

  • identify the requirements and considerations for upgrading an instance of SQL Server to SQL Server 2008 R2
  • Upgrading to SQL Server 2008 R2

  • recognize how to use the Upgrade Advisor to ensure component compatibility with SQL Server 2008 R2
  • recognize how to perform an upgrade to SQL Server 2008 R2
  • Performing a SQL Server 2008 R2 Installation

    SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?