|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 Implementation - Level 4 |
 |
Training
Provided by 123-CBT Computer Based Training
1.1 Bulk Copy Procedure (BCP)
1.2 BULK INSERT
1.3 Data Transformation Services
2.0 Full Text Searches (16 min)
2.1 Overview of Full Text Searches
2.2 Creating Full Text Indexes
2.3 Performing Searches
3.0 Optimization Techniques (39 min)
3.1 When and How to Optimize
3.2 Hardware
3.3 Database Design
3.4 Query Optimization
3.5 Index Usage
3.6 Using the Query Analyzer
3.7 Database Consistency Checker
3.8 SQL Server Profiler
3.9 Performance Monitor
3.10 Other Tuning
4.0 Tips and Tricks (9 min)
4.1 Indexes
4.2 Key Usage
4.3 Things to avoid
4.4 Field Usage
4.5 Naming Standards
4.6 How many Databases
5.0 System Tables & Databases (17 min)
5.1 Overview of System Databases
5.2 Viewing System Databases & Tables
5.3 Overview of System Tables
5.4 Querying
5.5 Tables in the Master Database
5.6 Tips
6.0 Connecting (17 min)
6.1 OLE DB & ODBC
6.2 Accessing Data with ODBC
6.3 Accessing Data with ADO
7.0 Distributed Management Objects (12 min)
7.1 SQL-DMO
7.2 Manipulating and Reading Objects
Implementing SQL 7 Level 4 (2 Hours 4 Minutes)
1.0 Data Transfers (9 min)1.1 Bulk Copy Procedure (BCP)
1.2 BULK INSERT
1.3 Data Transformation Services
2.0 Full Text Searches (16 min)
2.1 Overview of Full Text Searches
2.2 Creating Full Text Indexes
2.3 Performing Searches
3.0 Optimization Techniques (39 min)
3.1 When and How to Optimize
3.2 Hardware
3.3 Database Design
3.4 Query Optimization
3.5 Index Usage
3.6 Using the Query Analyzer
3.7 Database Consistency Checker
3.8 SQL Server Profiler
3.9 Performance Monitor
3.10 Other Tuning
4.0 Tips and Tricks (9 min)
4.1 Indexes
4.2 Key Usage
4.3 Things to avoid
4.4 Field Usage
4.5 Naming Standards
4.6 How many Databases
5.0 System Tables & Databases (17 min)
5.1 Overview of System Databases
5.2 Viewing System Databases & Tables
5.3 Overview of System Tables
5.4 Querying
5.5 Tables in the Master Database
5.6 Tips
6.0 Connecting (17 min)
6.1 OLE DB & ODBC
6.2 Accessing Data with ODBC
6.3 Accessing Data with ADO
7.0 Distributed Management Objects (12 min)
7.1 SQL-DMO
7.2 Manipulating and Reading Objects
|
|
SQL Server 7 0 Implementation - Level 4
--
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
-...
