|
More on Single User, Multi User & Network Licences
More on Online Training
PACKAGE INCLUDES6 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components Printable courseware Step-by-step hands-on-labs Focused on practical solutions to real-world development problems
COURSE INTRODUCTIONSchedule our instructor led classroom training 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 Kenneth Mayer'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.
|
COURSE OUTLINE
|
Level 11.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
| Level 21.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
| Level 31.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
| Level 41.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
| Level 51.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
| Level 61.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
|
|