|
SQL 2000 Server Admin Training MCDBA Exam 70-228
PN-320275
Price: $450
Product Options
- Single user license
- Multiuser site license (add $445)
Detailed Description
Schedule our instructor led classroom trainings at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the best SQL Trainers in the industry to help us develop the ultimate training & certification program.
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.
Included in this Program
- 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 Outline
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
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 |
|
