|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 Administration - Level 4 |
 |
Training
Provided by 123-CBT Computer Based Training
1.1 The different Server Configuration Options
2.0 Data Transfer (ring & Scripting Objects)(54 Minutes)
2.1 Transferring Data
2.2 Bulk Copy Procedure
2.3 Bulk Insert
2.4 Data Transformation Server
2.5 Transferring Objects with DTS Designer
2.6 Other Object Transferal Methods
3.0 Monitoring the Server (29 Minutes)
3.1 Why Monitor & Monitoring for Performance
3.2 Monitoring Tools
3.3 Using Performance Monitor
3.4 Monitoring activity with the SQL Server Profiler
3.5 System Procedures & Functions & Transaction SQL Statements
4.0 Error Logs (8 Minutes)
4.1 Why Monitor Error Logs
4.2 Types of Error Logs
4.3 Where the error logs are stored
5.0 Replication (33 Minutes)
5.1 Why Replicate
5.2 Two Methods
5.3 Terms
5.4 Replication Scenarios
5.5 Implementing Replication
5.6 Characteristics of Replication Types
5.7 Planning Replication
5.8 Configuring SQL Server for Replication
5.9 Publication, Subscription and Distribution
SQL Server 7 Administration Level 4 (2 Hours 20 Minutes)
1.0 SQL Server Configuration Options (15 Minutes)1.1 The different Server Configuration Options
2.0 Data Transfer (ring & Scripting Objects)(54 Minutes)
2.1 Transferring Data
2.2 Bulk Copy Procedure
2.3 Bulk Insert
2.4 Data Transformation Server
2.5 Transferring Objects with DTS Designer
2.6 Other Object Transferal Methods
3.0 Monitoring the Server (29 Minutes)
3.1 Why Monitor & Monitoring for Performance
3.2 Monitoring Tools
3.3 Using Performance Monitor
3.4 Monitoring activity with the SQL Server Profiler
3.5 System Procedures & Functions & Transaction SQL Statements
4.0 Error Logs (8 Minutes)
4.1 Why Monitor Error Logs
4.2 Types of Error Logs
4.3 Where the error logs are stored
5.0 Replication (33 Minutes)
5.1 Why Replicate
5.2 Two Methods
5.3 Terms
5.4 Replication Scenarios
5.5 Implementing Replication
5.6 Characteristics of Replication Types
5.7 Planning Replication
5.8 Configuring SQL Server for Replication
5.9 Publication, Subscription and Distribution
|
|
SQL Server 7 0 Administration - 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
-...
