SQL Server Developer Course Outline

Microsoft SQL Server 2008 and 2008 Feature Overview and History

What is Microsoft SQL Server?
Client/Server Architecture
Microsoft SQL Server - A Brief History
SQL Server 2008 A Review of New Features

Installation and Upgrading of Microsoft SQL Server

Pre-Installation Check List
Installing Microsoft SQL Server 2008
SQL Server Components

Data Storage and Management

Creating Databases and Logs
Using Filegroups

Creating Database Objects

Creating Tables, Column-level Check Constraints (Primary & Foreign Keys ect..)
Creating Triggers, Views.
Creating User-Defined Functions.
Creating Stored procedures.
Creating Indexes.

Overview of T-SQL Programming

Coding for Stored Procedure, Trigger & UDF.
Transactions & Error Handling.
Using Cursors.
Using Temp tables, Table Variables, Derived Tables and CTE’s.
Using Different types of Joins.

Scheduling Jobs in SQL Server

Automation Overview
Setting up SQLMail
Setting up Operators in Microsoft SQL Server
Jobs, Events and Alerts
Types of Job
Creating User-Defined Error Messages
Setting Up Alerts
Multi-Server Jobs

Performance Tuning

SQL Server monitoring for performance
SQL Server startup parameter tuning
T-SQL tuning
SQL tuning for SQL Server
Diagnosing storage and system problems
Diagnosing session and O/S issues

Troubleshooting & Monitoring SQL Server

Viewing Current Activity
Using System Monitor
Using SQL Server Profiler
Monitoring SQL Server Performance
Tracing SQL Server Activity
Implementing DDL Triggers

SQL Server 2008 Reporting Services (SSRS) Training Course Outline

Introducing SQL Server Reporting Services

Tour of Features
Reporting Services Architecture
Reporting Services Terminology
Reporting Services Editions

Creating Reports

Shared Data Sources
Creating Reports from Scratch

Calculations and Formatting

Reporting Services Items
Basic Expressions
Using the Global Collections
Formatting Fields
Conditional Formatting

Grouping and Sorting

Creating Groups
Interactive Sorting
Creating Drill-Down Reports
Calculating Totals and Percentages

Report Parameters

Creating Report Parameters
Binding Report Parameters to Dataset Parameters
Creating Drop-Down Parameters
Multi-Valued Parameters
Debugging Parameter Issues

Creating Matrix Reports and Charts

Creating a Basic Matrix Report
Matrix Subtotals
Creating a Basic Chart
Exploring the Charting Possibilities
Charting Add-ons

Managing Reporting Services

Using the Web-Based Report Manager
Using SQL Server Management Studio-based Reporting Services Manager
Deploying Reports and Data Sources

Reporting Services Security

Reporting Services Security
Managing Roles

Distributing Reports via Subscriptions

How Subscriptions Work
Creating Standard Subscriptions
Creating Data-Driven Subscriptions
Managing Subscriptions

Ad-Hoc Reporting with Report Builder

The Report Builder Architecture
Creating Report Model Projects
Running Report Builder

SQL Server 2008 Integration Services (SSIS) Training Course Outline

Introduction to SQL Server Integration Services

Product History
SSIS Package Architecture Overview
Development and Management Tools
Deploying and Managing SSIS Packages
Source Control for SSIS Packages

Business Intelligence Development Studio

Launching BIDS
Project templates
The package designer
The Toolbox
Solution Explorer
The Properties window
The Variables window
The SSIS menu

Introduction to Control Flow

Control Flow Overview
Precedence Constraints
The Execute SQL Task
The Bulk Insert Task
The File System Task
The FTP Task
The Send Mail Task

Advanced Control Flow

Containers - grouping and looping
The Analysis Services tasks
The Execute Process Task
The Execute Package Task

Introduction to Data Flow

Data Flow Overview
Data Sources
Data Destinations
Data Transformations
The Copy Column Transformation
The Derived Column Transformation
The Data Conversion Transformation
The Conditional Split Transformation
The Aggregate Transformation
The Sort Transformation
Data Viewers

Variables and Configurations

Variables Overview
Variable scope
SSIS system variables
Using variables in control flow
Using variables in data flow
Using variables to pass information between packages
Property expressions
Configuration Overview
Configuration options
Configuration discipline

Debugging, Error Handling and Logging

SSIS debugging overview
Breakpoints in SSIS
SSIS debugging windows
Control Flow: The On Error event handler
Data Flow: Error data flow
Configuring Package Logging
Built-in log providers

Advanced Data Flow

Revisiting data sources and destinations
The Lookup Transformation
Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
The Multicast Transformation
The Merge and Merge Join Transformations
The Data Mining Query Transformation
The Data Mining Model Training Destination
The Slowly Changing Dimension Transformation

Extending SSIS through Custom Code

Introduction to SSIS scripting
The SSIS script editor
The SSIS object model
Script in Control flow: The Script Task
Script in Data flow: The Script Component
Introduction to SSIS component development

SSIS Package Deployment

Configurations and deployment
The deployment utility
Deployment options
Deployment security
Executing packages - DTExec and DTExecUI

SSIS Package Management

The SSIS Service
Managing packages with DTUtil
Managing packages with SQL Server Management Studio
Scheduling packages with SQL Server Agent

SQL Server 2008 Analysis Services (SSAS) Training Course Outline

Objectives

Describe how SQL Server Analysis Services can be used to implement Analytical Solutions.
Create multidimensional analysis solutions with SQL Server Analysis Services.
Implement dimensions in an Analysis Services Solution.
Implement measures and measure groups in an Analysis Services Solution.
Query a multidimensional Analysis Services solution.
Customize an Analysis Service cube.
Deploy and Secure an Analysis Services Database.
Maintain a multidimensional Analysis Services solution.
Implement a Data Mining Solution.

Topics

Introduction to Microsoft SQL Server 2008 Analysis Services

Overview of Data Analysis Solutions
Overview of SQL Server 2008 Analysis Services.
Installing SQL Server 2008 Analysis Services.

Creating Multidimensional Analysis Solution

Developing Analysis Services Solutions.
Data Sources and Data Source Views
Creating a Cube

Lab: Creating a Multidimensional Analysis Solution

Working with Dimensions

Configuring Dimensions
Defining Hierarchies
Sorting and Grouping Attributes

Lab: Defining Dimensions

Working with Measures and Measure Groups

Working with Measures.
Working with Measure Groups.

Lab: Configuring Measures and Measure Groups

Querying Multidimensional Analysis Solutions

MDX Fundamentals
Adding Calculations to a Cube

Lab: Querying a Cube.

Customizing Cube Functionality

Implementing Key Performance Indicators.
Implementing Actions
Implementing Perspectives.
Implementing Translations.

Lab: Customizing a cube.

Deploying and Securing an Analysis Services Database

Deploying an analysis Services Database.
Securing an Analysis Services Database.

Lab: Deploying and Securing an Analysis Services Database.

Maintaining a Multidimensional Solution

Configuring processing settings
Logging, Monitoring, and Optimizing an Analysis Services Solution
Backing Up and Restoring an Analysis Services Database.

Lab: Maintaining an Analysis Services Database

Introduction to Data Mining

Overview of Data Mining
Creating a Data Mining Solution
Validating Data Mining Models

Lab: Implementing Data Mining

Shopping Cart Software