Want to take this class from the comfort and convenience of your own office? We can offer a customized version of most courses right at your office, when you need it. Read more about our on-site learning or contact us to get specific information.

2071 Querying Microsoft SQL Server 2000 with Transact-SQL

Course Description

Home > Courses > 2071 Querying Microsoft SQL Server 2000 with Transact-SQL

Upcoming Classes

Start Date	Time	Duration	Location	Cost	Purchase

Don't see dates for this class? Please contact us or request that we add it to our schedule.

Methods of Delivery

This course can be delivered via the following learning methods:

Overview

This course teaches the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000

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.

Pre-Requisites

An understanding of basic relational database concepts

Previous Page
New Search

New Horizons of Syracuse, NY
Glacier Creek Office Park
6711 Towpath Road, Suite 100
East Syracuse, NY 13057
Phone: 315-449-3290
Email: info.syracuse@newhorizons.com

New Horizons of Rochester, NY
Calkins Road Business Park
50 Methodist Hill Drive, Suite 50
Rochester, NY 14623
Phone: 585-427-2150
Email: info.rochester@newhorizons.com