SQL Server 2005 - Database Implementation & Development, Thales Training Consultancy

SQL SERVER 2005 - DATABASE IMPLEMENTATION & DEVELOPMENT

Duration:

3 days

Price:

£885.00

Locations Available:

Crawley
23-25 Apr 08
20-22 Oct 08

Suitable For

This course is designed for developers looking to gain specific skills in developing with SQL 2005. Prior knowledge of SQL programming either gained from attendance on the ‘SQL Foundation’ course or similar experience is recommended.

Generic programming experience would be advantageous, in particular .NET.

Objectives

By the end of the course participants will be able to:·

Select the appropriate SQL Server edition for an individuals / organisations needs.·
Select and employ appropriate SQL Server 2005 technologies and methods for solving common development problems.
Build robust and efficient database objects (queries, views and stored procedures).·
Develop Integration Services (SSIS) packages to perform scheduled/automated tasks. ·
Perform crucial administration and performance tuning tasks on databases.·
Explain the importance of performing Unit Testing of code and implementing Source Control.·
Apply acquired development skills to real world scenarios.·
Take away a fully functioning SQL Server 2005 database (and supplied application) built during the Hands-On sessions.

Course Content

Introduction To Microsoft SQL Server 2005·

The evolution of SQL Server·
SQL Server Management Studio (SSMS) and osql

SQL Language Review·

The SQL ANSI standard and Transact-SQL·
Data Normalisation and Table Design overview·
Extracting Data (Data Manipulation Language - DML)
Modifying Tables (Data Definition Language - DDL)

Development Fundamentals (using SSMS and osql)·

Transact-SQL elements, statements and scripts·
Views· Stored Procedures·
DML Triggers·
User-Defined Functions

Development Technologies And Methods·

Choosing the appropriate technologies for development, Transact-SQL, Common Language Runtime (CLR) integration, SQL Native Client·
Developing robust, efficient and error free Stored Procedures (T-SQL & CLR)

SQL Server 2005 – Technology And Component Architecture·

Built-In Data Management / Integration technologies:·
The Database Engine·
Integration Services (SSIS)·
Full-Text Search·
Notification Services·
Replication·
Built-In Data Analysis (Business Intelligence) technologies:·
Analysis Services (SSAS)·
Reporting Services (SSRS)

SQL Server 2005 - Administration And Performance Tasks·

Bulk transferring data (Import and Export)·
Database Backup and Restore·
Identifying requirements for and creating Indexes·
The Database Engine Tuning Advisor·
SQL Server Profiler

XML·

The XML data type·
The FOR XML clause and Transact-SQL OPENXML function·
XML Schema Collections

Development Unit Testing & Source/Version Control ·

Reasons for and methods of performing Unit Testing·
Using Source/Version Control – Visual Studio Team Server (VSTS) and Visual SourceSafe (VSS)·
Using Database Projects in SSMS and Visual Studio.NET