|
Provided by: 123-CBT Computer Based Training SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries |
 |
Training
Provided by 123-CBT Computer Based Training
Course Overview
This course will teach students how to work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions.
Learn To
- 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
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 2 Working with Queries
--
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
-...
