MCSE Microsoft SQL Training 2000 MCDBA Certification
 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.
SQL 7.0 Training also available
Oracle SQL Training available on CD or Video
|
10 CD Set Server Administration and Implementing & Design for the SQL Server 2000 and Exam Simulator (Exam 70-228 and 70-229)
|
kysq2am
|
$695.00
|
|
|
5 CD Set SQL 2000 Server Data Warehousing Levels 1- 5 Description
|
kysqd2bm
|
$449.95
|
|
|
5 CD Set MCSE SQL 2000 Implementing and Design (I&D) (Exam 70-229) Description
Exam Simulator
|
kysq2bm
|
$395.00
|
|
|
5 CD Set MCSE SQL 2000 Server Administration (SA) (Exam 70-228) Description
Exam Simulator
|
kysq2cm
|
$395.00
|
|
|
16 CD Set Server Administration, Implementing & Design and Data Warehousing CDs
|
kysq2dm
|
$999.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 . . .
|
