Writing T-SQL Queries for SQL Server 2005 and 2008 R2

2-Day (COURSE-DB-TSQL)

Description

This two day course is designed to provide coverage of the core skills involved in querying SQL Server using the T-SQL language. These are important skills for developers, DBAs and for those needing to write reports using SQL Server.

The course covers material applicable to both SQL Server 2005 and 2008 R2 and enhancements only available in 2008 R2 are clearly identified. For more advanced coverage of the T-SQL language, consider our Advanced T-SQL class.

For details on booking courses or seminars, please visit our booking page.

Audience

This course is intended for:

Developers needing to work with SQL Server
SQL Server database administrators
Users needing to write TSQL queries (for example in reporting tools)

Prerequisites

Before attending this course, it is recommended that students have the following skills:

Understanding of database concepts

Course Objectives

Attendees will gain a working understanding of the TSQL language. The course targets both SQL Server 2005 and 2008 R2.

Writing T-SQL Queries for SQL Server 2005 and 2008 R2

2-Day (COURSE-DB-TSQL)

Description

Audience

Prerequisites

Course Objectives

Course Outline

Module 1: Understanding SQL Server and its Query and Administration Tools

Module 2: Retrieving Information from a Single Table

Module 3: Working with Data Types

Module 4: Grouping Results

Module 5: Retrieving Information from more than one Table

Module 6: Nesting Queries

Module 7: Modifying Data

Module 8: Handling Errors