Tel: 1300 TO TRAIN

Email: info@advancedtraining.com.au

IT Training with Advanced Training

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL


Introduction

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

Outcomes

At the completion of this course, participants will be able to:

  • 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.



User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info


Schedule

  • Melbourne
  • 12/06/2012 - 14/06/2012
  • 30/07/2012 - 1/08/2012
  • 17/09/2012 - 19/09/2012

Next Step

Book Course Now
Enquire Now
Tell a Friend
Email Course Outline