Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

MS SQL Server 2005 Programming

Description:

Our MS SQL Server 2005 Programming test measures your knowledge of database development using MS SQL Server 2005. Designed for experienced programmers, this test covers the following topics: Architecture, Indexes, Performance, Queries, Referential Integrity, Stored Procedures, Transact SQL, Triggers, and Views.

This test is associated with a Job Role. Please visit the Job Role Center for more details.

$49.95

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline

Architecture
Concepts
Interfaces
Security
Services
Storage Structures
Transactions
Indexes
Concepts
Design
Performance
Concepts
Locking
Tools
Tuning
Queries
Modifications
Retrievals
Subqueries
Unions and Joins
Referential Integrity
Concepts
Constraints
Defaults
Stored Procedures
Concepts
Programming
Transact-SQL
Concepts
Constructs
Cursors
Data Types
Error-handling
System Functions
User Defined Functions
Variables
Triggers
Concepts
DDL
DML
Programming
Views
Concepts
Design
Updating