Microsoft SQL Server 2012: Installation and Upgrade

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

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
150 minutes

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.

Objective

Installing SQL Server 2012

  • 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

Upgrading to 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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.