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