MS-2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Duration: 3 days

Price: $1,795.00

SATVs: 3

This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008

Upcoming Classes

To schedule a class, please contact us at 888-825-6273

This course requires that you meet the following prerequisites:

Knowledge of data integrity concepts.

Core Windows Server skills.

Relational database design skills.

Programming skills.

Course Outline

Describe the uses of and ways to execute the Transact-SQL language.

Use querying tool.

Write SELECT queries to retrieve data.

Group and summarize data by using Transact-SQL.

Join data from multiple tables.

Write queries that retrieve and modify data by using subqueries.

Modify data in tables.

Query text fields with full-text search.

Describe how to create programming objects.

Use various techniques when working with complex queries.