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: |
|
| Category: |
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.
