Microsoft SQL Server 2012: Installation and Upgrade

Overview/Description
SQL Server 2012 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, the SQL Server Database Engine, Integration Services, Analyzes Services, and Reporting Services. 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 2012 components and management tools, and outlines the requirements for installing SQL Server 2012, including the hardware, software, and security requirements. The steps required to complete a fresh installation of a SQL Server 2012 and how to upgrade a SQL Server instance are also explored. The course also addresses how to move database from an instance of SQL Server to SQL Server 2012 for a migration detach and attach methods and the Copy Database wizard. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who do not 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 among others; Database Administrators who as part of their daily task perform installation, maintenance, and configuration tasks

Expected Duration (hours)
2.5

Lesson Objectives

Microsoft SQL Server 2012: Installation and Upgrade

distinguish between SQL Server 2012 editions

describe the considerations involved in planning a SQL Server 2012

recognize how to follow pre- and post-installation security best practices

describe network security considerations for SQL Server 2012

identify how to install SQL Server 2012 using the wizard

Recognize how to install SQL Server 2012 on Server Core

prepare for a SQL Server 2012 installation

install SQL Server 2012

describe the considerations involved in preparing to upgrade to SQL Server 2012

describe how to install and run Upgrade Advisor

identify the main tasks for upgrading to SQL Server 2012