Certified SQL Server 2008 Programmer

Introduction

• RDBMS
• SQL Server installation, starting and stopping

SQL Server management studio

• SQL Server management studio Options
• Query Editor

Design and Implementation

• Keys and Relationships
• Normalization
• Prebuilt Databases

SQL Operations

• DDL and DML commands
• Query commands, nested and correlated queries
• EXISTS, INTERSECT and EXCEPT operator

Indexes

• Types
• Create, Drop and alter index
• Index Performance

Stored Procedures and UDF

• UDF and their types
• Stored procedures and create procedure
• Conditional and loop constructs
• Develop and execute User Defined Functions (UDF) and stored procedures

Transact-SQL

• SQL Server Objects
• Data Types
• Error Handling
• Apply Operator and CTE
• Subqueries, pivoting and ranking functions
• Powershell

Concurrency

• Transactions
• Locking

Trigger

• Create and execute triggers
• DDL and DML triggers

Optimization

• Partitioning
• Indexing
• Resource Governor

XML

• Store and retrieve XML documents
• XQuery Methods

Security

• Roles
• Schemas

Administration

• Backup
• Recovery
• Database Maintenance