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 Boot Camp

5 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 and 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.  You will then learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks.  You will learn to install, upgrade and configure instances of SQL Server 2005, and how to take advantage of SQL Server's tools for analyzing and tuning your databases. You'll also learn about integration services, implementing security, and Microsoft's new Business Intelligence (BI) suite.

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

Installing and Configuring SQL Server 2005

  • SQL Server 2005 Editions, Components, and Tools
  • Pre-Installation Planning and Requirements
  • Upgrading an Earlier Version of SQL Server
  • Installing Instances of SQL Server
  • Step-by-step Installation
  • Configuring SQL Server 2005
  • The Purpose and Function of the Transaction Log

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 & 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