Configuring SQL Server 2005

This course is included in our On-demand training solution.


To configure a SQL Server instance and create a database, configure logins, users, and schemas for a database, and set up a linked server configuration

Target Audience

Professionals typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer; individuals who do not work with SQL Server as a part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others


This is a high-level technical path and candidates for the exam, and hence learners should be expert in the following areas: Tools usage UI navigation Wizards usage Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.) Code debugging or syntactic issue resolution Troubleshooting Accomplishing specific focused tasks through the use of code or UI navigation

Expected Duration

180 min.

Course Objectives

Configuring SQL Server 2005

  • use SQL Server Surface Area Configuration to configure a SQL Server 2005 installation.
  • create a SQL Server database in a given scenario.
  • create a database in SQL Server 2005.
  • recognize the security functionality of the SQL Server 2005 Database Engine.
  • create logins and grant permissions in a given scenario.
  • create logins, users, and schemas in SQL Server 2005.
  • recognize the security mechanisms provided by encryption, the TRUSTWORTHY database property, and execution context in SQL Server 2005.
  • recognize how SQL Server 2005 can access data from OLE DB data sources on remote servers using a linked server configuration.
  • use SQL Server Management Studio to configure a linked server in a given scenario.
  • configure a linked server using SQL Server Management Studio.