MCP 70-228 SQL Server 2000 Administration Training Course

MCP 70-228 SQL Server 2000 Administration Training Package Includes

• 6 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 Introduction

Schedule 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.
 

PRESENTER - Kenneth Mayer Kenneth Mayer - Certified CEH Trainer (CCSI, MCT, CCNP, CCDA) Ken Mayer is a Microsoft Certified Trainer as well as a Certified Ethical Hacker Trainer and Security consultant. He started his career in computer technology in 1980s. He has offered a wide variety of IT training and high level consulting projects for Fortune 500 companies across the United States and Western Europe. He has achieved the Certified Cisco Systems Instructor certification. The CCSI certification involved a two-day lab and observation event held on Cisco in Paris, France Facility. This gave Ken the accreditation to be able to deliver Cisco Authorized Courses as a CCSI. He has taught the full line of Cisco CCNA, CCDA, CCNP, CCDP and CCIP course curriculums, including Cisco's security appliances such as PIX and IDS.

List of Course Features

MCP 70-228 SQL Server 2000 Administration Course Contents
 

Level 1: 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 2: 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 3: 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 4: 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 5: 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 6: 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