|
Provided by: 123-CBT Computer Based Training SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data |
 |
Training
Provided by 123-CBT Computer Based Training
Course Overview
This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL.
Learn To
- Identify the basic types of statements used in Transact-Structured Query Language (SQL).
- Identify the functions of Data Definition 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.
- Identify the guidelines for using the GROUP BY clause with the HAVING clause
Audience
Candidates for this course operate in medium to very large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. The general categories include: system administrators, database administrators, application developers, system analysts, and software engineers. Students are expected to have an understanding of basic relational database concepts and should be familiar with the role of the database administrator.
|
|
||||||||||
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
