Exam # 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition (Exam # 70-228) is an elective requirement for MCSE (Microsoft Certified Systems Engineer) on Windows 2000. It is also a core requirement for the MCDBA (Microsoft Certified Database Administrator) on SQL Server 2000 certification. It is designed for candidates who operate in medium to very large computing environments that use Microsoft SQL Server 2000 Enterprise Edition. In addition, we cover the following topics:

Chapter 1: Introduction to SQL Server 2000

• SQL Server Goal
• SQL Platforms
• System Requirements
• Architecture Enhancement
• Server Editions
• File Locations
• Domain Login
• Network Protocol
• Basic & Post Installation
• Register Server/Check/Verify Logins
• Network Libraries
• Start/Stop Services
• Verify Directories

Chapter 2: Troubleshooting Installations

• Common Install Failures
• SQL Agent Issues
• Client Issues
• Named Pipes
• TCP/IP

Chapter 3: Upgrade Methods

• Upgrade Methods
• Requirements & Data Transfer Method
• Upgrade Checklist & Wizard
• Online Database Upgrade
• Upgrade & Replication
• Installation Upgrade

Chapter 4: Server & Database Security

• Basic Steps
• Logon Methods & SQL Login Commands
• Authentication Mode & Group Usage
• Add SQL User & NT User Group
• Adding Users, New Users & Login
• Disable Guest
• Database User Command
• Object Permissions, Rules & References
• Chain of Ownership & Issues
• Server & Databse Fixed Roles

Chapter 5: Creating & Managing Databases

• Databases in SQL Server
• Master/Model/Temp db/MSdb/Distribution
• Database Objects
• File Types/Pages
• Storage Management
• Filegroups & Maintenance
• Using Alter Database
• Changing Database Options
• Rules of Thumb for Logs

Chapter 6: Introduction to Constraints

• Create Default Constraint
• Check Constraint Abilities
• Add Records Using Check Constraints
• Table Level Constraints
• Create Primary Key & Unique Constraints
• Foreign Key Constraints
• Disabling Constraints

Chapter 7: Indexes

• Indexes & Data Storage/Access
• Clustered/Non-Clustered Index
• Index Maintenance
• Tips for Using Indexes
• Create/Execute Using Stored Procedures

Chapter 8: Triggers

• Planning Use of Triggers
• Inserted/Deleted Table
• Create & Using Triggers

Chapter 9: Views

• Planning Use of Views
• Details of Views
• Customize & Insert in Views
• Indexed View
• Set Stats/Execution Plan
• Partitioned Views

Chapter 10: Database Backup

• Why Backups?
• Backup Models
• Full Recovery
• Bulk-Logged Recovery
• Simple Recovery
• Permissions Required
• Backup Methods
• Using Dump Device
• Enterprise Manager
• Backup Transaction Logs
• Normal Log Backup
• Long Transactions
• Standard Scenario
• Large Database Backup
• Backup Performance

Chapter 11: Restore & Recovery

• Automatic Recovery
• Transaction Log with Recovery
• Restore Process & Options
• Restore Scenario
• Restore Database
• Basic Restore Commands

Chapter 12: High Availability Solutions

• Standby Server
• Log Shipping
• Starting SQL Agent
• Setup Backup Criteria
• Troubleshooting Log Shipping
• User/Login Mapping
• Cluster Server
• Log vs. Cluster

Chapter 13: Relocating Data

• Attach/Detach Database
• Create DTS Package
• Transform Data & Lineage
• Use DTA Wizard
• Change Data Type
• Export/Import DTS

Chapter 14: Replication Overview

• Why Replication
• Replication vs. DTS
• Roles & Language
• Publications/Articles
• Publisher/Subscriber
• Remote Distribution
• Types of Replication
• Implementing Replication
• Replication Monitor
• Troubleshooting Replication
• Internet/Heterogeneous Replication

Chapter 15: Linked Servers

• Distributed Query
• Setting Up a Linked Server
• Linked Server Options
• Troubleshooting Linked Servers
• Create Linked Server
• Link to Excel Spreadsheet
• Server Automation
• Setup Mail Integration
• Test Mail Integration
• Managing Automation
• Multiple Operator Notification
• Performance Monitor Alert
• Failsafe Operator/Master Server Wizard
• Automation Troubleshooting
• Using SQL Mail
• Mail Troubleshooting

Chapter 16: Monitoring SQL Server

• Memory Monitoring
• Processor Monitoring
• Disk I/O Monitoring
• System Monitor
• Optimize Processor Use
• Monitoring Locks
• Locks in Enterprise Manager
• Using Profiler
• Server Configuration

Chapter 17: Optimizing Database Performance

• External Fragmentation
• Data Fragmentation
• Index Statistics
• Query Statistics
• Execution Plans
• Optimize Queries<
• Re-Compiling Stored Procedures

Chapter 18: IIS Virtual Directory

• Creating the Virtual Directory
• Configure XML Support
• Using Internet Explorer with SQL

Would you like to learn MS-SQL Server 2000 (MCSE/MCDBA Certification) Course? We provide home tutoring service. We also provide Networking Service at your home or office.

Please contact us for any additional information.

---