70-228 ALS Microsoft SQL ServerTM 2000 System Administration Package

  • ISBN13:


  • ISBN10:


  • Edition: CD
  • Format: Hardcover
  • Copyright: 2006-10-01
  • Publisher: WILEY
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $181.80


Competency-based learning for the academic classroom.Developed for academic courses, MICROSOFTr SQL SERVER' 2000 SYSTEM ADMINISTRATION helps students build the skills they need on the job and for MCP Exam 70-228-an elective on the Windowsr 2000 MCSE track. The textbook delivers Microsoft courseware adaptable for either a full 16-week semester or a 6-week, 8-week, or 10-week course. The book is filled with competency-based practice exercises that students complete on their own, while the companion project manual features additional skill-building activities ideal for your classroom's computer lab.Along with the textbook and project manual, students get a Student CD-ROM containing study aids, simulation video clips that demonstrate common procedures, an electronic version of the textbook, and detailed information on how to begin a career in Information Technology. Plus, they get a 120-day evaluation version of SQL Server 2000 Enterprise Edition.An Instructor CD-ROM containing a complete set of instructor support materials-including lecture outlines, teaching tips, PowerPoint' slides, test banks, and an instructor lab manual-is also available.

Author Biography

Microsoft Corporation - Founded in 1975, Microsoft (Nasdaq ‘MSFT’) is the worldwide leader in software for personal and business computing. The company offers a wide range of products and services designed to empower people through great software—any time, any place and on any device.

Table of Contents

About This Book
Overview of SQL Server 2000
What Is SQL Server 2000?
What Are the SQL Server 2000 Components?
What Is the Relational Database Architecture?
What Is the Security Architecture?
Installing SQLServer 2000
Planning to Install SQL Server 2000
Deciding SQL Server 2000 Setup Configuration Options
Running the SQL Server 2000 Setup Program
Using Default, Named, and Multiple Instances of SQL Server 2000
Performing Unattended and Remote Installations of SQL Server 2000
Troubleshooting a SQL Server 2000 Installation
Preparing to Use SQL Server 2000
Reviewing the Results of Installation
Starting, Stopping, Pausing, and Modifying SQL Server 2000 Services
Working with Osql, SQL Query Analyzer, and SQL Server Enterprise Manager
Upgrading to SQL Server 2000
Preparing to Upgrade
Performing a Version Upgrade from SQL Server 7.0
Performing an Online Database Upgrade from SQL Server 7.0
Performing a Version Upgrade from SQL Server 6.5
Understanding System and User Databases
Understanding the Database Architecture
Understanding the Transaction Log Architecture
Understanding and Querying System and Database Catalogs
Creating and Configuring User Databases
Creating a User Database
Setting Database Options
Managing User Database Size Using Automatic File Growth Appropriately
Placing Database Files on Multiple Disks
Populating a Database
Transferring and Transforming Data
Introducing Microsoft Data Transformation Services (DTS)
Transferring and Transforming Data with DTS Graphical Tools
Working with DTS Packages
Using the Bulk Copy Program (Bcp) and the BULK INSERT Transact-SQL Statement
Developing a Data Restoration Strategy
Understanding Data Restoration Issues
Understanding the Types of Database Backups
Understanding the Restoration Process
Backing Up and Restoring SQL Server
Understanding Backup Terms, Media, and Devices
Backing Up Databases, Files, Filegroups, and Transaction Logs
Restoring a User Database
Restoring and Rebuilding System Databases
Managing Access to SQL Server 2000
Understanding the Authentication Process
Understanding the Authorization Process
Creating and Managing Logins
Managing SQL Server Permissions
Granting Database-Specific Permissions
Using Application Roles
Designing an Access and Permissions Strategy
Performing Administrative Tasks
Performing Configuration Tasks
Setting Up Additional Features
Performing Maintenance Tasks
Automating Administrative Tasks
Defining Operators
Creating Jobs
Configuring Alerts
Creating a Database Maintenance Plan
Creating Multiserver Jobs
Monitoring SQL Server Performance and Activity
Developing a Performance Monitoring Methodology
Choosing Among Monitoring Tools
Performing Monitoring Tasks
Using SQL Server Replication
Introducing Replication
Planning for Replication
Implementing Replication
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review