|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 Implementation - Level 2 |
 |
Training
Provided by 123-CBT Computer Based Training
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
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
|
|
SQL Server 7 0 Implementation - Level 2
--
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
-...
