Font size:

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
Register Now
Microsoft SQL Server 2012: Installation and Upgrade Online course
  • Course ID:
  • Duration:
    150 minutes
  • Price: