Home Page Training
SQL 7 Administration
SQL 7 Programming
SQL Training 2000 Admin
SQL Data Warehouse
SQL 2000 Programming

MCSE Microsoft SQL Training 2000

MCDBA

MCP

MCSA

MCSD

MCSE

MOUS

This course teaches you to administer and troubleshoot information systems that incorporate the SQL Server 2000 Enterprise Edition. Learn how to install and configure a SQL 2000 Server, create SQL 2000 databases, manage, monitor and troubleshoot SQL 2000 databases, extract and transform data and manage and monitor SQL 2000 security. Available on 11 videos, the entire course prepares you for Exams 70-228 and 70-229.

MS SQL Server Training 2000 Administration and Programming Training Videos CDs for MCSE, MCDBA Certification

SQL 7.0 Training also available

Oracle SQL Training available on CD or Video

10 Video Set Server Administration and Implementing & Design Programming for the SQL Server 2000 with and Exam Simulator (Exam 70-228 and 70-229)

kysq2a

$795.00

10 CD Set Server Administration and Implementing & Design for the SQL Server 2000 and Exam Simulator (Exam 70-228 and 70-229)

kysq2am

$795.00

5 Video Set SQL 2000 Server Data Warehousing Levels 1- 5 Description

kysqd2b

$449.95

5 CD Set SQL 2000 Server Data Warehousing Levels 1- 5 Description

kysqd2bm

$449.95

5 Video Set MCSE SQL 2000 Implementing and Design (I&D) (Exam 70-229) Description
Exam Simulator

kysq2b

$395.00

5 CD Set MCSE SQL 2000 Implementing and Design (I&D) (Exam 70-229) Description
Exam Simulator

kysq2bm

$395.00

5 Video Set MCSE SQL 2000 Server Administration (SA) (Exam 70-228) Description
Exam Simulator

kysq2c

$395.00

5 CD Set MCSE SQL 2000 Server Administration (SA) (Exam 70-228) Description
Exam Simulator

kysq2cm

$395.00

16 Video Set Server Administration, Implementing & Design and Data Warehousing Videos

kysq2d

$1299.95

16 CD Set Server Administration, Implementing & Design and Data Warehousing CDs

kysq2dm

$1299.95

Course Outlines: SQL Server Administration MCSE Training

Administering SQL Server 2000 Level 1 (2 hrs 2 mins)

1.0 An Overview of SQL Server (32 mins)
1.1 Why use SQL Server?
1.2 Graphical Tools
1.3 Transact SQL
1.4 Database Objects
1.5 Security
1.6 Services
1.7 Capacities
1.8 Connectivity
1.9 Other Features
2.0 Installing SQL Server 2000 (36 mins)
2.1 Operating Systems
2.2 Versions & Configurations
2.3 Multiple Instances
2.4 Licensing
2.5 File Locations
2.6 Sort Orders
2.7 Types of Installations
2.8 Installation Checklist
2.9 Performing an Installation

2.10 Upgrading
2.11 Troubleshooting an Upgrade
2.12 Unattended Installations
3.0 Database Setup and Maintenance (54 mins)
3.1 Database Objects
3.2 System Stored Procedures & Functions
3.3 Database Layout
3.4 Database Files & File Groups
3.5 Transaction Log
3.6 Database Growth
3.7 Creating Databases using Enterprise Manager
3.8 Creating Databases using T-SQL
3.9 Sp-helpdb
3.10 Expanding a Database
3.11 Shrinking a Database
3.12 Database Options
3.13 Recovery Models
3.14 Database Space Planning
3.15 Multiple Disk Usage

Administering SQL Server 2000 Level 2 (2 hrs 11 mins)

1.0 Security (56 mins)
1.1 Introduction to Security
1.2 Authentication
1.3 Creating Logins
1.4 Server Roles
1.5 Assigning Server Roles
1.6 Database Roles
1.7 Managing Database Roles
1.8 Permissions
1.9 Managing Permissions
1.10 Views and Security
1.11 Stored Procedures and Security
1.12 Application Roles

2.0 Operators, Jobs, Alerts & Mail (1 hr 15 mins)
2.1 Definitions
2.2 SQL Server Agent Configuration
2.3 Operators
2.4 Jobs
2.5 Alerts
2.6 SQL Mail
2.7 Troubleshooting

Administering SQL Server 2000 Level 3 (2 hrs 4 mins)

1.0 DBCC (23 mins)
1.1 Maintenance Statements
1.2 Pin Statements
1.3 Trace Flags
1.4 Informational Statements
1.5 Check Statements
1.6 Old Statements
2.0 Backup and Restore (42 mins)
2.1 Why do a Backup?
2.2 Considerations of the Backup Process
2.3 Managing the Backup Devices
2.4 System Database Backup
2.5 Multiple Backup Devices
2.6 Backup Planning
2.7 Media Choices
2.8 Backup Types
2.9 Backup Scenarios
2.10 Copying/Moving
2.11 Stand-by Servers & Clustering
2.12 Performing a Backup
2.13 Restore a Backup

3.0 Database Maintenance Plan Wizard (14 mins)
3.1 What is the DMPW?
3.2 Running the Wizard
3.3 Jobs Created by the Wizard
4.0 Web Assistant (19 mins)
4.1 What is the Web Assistant?
4.2 Running the Web Assistant
4.3 Using a Template File
4.4 Triggers generated by Web Assistant
5.0 SQL Server Configuration Options (26 mins)
5.1 SQL Server Registration Properties
5.2 SQL Server Properties Dialog

Administering SQL Server 2000 Level 4 (1 hr 42 mins)

1.0 Transferring Objects & Scripting (32 mins)
1.1 Methods of Data Transfer
1.2 DTS Designer
1.3 Copy Database Wizard
1.4 sp_attach_db and sp_detach_db
1.5 Scripting Objects
2.0 Error Logs (13 mins)
2.1 Windows Event Logs
2.2 SQL Server Error Logs
2.3 Demo of Windows Logs
2.4 Demo of SQL Server Logs

3.0 Distributed Management Objects (20 mins)
3.1 DMO Object Hierarchy
3.2 Logging into SQL Server
3.3 Loading a list of Databases
3.4 Loading Tables
3.5 Users & Table Scripts
3.6 Indexes & Columns
4.0 Tips & Tricks (37 mins)
4.1 General Tips & Tricks

More: Implementing and Design Programming course descriptions . . .

This study guide and/ or material is not sponsored by, endorsed by or affiliated with Cisco Systems, Inc. Cisco®, Cisco Systems®, CCDA™, CCNA™, CCDP™, CCNP™, CCIE™, CCSI™, the Cisco Systems logo and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc.

*30-Day Guarantee applies only if products purchased are returned with 50% of product unopened. For example if product purchased contains 6 videos, 3 must remain unopened.