SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data ...ion Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements. Identify the guidelines for selecting columns within a table. Identify the guidelines for using the WHERE clause to retrieve rows in a table. Retrieve specific columns from a table. Identify the characteristics of aggregate functions. Identify the considerations for using the GROUP BY clause. more...