eLearning Categories

IT Certification
(MCSE, A+, CCIE, etc)
Security
(CISSP, CWNA, etc.)
.NET Developers
(VB.NET, C#, ASP.NET, etc)
.NET 2005
(ASP.NET v2, SQL 2005, etc))
Developers
(Java, Oracle, etc)
MS Office
(MS Office, MOUS, etc)

 
 

SQL Server 2000 Administration
Video Instructor-Led Format



Audience
Database Administrators, Application developers, programmers, project leaders and other technical individuals that need to acquire the necessary skills to administer SQL Server 2000.
   

Duration

 6 CDs
   
Course Abstract
With the SQL Server 2000 Administration training course, network administrators will learn techniques for installing, configuring, and administering SQL Server 2000. Expert instructor Paul D. Sheriff 's friendly presentation style makes this complex technical subject matter easy to understand. At the conclusion of this course you'll be prepared for successful system administration and be ready to pass exam #70-228, which provides core credit toward MCDBA certification and elective credit toward MCSE certification upon successful completion.
   
Price
Single User (CDROM)
$595.00
Singe User (eLearning Portal)
$450.00
Multi-User LAN (2-5 users)
$1039.00
more than 5 users
Call for Pricing
Program Includes

The following components are included in this course:

  • 6 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components with over 12+ hours of instruction
  • Focused on practical solutions to real-world development
  • Comprehensive, understandable, and reusable as reference material.
   
Course Experts
Paul D. Sheriff is the owner of PDSA Inc., a Microsoft Solutions Provider for Visual Basic and SQL Server. Paul has 10 years experience and is Visual Basic certified. He is one of the top instructors on Visual Basic and speaks at Advisor Developer Conferences and Microsoft TechEd every year. He is also the author of over 25 articles in major publications.

   
Course Topics

The following list represents the sections and topics discussed in this virtual instructor-led course offering.
 
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 Object
  • 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


Administering SQL Server 2000 Level 5
  • 1.0 Replication Concepts
  • 1.1 What is replication?
  • 1.2 The publisher / subscriber metaphor
  • 1.3 Replication Types
  • 2.0 Planning a Replication Strategy
  • 2.1 Basic Requirements
  • 2.2 Autonomy vs. Integrity
  • 2.3 Evaluating Business Objectives
  • 2.4 Physical Replication Models
  • 2.5 2.5 Network Considerations
  • 2.6 Security Issues
  • 2.7 Capacity Planning
  • 2.8 Triggers and Constraints
  • 2.9 Planning Updating Subscribers
  • 3.0 Implementing Snapshot Replication
  • 3.1 How Snapshot Replication Works
  • 3.2 Configuring Snapshot Replication
  • 4.0 Implementing Transactional Replication
  • 4.1 How Transactional Replication Works
  • 4.2 Configuring Transactional Replication
  • 5.0 Merge Replication
  • 5.1 How Merge Replication Works
  • 5.2 Configuring Merge Replication
  • 5.3 Conflict Detection and Resolution
Administering SQL Server 2000 Level 6

  • 1.0 Monitoring and Tuning Replication
  • 1.1 Introduction to the Replication Monitor
  • 1.2 Overview of replication agents
  • 1.3 Viewing Agent History
  • 1.4 Replication Alerts
  • 1.5 Performance issues
  • 2.0 Replication with non-SQL Server Data Sources
  • 2.1 Heterogeneous Subscribers
  • 2.2 Heterogeneous Publishers
  • 3.0 Replication and Database Maintenance
  • 3.1 Backup issues
  • 3.2 Transactional replication and log-shipping
  • 4.0 Overview of Programmatic Replication
  • 4.1 Using ActiveX Controls
  • 4.2 Using the SQL DMO
  • 4.3 The Replication Distributor Interface
  • 4.4 Using Transact SQL Stored Procedures