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 2008 Programming

Description:

Description Goes Here!Our MS SQL Server 2008 Programming test measures your knowledge of MS SQL Server 2008 Programming. Designed for experienced programmers, but an average performer in this role should pass this test. This test covers the following topics: Architecture, Beyond Relational, Data Modification, Database Design, Performance and Optimization, SQL Queries, Tools, Transact-SQL, Triggers, User-Defined Functions.

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

Outline Goes Here!
Architecture
Client/Server
Services
Storage Structures
Transactions
Beyond Relational
Full-Text Search
XML
Data Modification
Delete
Insert
Merge
Update
Database Design
Data Types
Keys
Normalization
Table Design
Performance and Optimization
Execution Plans
Indexing Design
Transaction Locking and Blocking
SQL Queries
Aggregate Queries
Hierarchies
Joins and Unions
Single-Table Queries
Subqueries and CTEs
Windowing and Ranking
Tools
Management Studio
Profiler / SQL Trace
Transact-SQL
Batches, Scope, Variables, and Procs
Cursors
Distributed Queries
Distributed Queries and Dynamic SQL
Error-handling
Views
Triggers
DDL Triggers
DML After Triggers
DML Instead Of Triggers
User-Defined Functions
Multi-Statement Table-Valued UDFs
Scalar UDFs
Single-Statement Table-Valued UDFs