Skip to main content

70-228 ALS Microsoft® SQL ServerTM 2000 System Administration Package

70-228 ALS Microsoft® SQL ServerTM 2000 System Administration Package

Microsoft Official Academic Course

ISBN: 978-0-470-06580-8

Aug 2001

896 pages

Select type: Hardcover

Product not available for purchase


Competency-based learning for the academic classroom.

Developed for academic courses, MICROSOFT® 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 Windows® 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.

Related Resources

About This Book.

Chapter 1: Overview of SQL Server 2000.

Lesson 1: What Is SQL Server 2000?

Lesson 2: What Are the SQL Server 2000 Components?

Lesson 3: What Is the Relational Database Architecture?

Lesson 4: What Is the Security Architecture?

Chapter 2: Installing SQLServer 2000.

Lesson 1: Planning to Install SQL Server 2000.

Lesson 2: Deciding SQL Server 2000 Setup Configuration Options.

Lesson 3: Running the SQL Server 2000 Setup Program.

Lesson 4: Using Default, Named, and Multiple Instances of SQL Server 2000.

Lesson 5: Performing Unattended and Remote Installations of SQL Server 2000.

Lesson 6: Troubleshooting a SQL Server 2000 Installation.

Chapter 3: Preparing to Use SQL Server 2000.

Lesson 1: Reviewing the Results of Installation.

Lesson 2: Starting, Stopping, Pausing, and Modifying SQL Server 2000 Services.

Lesson 3: Working with Osql, SQL Query Analyzer, and SQL Server Enterprise Manager.

Chapter 4: Upgrading to SQL Server 2000.

Lesson 1: Preparing to Upgrade.

Lesson 2: Performing a Version Upgrade from SQL Server 7.0.

Lesson 3: Performing an Online Database Upgrade from SQL Server 7.0.

Lesson 4: Performing a Version Upgrade from SQL Server 6.5.

Chapter 5: Understanding System and User Databases.

Lesson 1: Understanding the Database Architecture.

Lesson 2: Understanding the Transaction Log Architecture.

Lesson 3: Understanding and Querying System and Database Catalogs.

Chapter 6: Creating and Configuring User Databases.

Lesson 1: Creating a User Database.

Lesson 2: Setting Database Options.

Lesson 3: Managing User Database Size Using Automatic File Growth Appropriately.

Lesson 4: Placing Database Files on Multiple Disks.

Chapter 7: Populating a Database.

Lesson 1: Transferring and Transforming Data.

Lesson 2: Introducing Microsoft Data Transformation Services (DTS).

Lesson 3: Transferring and Transforming Data with DTS Graphical Tools.

Lesson 4: Working with DTS Packages.

Lesson 5: Using the Bulk Copy Program (Bcp) and the BULK INSERT Transact-SQL Statement.

Chapter 8: Developing a Data Restoration Strategy.

Lesson 1: Understanding Data Restoration Issues.

Lesson 2: Understanding the Types of Database Backups.

Lesson 3: Understanding the Restoration Process.

Chapter 9: Backing Up and Restoring SQL Server.

Lesson 1: Understanding Backup Terms, Media, and Devices.

Lesson 2: Backing Up Databases, Files, Filegroups, and Transaction Logs.

Lesson 3: Restoring a User Database.

Lesson 4: Restoring and Rebuilding System Databases.

Chapter 10: Managing Access to SQL Server 2000.

Lesson 1: Understanding the Authentication Process.

Lesson 2: Understanding the Authorization Process.

Lesson 3: Creating and Managing Logins.

Chapter 11: Managing SQL Server Permissions.

Lesson 1: Granting Database-Specific Permissions.

Lesson 2: Using Application Roles.

Lesson 3: Designing an Access and Permissions Strategy.

Chapter 12: Performing Administrative Tasks.

Lesson 1: Performing Configuration Tasks.

Lesson 2: Setting Up Additional Features.

Lesson 3: Performing Maintenance Tasks.

Chapter 13: Automating Administrative Tasks.

Lesson 1: Defining Operators.

Lesson 2: Creating Jobs.

Lesson 3: Configuring Alerts.

Lesson 4: Creating a Database Maintenance Plan.

Lesson 5: Creating Multiserver Jobs.

Chapter 14: Monitoring SQL Server Performance and Activity.

Lesson 1: Developing a Performance Monitoring Methodology.

Lesson 2: Choosing Among Monitoring Tools.

Lesson 3: Performing Monitoring Tasks.

Chapter 15: Using SQL Server Replication.

Lesson 1: Introducing Replication.

Lesson 2: Planning for Replication.

Lesson 3: Implementing Replication.

Lesson 4: Monitoring and Administering Replication.

Chapter 16: Maintaining High Availability.

Lesson 1: Using Standby Servers.

Lesson 2: Using Failover Clustering.




  • Competency Based: Emphasizes learning by doing. The book has exercises designed to give students plenty of opportunity to practice the skills needed to install, configure and troubleshoot SQL Server 2000. Included in the book is a 120-Day Evaluation copy of SQL Server 2000 Enterprise Edition that enables the student to install SQL Server 2000 on a home PC to complete the in-text exercises. A lab manual with exercises designed for networked classroom labs is shrink wrapped with the book.
  • Complete Learning Program: Delivers everything the student needs to learn how to do the job and prepare for the MCP exam # 70-228. Written in a clear and straightforward manner, the textbook contains numerous learning aids designed to help the student master the material:
  • Tips explaining possible results or alternative methods
  • Important notations with information that is essential to completing a task
  • Notes containing supplemental information
  • Cautions containing warnings about potential problems to look out for
  • Complete Instructor Support Program: Instructor CD accompanies the book with a complete set of teaching aids:
  • Model Course Description
  • Alternate course syllabi
  • Lecture outlines imbedded with teaching tips and suggestions for using PowerPoint slides
  • PowerPoint slides
  • Course pre-test
  • Test bank containing true false, multiple choice, short answer and scenario based question
  • Microsoft SQL Server 2000 Enterprise Edition Software: A 120-Day evaluation copy of Microsoft SQL Server Enterprise Edition software comes with the book. This CD allows the student to install Windows SQL Server 2000 at home to practice the skills needed to do the job. Many instructors use this CD to support the course lab work.