Course Details

Previous Page

Microsoft SQL Server 2012: Installation and Upgrade

Target Audience
Expected Duration
Lesson Objectives
Course Number

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)

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
  • migrate a databases to a new server
  • migrate to SQL Server 2012
  • Course Number: