SQL SERVER 2008 Development Course Highlights

FULL DEVELOPMENT CYCLE EXAMPLES

Database Design and SQL SERVER 2008 PROGRAMMING FOR BACKEND DEVELOPER

Data Modeling

MORE THAN 50 SQL SERVER SCRIPTS

SQL SERVER INTEGRATION SERVICES

SQL SERVER REPORTING SERVICES

Project work for SSIS and SSRS
SQL SERVER INTEGRATION SERVICES

Introduction to the SSIS environment

Tasks

Drilling into the Data Flow

Expressions and Variables

Containers

Advanced Tasks

Event Handling and Logging in SSIS

Migration from DTS

Administrating SSIS

Enterprise package development.
SQL SERVER REPORTING SERVICES

SSRS Architecture and components

Installation and Setup

BIDS environment and the Report Designer IDE

Report Development Lifecycle

Reporting Services Report Designer

Designing and Developing Reports with Reporting Services

Report Deployment

Report Builder

Grouping and Sorting

Parameters

Expressions, Functions, and Custom Code

Report Management

Adhoc Reporting

Report security

Report Scheduling