Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

SQL Server 2005 - Introduction

3 day course

View Detailed Outline in PDF Format
Get Adobe Reader

In this course, you'll learn about the features that are available in SQL Server 2005, how to design and create a database, how to design and create tables/keys/indexes/relationships, and how to build queries and modify data using Transact-SQL (T-SQL), which is the language of SQL Server and SQL Server Management Studio (SSMS).  You will then learn how to build effective views, stored procedures, triggers, and user-defined functions, using T-SQL and SSMS. You'll also learn about the new enhancements to the T-SQL programming language including improved support for error handling and using .NET languages like C# and Visual Basic to build database objects, such as stored-procedures and functions.

Course Topics:

(for a full detailed outline, visit our PDF link above)

Introduction to SQL Server 2005

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

Designing and Creating a Database

  • Relational Database Design Principles
  • Logical vs. Physical Data Modeling
  • Implementing the Design in SQL Server
  • Primary and Foreign Keys and Referential Integrity
  • The Physical File Components of a SQL Database

Data Selection Queries

  • Understanding Transact-SQL and Statement Types
  • The SELECT Statement and Selection List
  • Filtering Data with the WHERE Clause
  • Using ORDER BY to Sort Data
  • The GROUP BY and the Having Clauses
  • The Techniques and Syntax for Joining Tables

Modifying Data

  • Overview of Data Modification
  • Various Techniques for Inserting New Data Rows
  • Updating, Deleting Data Rows and Truncating Tables
  • Transaction Isolation, Commits and Rollbacks

SQL Server Management Studio

  • Exploring the Object Explorer
  • Working with the Query Editor
  • Templates and Template Parameters
  • Using SQL Server Books Online

Transact-SQL Programming

  • Procedural Statements in Transact-SQL
  • Creating Batches and Scripts vs. Creating Objects
  • Using Built-In and User-Defined Functions
  • Control of Flow Programming Constructs

Database Transactions and Error Handling

  • Transaction Isolation Concepts
  • Applications and Transactions
  • Implicit vs. Creating Explicit Transactions
  • Using TRY/CATCH Error Handling in T-SQL

Creating and Working with Views

  • Understanding and Creating Views
  • Views that can be Used to Update Data
  • The Value of Using Computed Columns
  • Indexed Views and Partitioned Views

Stored Procedures

  • Creating and Using Stored Procedures
  • The Purpose of a Database Trigger
  • DML vs. DDL Triggers

User-Defined Functions

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

Using .NET Code in SQL Server 2005

  • Using .NET Languages for Stored Procs and UDFs
  • Writing SQLCLR Code and Code Modules
  • Managing Code Modules
  • SQLCLR Security
  • Writing T-SQL vs. .NET Code

Advanced Query Techniques

  • Full-Text Search
  • Generating XML with FOR XML
  • Using APPLY
  • Creating Recursive Queries
  • Creating Pivot Queries
  • Executing Dynamic SQL