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

Duration
3 Days

Target Audience

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Topics

Getting Started with Databases and Transact-SQL in SQL Server 2008

Querying and Filtering Data

Grouping and Summarizing Data

Joining Data from Multiple Tables

Working with Subqueries

Modifying Data in Tables

Querying Metadata, XML, and Full-Text Indexes

Using Programming Objects for Data Retrieval

Using Advanced Querying Techniques

A more comprehensive course outline is available in the Course Download section, to the right of this page.

MTC serves the whole of the North East region, including, Sunderland, Newcastle, Durham Teesside, Tyne and Wear, Cumbria, Northumberland, Darlington, North Yorkshire, Carlisle, Hartlepool. In addition MTC supports many clients nationally within the UK.