Managed Business & IT Training Solutions

MBIT Training Ltd

Course: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (2778)

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

Please select your required training start date:

*

Please select your desired location

£1,170.00 (GBP)

This course is available at the following locations:

(cited from the Microsoft Learning website)

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

Upon completion of courses 6231 and 2778, also passing associated exam 70-432 you will obtain the title MCTS: Microsoft SQL Server 2008, Implementation and Maintenance.

After completing this course, students 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.
Related products