SQL Server 2008 R2: Instance and Database Configuration


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
SQL Server 2008 R2's core component is its Database Engine, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. Another feature of SQL Server 2008 R2 is the SQL Server Management Studio graphical user tool which allows administrators and developers to create and configure instances and databases on an enterprise level. SQL Server 2008 R2 also includes the SQL Server Configuration Manager for managing SQL Server services, SQL Server network configuration, and SQL Native Client. This course addresses how to configure a SQL Server instance and how to create a new database using SQL Server Management Studio and SQL Server Configuration Manager. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.

Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who don't 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.

Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2 or two to three years of experience using a previous version of SQL Server

Expected Duration (hours)
2.0

Lesson Objectives

SQL Server 2008 R2: Instance and Database Configuration

  • recognize how to configure services using SQL Server Configuration Manager
  • recognize how to configure a SQL Server 2008 R2 instance using sp_configure
  • recognize how to configure SQL Server 2008 R2 features using surface area configuration
  • recognize the features of Database Mail
  • recognize how to set up Database Mail
  • create a Master Data Services database
  • create and associate a Master Data Manager web application in a new web site
  • enable Master Data Services
  • recognize how the SQL Server 2008 R2 database architecture is structured
  • recognize how to create a database in SQL Server Management Studio
  • configure a SQL Server 2008 R2 instance and create a database
  • Course Number:
    md_mcir_a02_it_enus