Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

CLASS DATE(s):
11/15/2010 - 11/17/2010
11/15/2010 - 11/17/2010

COURSE LENGTH: 3 Days

COURSE COST: $1495*

COURSE TIMES: 8:30am - 4:00pm


print
register

COURSE OVERVIEW

In this course, you will learn about the features that are available in SQL Server, like how to design and create a database and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for error handling and hierarchical queries, dealing with complex data structures and processes, and how to make your databases more scalable through partitioning.

SQL Server 2008 includes a rich set of tools that go beyond the basics of querying and manipulating data. You will learn how to take advantage of the user-friendly management console that integrates both authoring and administrative tasks. You will learn how to take advantage of SQL Server's tools for analyzing and tuning your databases.

*Course Cost does not include books. Please contact a VTEC Account Manager for details.

To get the most out of the Microsoft T-SQL Server 2008 course, students should have a solid understanding of relational databases. No particular programming experience is required, but the course was written from a developer's perspective.

Expect to be challenged with many hands-on exercises in addition to the lab materials provided in the book. The emphasis of the extra hands-on exercises added to the course is to develop a skill in pulling data out of a database for reporting and other development purposes.

Due to the addition of these skill building exercises, we will not cover all the material in the book. Our students leave with a grounding in the basics and plenty of study materials to help take what they have learned and add the more complex skills to their on the job repertoire.

COURSE TOPICS:

SQL Server 2008 Editions, Components, and Tools

Using SQL Server Management Studio (SSMS)

Working with Tables, Queries, and Views

Business Intelligence Services

Relational Database Design Principles

Implementing the Design

Getting Started with Management Studio

Exploring the Object Explorer

Working with the Query Editor

Using SQL Server Books Online

Overview of Transact-SQL

Using Built-In Functions

Controlling Flow

Ranking Results

Transaction Concepts

Applications and Transactions

Creating Explicit Transactions

Using TRY/CATCH Error Handling

Understanding Transact-SQL

The SELECT Statement

The WHERE Clause

Using ORDER BY to Sort Data

The GROUP BY Clause

Joining Tables

Introduction

The HierarchyID Data Ty

Sparse Columns and Column Sets

FILESTREAM Storage

Spatial Data

Working with NULL Values

Ranking Grouped Data

Writing Correlated Subqueries

Using Common Table Expressions

Modifying Data with Transact-SQL

Inserting Data

Updating Data

Deleting Data

Understanding Transaction Isolation

The XML Data Type

XML Schema Collections

Querying XML

Best Practices

What Is a View?

Creating Views

Updating Data Using a View

Using Computed Columns

Indexed Views

Partitioned Views

Overview of Table-Based Partitions

Creating Partitioned Tables

Querying Partitions

Managing Partitions

User-Defined Function Overview

Scalar Functions

Inline Table-Valued Functions

Multi-Statement Table-Valued Functions

Using Functions, Views, and Stored Procedures

Creating Stored Procedures

Creating Triggers

Full-Text Search

Advanced T-SQL Techniques

Executing Dynamic SQL

Complex Data and Structures

Writing More Efficient Queries

Working with Complex Queries

Maintaining Query Files