CBT :: Microsoft Technical Training Courses :: Microsoft SQL Server 2000: Querying with Transact SQL CBT Training Suite

Microsoft SQL Server 2000: Querying with Transact SQL Suite Training CD-Rom / CBT

Price: $258.00

Training Course ID: CBT 88-73470D

Training Course Description / Outline

Microsoft SQL Server 2000: Querying with Transact SQL Suite Computer Based Training CBT will cover manipulating data with Transact-SQL, how to work with queries, introduce views, understand stored procedures, triggers, and user-defined functions.

Sever 2000 CBT Total Training Time
2 courses - 16 hours

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.
• Identify advantages of using aliases for table names.
• Identify the guidelines for using joins.
• Identify the considerations for using inner joins.
• Identify considerations for using subqueries.
• Create a derived table by using a subquery.
• Create a single-value subquery.
• Identify the functions of views.
• Identify the considerations for defining views.
• Create a view by using an SQL Query Analyzer template.

Audience

This Microsoft SQL Server 2000: Querying with Transact SQL Suite Computer Based Training CBT 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.