Course Details

Previous Page


Microsoft SQL Server 2012: Instance Configuration and Database Creation


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number



Overview/Description
SQL Server 2012's core component is its Database Engine instance, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. SQL Server 2012 also provides additional features and components to manage and view data, these include Analysis Services and Reporting Services.SQL Server 2012 provides tools to manage the features and components which includes Server Management Studio’s graphical user tool which allows administrators and developers to create and configure instances and databases on an enterprise level, SQL Server Configuration Manager for managing SQL Server services and protocols, and Reporting Services Configuration Manager to configure Reporting Services. This course demonstrates how to add additional features and components to an installation of SQL Server 2012, how to configure and manage an instance, and how to configure Reporting Services. This course also discusses the database architecture and how to create and configure a database. 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.0

Lesson Objectives

Microsoft SQL Server 2012: Instance Configuration and Database Creation

  • use Configuration Manager to manage SQL Server 2012 services
  • recognize the steps involved in configuring a Windows Firewall for Database Engine Access
  • recognize the functions of the different pages in the Server Properties dialog box
  • describe how to add features and components to a SQL Server 2012 installation
  • configure Reporting Services using Reporting Services Configuration Manager
  • identify how Reporting Services can work with SharePoint
  • enable SQL Server features
  • perform configuration tasks on SQL Server 2012 instances
  • describe the characteristics of databases and their architecture
  • match the database type to its description
  • create a database
  • change database options
  • identify the features of databases
  • use a variety of methods to create databases and alter their preferences
  • Course Number:
    md_msdb_a02_it_enus