203-220-2218
skip to the main content area of this page
Training: Course Outline

2008 Training Schedules

To register call:
1-203-220-2218

Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

This course introduces you to Transact-SQL starting with basic SELECT queries, then advancing to grouping, joins, subqueries, data modification, transactions, and heterogeneous data sources.

Audience

This collection is intended for IT Professionals who must access and manipulate data in SQL Server 2005 databases and other data sources.

At Course Completion

After completing the course, students will be able to:

  • Get started with databases and Transact-SQL
  • Perform basic queries
  • Group and summarize data
  • Join data from multiple tables
  • Work with subqueries
  • Modify data
  • Query metadata, XML, and full-text indexes
  • Use programming objects for data retrieval
  • Use advanced querying techniques

Prerequisites
  • Familiarity with a programming or scripting language
  • Understand relational databases and the concept of data normalization

Course Contents
  • Getting Started with Databases and T-SQL in SQL 2005
  • Performing Basic Queries
  • Grouping and Summarizing Data
  • Joining Data from Multiple Tables
  • Working with Subqueries
  • Modifying Data
  • Querying Metadata, XML, and Full-Text Indexes
  • Using Programming Objects for Data Retrieval
  • Using Advanced Querying Techniques

Student Responsibilities
In order for a class to be successful, all students should share the same general level of knowledge and experience. If a participant does not demonstrate these, the instructor will take the necessary steps either to prepare the participant or place him/her in a more appropriate course. This policy is intended to maintain the high level of quality control that you have come to expect.
<< Back to Schedule