About This Training Course

"In this training course you will learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL.

You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and programmers can now use .NET languages like C# and Visual Basic to build database objects."

Subjects Covered

"Lesson 1: A Tour of SQL Server 2005

• SQL Server 2005 Editions, Components and Tools
• Using SQL Server Management Studio (SSMS)
• Working with Tables and Queries
• New Transact-SQL Features
• Business Intelligence Services

Lesson 2: Designing and Creating a Database

• Relational Database Design Principals
• Implementing the Design

Lesson 3: Data Selection Queries

• The SELECT Statement
• The WHERE Clause
• Using ORDER BY to Sort Data
• The GROUP BY Clause
• Joining Tables

Lesson 4: Modifying Data

• Modifying Data
• Inserting Data
• Updating Data
• Deleting Data
• Understanding Transaction Isolation

Lesson 5: Working with SQL Server Management Studio

• Getting Started with SSMS
• Exploring the Object Explorer
• Working with the Query Editor
• Using SQL Server Books Online

Lesson 6: Transact-SQL Programming

• Overview of Transact-SQL
• Using Built-In Functions
• Controlling Flow
• Ranking Results

Lesson 7: Transactions and Error Handling

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

Lesson 8: Creating Views

• What is a View?
• Creating Views
• Updating Data Using a View
• Using Computed Columns
• Index Views
• Partitioned Views

Lesson 9: Creating Stored Procedures and Triggers

• Creating Stored Procedures
• Creating Triggers

Lesson 10: Creating User-Defined Function

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

Lesson 11: Using .NET Code in SQL Server 2005

• Introduction
• Writing SQLCLR Code
• SQLCLR Code Modules
• Managing Code Modules
• SQLCLR Security
• T-SQL vs .NET code

Lesson 12: Advanced Query Techniques

Prerequisites

This course is designed for database developers and SQL Server administrators who need to understand Transact-SQL. To get the most out of this course, you should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.

Other Information

"This course can also be completed by the Walk-In Classroom Learning method. The New Horizons Walk-In Learning methodology was developed by industry professionals and certified trainers to provide a method of training that combines the least amount of time away from the office, with the most time dedicated to learning what they need to know.

The Walk-In Learning Approach: When students arrive at a New Horizons Walk-In centre, they are greeted by the mentor (a certified trainer with industry expertise) who will be mentoring and guiding them through their training. They are then assigned their own networked workstation containing two monitors. This environment allows for simultaneous access to the lecture delivered via recorded audio and video, and a live lab environment.

Why Walk-In Learning?

Flexible Scheduling: Flexible course schedules allow the student to determine when they attend training. The training schedule can be built around a work schedule so productivity in the workplace is maintained.

Focus on and learn relevant modules: Not every course is entirety relevant to a student’s needs. The Walk-In classroom allows you to focus on modules which are more relevant to the technology environment you work in and to your specific learning needs.

Time away from the office now reduced to ONE day blocks: Traditional ILT (Instructor Led Training) courses involved IT staff taking five continuous days out of the office to attend the course. This impacted the business and service levels. In the Walk-In classroom you can pick the days of training and create a custom attendance schedule to suit your calendar, projects and convenience."