MS SQL Server 2008 Programming

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

 

Go Back