MS2071 -Querying Microsoft SQL Server 2000 with Transact-SQL

Sponsored links

The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft® SQL Server™ 2000.
Audience
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Delivery:
  • In house
Category:

Further Details

At Course Completion

After completing the course, students will be able to:

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

•Use querying tools.

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

Guide Price: £595 Per Person - Discount for Groups