Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition - Microsoft Exam 70-228
Course Description:
This course will give the student the skills required to administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000 Enterprise Edition. Upon successful completion of this course, the student will be able to pass the Microsoft 70-228 exam, Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition, which is one of the core electives in the Microsoft's MCSE 2003 and one of the core exams in the Microsoft MCDBA certification program.
Prerequisites:
Candidates should have at least six months to one year of experience administering SQL Server. They also have at least one year of experience implementing relational databases in environments that contain:
Heterogeneous databases.
SQL Server security integrated with Windows Authentication.
Client/server configurations of 50 to 5,000 or more users.
Web configurations that use Microsoft Internet Information Services (IIS) or COM+.
Databases as large as two terabytes.
Multiple installations of SQL Server 2000.
Audience:
Candidates for this course operate in medium to very large computing environments that use Microsoft SQL Server 2000 Enterprise Edition.
Deployment Options:
- Video Training
- CD-ROM
- E-learning
- ThinkTank Server Solution
Learning / Exam module:
MCSA/MCSE Certification - Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition - Microsoft Exam 70-228 Course Duration: 40 hours
About Our Experts:
Elizabeth Hague has been working in the IT Industry with SQL 6.5, 7.0 and 2000 as a consultant and a trainer for almost four years. She possesses extensive hands-on experience including working with migrations from Access to SQL, writing numerous stored procedures that are called from VB, using SQL Server DTS (Data Transformation Services) to transfer data between an AS400 and flat file systems. She has taught preparatory classes for SQL exams as well as classes for
the beginner. Her students leave her classes feeling as if they have a much better understanding of SQL both for real world applications and for examination purposes.
Learning Segments:
Introduction
Chapter One - Overview
SQL Server In A Nutshell
Objects
Introduction To Databases
Chapter Two - Installation
Enterprise Manager/Query Analyzer
SQL Server Agent Service
Introduction To Instances
Installation Wrap-Up
Chapter Three - Authentication & Security
The SQL House
Other Logins And Users
Roles
Permissions
SQL Hierarchy
Chapter Four - Databases And Tables
Creating A Database
Recovery Model
Altering A Database
Filegroups
Tables
Chapter Five - Backing Up & Restoring Databases
4 Backup Methods
Safety Check
Recovery vs. Norecovery
Specific Point In Time
Wrap-Up
Chapter Six - Jobs, Alerts, & Operators
Configuring Email
Operators
Jobs
Alerts
Conclusion
Chapter Seven - Data Transformation Services
Import/Export Wizards
DTS Designer
Executing A Package
Chapter Eight - Replication
Replication Roles
Replication Types
Replication Agents
Push & Pull Subscriptions
Topologies
Chapter Nine - Monitoring & Tuning
Event Viewer
System Monitor
Current Activity Window
Query Execution Plan
Profiler
Index Tuning Wizard
DB Maintenance Plan Wizard
Chapter Ten - Test Information
Resources
