Microsoft SQL Server 2005 Programming

This course is also an elective for the MCSE as well as the MCSD and MCDBA

The SQL Development Course
Duration: 5 days full time from 8am to 4pm
Venue: Greenpoint, Cape Town

The price for this course excludes accommodation, flights, transport, transfers etc.
Outline of the SQL Course for exam 70-229

Microsoft SQL Server 2005 Programming Course Overview:

An Overview of SQL Server 2005
New Features
Database Roles
Client Tools
 

Installing SQL Server 2005
Preparing For Installation
Setup User Interface
Installing Express Edition
Configuring an New Instance

SQL Server Database Engine
Managing Services
Managing Servers
Database Projects
Database Objects

SQL Server Integration Services (SSIS)
What Happened To DTS?
What is ETL?
Integration Services Projects
SSIS Objects
Expressions

SQL Server Analysis Services (SSAS)
OLAP vs. OLTP
Data Warehousing
Data Mining
Architecture
Analysis Services Projects
Analysis Services Scripting Language (ASSL)
XML for Analysis (XMLA)
Predictive Mining Model Language (PMML)
Data Mining Extensions (DMX)
Multidimensional Expression Language (MDX)
 

SQL Server Replication
Overview
Replication Types
Agents
Implementing
Administering
Enhancements

SQL Server Reporting Services (SSRS)
Overview
Creating, Managing, and Delivering
Administering
 

SQL Server Full-Text Search (SSFTS)
Overview
Architecture
Writing Queries
Administering

SQL Server Notification Services (SSNS)
Overview
Subscription Management
Event Collection
Subscription Processing
Formatting and Delivery
 

SQL Server Service Broker
Overview
Conversations
Message Ordering and Coordination
Transactional Asynchronous Programming
Loosely Coupled Applications
Components
Administering

Security
Overview
Catalog Views
Security Functions
Cryptographic Functions
CLR Integration
Native XML Web Services
Integration Services
Analysis Services
Replication
Reports
Notifications
Service Broker
 

International Databases
Unicode Data
Date and Time Issues
Collations
International SQL
Integration Services
Analysis Services
Reports
Notifications
Service Broker
Full-Text Searches

Working with XML
Data Type
Indexes
Schema Collections
For XML
OpenXML
Native XML Web Services
 

Data Availability
Disaster Recovery
High Availability
Backup
Restore

Monitoring and Performance
Windows Performance Monitor
SQL Server Profiler
Database Engine Tuning Advisor (DTA)
Federated Database Servers
Partitioned Tables
Partitioned Indexes
Query Performance Issues
Transactions and Locks
Best Practices for Native XML Web Services
 

Programming SQL Server 2005
Transact-SQL
CLR Integration Overview
Stored Procedures
User-Defined Functions
User-Defined Types
DML Triggers
DDL Triggers
SQL Management Objects (SMO)
Integration Services
Replication Management Objects (RMO)
Reports
Notifications