SUMMARY:   This course is designed for those who are developing applications for SQL Server using T-SQL. AUDIENCE:   Those who use T-SQL to create scripts batches and applications for SQL Server 2005 using T-SQL PREREQUISITES:   Those attending should be familiar with Relational Database Management Systems, their main characteristics and structure. DURATION:   5 days APPROACH:   The course will be Instructor-led with hands on exercises. OBJECTIVES:   At the end of this course, delegates will be able to: Use the Management Studio Tools to create applications Use T-SQL Code to Administer and manipulate SQL Server databases Use T-SQL code to write scripts and batches COURSE CONTENT:   RDBMS Basics Overview of Database Objects SQL Server Data Types SQL Server Identifiers for Objects Tools Books Online SQL Server Configuration Manager SQL Server Management Studio SQL Server Integration Services (SSIS) Bulk Copy Program (bcp) SQL Server Profiler sqlcmd T-SQL Foundation Statements Basic SELECT Statement INSERT Statement UPDATE Statement DELETE Statement JOINs JOINs INNER JOINs OUTER JOINs FULL JOINs CROSS JOINs Alternative Syntax for Joins UNION Creating and Altering Tables Object Names in SQL Server CREATE Statement ALTER Statement DROP Statement GUI Tool Constraints Types of Constraint Constraint Naming Key Constraints CHECK Constraints DEFAULT Constraints Disabling Constraints Rules and Defaults Triggers for Data Integrity Adding More to Queries Subqueries Correlated Subqueries Derived Tables The EXISTS Operator Mixing Datatypes: CAST and CONVERT Performance Considerations Normalization and Design Tables Keeping Data “Normal” Relationships Diagramming De-Normalization SQL Server Storage and Index Structures SQL Server Storage Indexes Creating, Altering, and Dropping Indexes Maintaining Indexes Views Simple Views Complex Views Editing Views with T-SQL Dropping Views Creating and Editing Views in the Management Studio Auditing: Displaying Existing Code Protecting Code: Encrypting Views About Schema Binding Making Your View Look Like a Table with VIEW_METADATA Indexed (Materialized) Views Writing Scripts and Batches Script Basics Batches SQLCMD Dynamic SQL Stored Procedures Basic Syntax Changing Stored Procedures Dropping Stored Procedures Parameterization Control-of-Flow Statements Return Values Errors Extended Stored Procedures (XPs) Recursion Debugging .NET Assemblies User Defined Functions What is a UDF UDFs Returning a Scalar Value UDFs which Return a Table Debugging User-Defined Functions .NET and Databases Transactions and Locks Transactions SQL Server Log Locks and Concurrency Isolation Level Deadlocks Triggers What is a Trigger? Triggers for Data Integrity Rules Common Uses for Triggers Trigger Issues INSTEAD OF Triggers Performance Considerations Dropping Triggers Debugging Triggers XML Primer XML Basics SQL Server and XML XSLT Reporting Services Reporting Services Building Report Models Report Server Projects Integration Services Understanding the Problem Import/Export Wizard Executing Packages Editing Packages Administration Scheduling Jobs Backup and Recovery Index Maintenance Archiving Data JWS/07