Microsoft SQL Server 2008 for Developers (MCTS 70-433) Taining Course Midlands | Birmingham | Telford | Stafford | Wolverhampton

In this three day course participants learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Participants learn about Transact-SQL error handling and hierarchical queries, how to make your databases more scalable through partitioning, and how to use .NET languages like Visual C# and Visual Basic to build database objects. This course also forms the second and final module in our MCTS 70-433 SQL Server 2008 Database Development exam preparation programme.

Topics include-

Creating Views
What Is a View?
Creating Views
Updating Data Using a View
Using Computed Columns
Indexed Views
Partitioned Views

Creating Stored Procedures and Triggers
Creating Stored Procedures
Creating Triggers

Creating User-Defined Functions
User-Defined Functions Overview
Scalar Functions
Inline Table-Valued Functions
Multi-Statement Table-Valued Functions
Using Functions, Views, and Stored Procedures

Transactions and Error Handling
Transaction Concepts
Applications and Transactions
Creating Explicit Transactions
Using TRY/CATCH Error Handling

Using .NET Code in SQL Server
Introduction
Writing SQLCLR Code
SQLCLR Code Modules
SQLCLR Security
T-SQL vs .NET Code

Advanced SQLCLR Code Techniques
Advanced SQLCLR Code Modules
Managing Code Modules

Advanced Query Techniques
Full-Text Search
Advanced T-SQL Techniques
Executing Dynamic SQL

Advanced Data Types
Introduction
The HierarchyID Data Type
Sparse Columns and Column Sets
FILESTREAM Storage
Spatial Data

Implementing Partitions
SQL Server Partitions
Creating Partitioned Tables
Querying Patitions
Managing Partitions

Complex Querying
Complex Queries
Ranking
Correlated SubQueries
Common Table Expressions

Advanced Techniques
Complex Data and Structures
Efficient Queries
Working with Complex Queries
Maintaining Query Files

Design and Deployment with Visual Studio
Team System for Database Professionals
Creating Databases and Managing Projects
Database and Project Management

Working with XML
XML Data Type
XML Schema Collections
Querying XML
Best Practices

Business Intelligence Services
Introduction to Business Intelligence Services
Using Integration Services
Using Analysis Services
Using Reporting Services