Every registration supports local education. TrainUp Gives Back

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
  • calendar Image 6-12 Months
    To Complete


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.

Learning Objectives
  • 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
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.