Provided by: 123-CBT Computer Based Training

SQL Server 7 0 Implementation - Level 2

Click here for more information or to take this course

Search for Training

Find Your Genius!

Training Provided by 123-CBT Computer Based Training

Implementing SQL 7 Level 2 (2 Hours 17 Minutes)

1.0 Creating Constraints and Indexes (40 min)
1.1 Creating Constraints
1.2 Primary & Foreign Keys
1.3 Creating a Unique Constraint
1.4 Creating Indexes
1.5 CHECK
1.6 Creating Rules
1.7 Using Transact SQL
2.0 Data Retrieval (30 min)
2.1 SQL Definition
2.2 ANSI SQL 92 standard
2.3 SELECT statement
2.4 WHERE clause
2.5 Wildcards
2.6 Examples
2.7 Calculated columns & Null
2.8 Sorting data
2.9 Aggregate functions
2.10 Using the SQL Query Analyzer
3.0 Advanced Queries (18 min)
3.1 CASE
3.2 Aggregate Functions & Group By
3.3 Top N Percent
4.0 Joining Tables (33 min)
4.1 Joins in SQL Server and Access
4.2 Inner Joins
4.3 Outer Joins
4.4 Cross Joins
4.5 Subqueries
4.6 Self-Joins
4.7 Union
5.0 Data Modification (15 min)
5.1 Inserting data
5.2 Updating data
5.3 Deleting data

Training Avaliability and Delivery

Contact 123-CBT Computer Based Training for more information

Training Presented in:

English

Related Keywords: microsoft sql server 7.0 implementation level

Training Program Details

About 123-CBT Computer Based Training - Training Provider

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 - Dreamweaver MX -...

More Microsoft SQL Server 7 0 Training from 123-CBT Computer Based Training

Click here for more information or to take this course

Custom Search

Training Directory \| New Training Seminars \| New Training Providers \| Search \| Site Map \| Promote Training \| Login \| Links

	Training-Classes.com by Skillbox® 07/19/08 Copyright 1998-2008 skillbox, inc. All rights reserved

Are you a Microsoft training provider?

You could be on this page today - for FREE!