Microsoft SQL 7.0 Administration Training Course
MCSE WINDOWS and SQL 2000 Training CDs and Videos
|
Four CD Administration Set Details
|
kysq7mb
|
$99.95
|
|
|
Four CD Implementing SQL 7 Set Details
|
kysq7ma
|
$99.95
|
|
|
Set of all Twelve CD-ROMS Both Administration Implementing and Data Warehouse
|
kysq7mc
|
$129.95
|
|
Microsoft SQL 7 Administration Course Content
SQL Server 7 Administration Level 1 (2 Hours 9 Minutes)
1.0 Overview of the Features of SQL Server (21 Minutes)
1.1 Why you want to use SQL Server
1.2 Features and capacities of SQL Server
2.0 Installation of SQL Server (54 Minutes)
2.1 Walk through of the installation options
2.2 Which options are critical to a successful installation
2.3 Performing the Installation
2.4 Upgrading from a previous version of SQL Server
3.0 Database Setup and Maintenance (51 Minutes)
3.1 Database Objects
3.2 Looking at Schema Views
3.3 System Stored Procedures
3.4 Database Creation
3.5 Files and FileGroups
3.6 Transaction log management
3.7 Database growth
3.8 Expanding and Shrinking
3.9 Performance Considerations
SQL Server 7 Administration Level 2 (2 Hours 3 Minutes)
1.0 Security in SQL Server (1 Hour 6 Minutes)
1.1 Introduction to Security
1.2 Special ID's and Authentication
1.3 Logins
1.4 Roles & Users
1.5 Permissions
1.6 Planning for Security
1.7 Views and Stored Procedures
1.8 Application Role
2.0 Operators, Jobs, Alerts and Mail (1 Hour 8 Minutes)
2.1 Definitions
2.2 SQL Server Agent
2.3 Operators
2.4 Jobs
2.5 Alerts
2.6 SQL Mail
SQL Server 7 Administration Level 3 (2 Hours 3 Minutes)
1.0 The Database Consistency Checker (28 Minutes)
1.1 Definition and Statements
1.2 How to run DBCC Statements
2.0 Backup and Restore (55 Minutes)
2.1 Planning and Maintenance issues
2.2 Performing a backup
2.3 Restoring a database
3.0 Database Maintenance Plan Wizard (12 Minutes)
3.1 What is the DMPW
3.2 Setting up a database maintenance plan & Running the wizard
4.0 Using the Web Assistant (27 Minutes)
4.1 What is the Web Assistant & How to use it
4.2 Viewing the output
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
|
