Publisher: Microsoft Press Released: June 2003 Pages: 1024
Learn how to install, configure, and troubleshoot SQL Server 2000—and prepare for the Microsoft Certified Professional (MCP) exam—with this official Microsoft study guide. Work at your own pace through the lessons and hands-on exercises. And use the special exam-prep section and testing tool to measure what you know and where to focus your studies—before taking the actual exam. As you build real-world database administration expertise, you’re also preparing for MCP Exam 70-228—a core exam on the MCDBA track and an elective on the MCSA and MCSE tracks. Build the skills to: - Install or upgrade to SQL Server 2000
- Configure database options—capacity, connectivity, and performance
- Automate data transfer and manipulation with Data Transformation Services (DTS) packages
- Use SQL Server replication services
- Manage security features—authentication, logins, permissions, and alerts
- Monitor and fine-tune system performance with tools such as SQL Server Agent, SQL Profiler, and the Windows® System Monitor
- Perform backups and restorations
Ready for the exam? Take practice tests on the CD. Your kit includes: - Comprehensive self-paced study guide that maps to MCP exam goals and objectives
- NEW—Test-readiness tool that generates timed, 50-question practice exams with automated scoring
- NEW—More than 200 pages of exam prep and objective-by-objective review
- Learn-by-doing exercises for skills you can apply to the job
- 120-day evaluation version of SQL Server 2000 Enterprise Edition
- Fully searchable eBook?plus sample databases and technical white papers—on CD
A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com. |
-
Self-Paced Training for Microsoft SQL Server 2000 System Administration -
Chapter 1 Overview of SQL Server 2000 - About This Chapter
- 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?
- Review
-
Chapter 2 Installing SQL Server 2000 - About This Chapter
- 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
- Review
-
Chapter 3 Preparing to Use SQL Server 2000 - About This Chapter
- 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
- Review
-
Chapter 4 Upgrading to SQL Server 2000 - About This Chapter
- 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
- Review
-
Chapter 5 Understanding System and User Databases - About This Chapter
- Lesson 1: Understanding the Database Architecture
- Lesson 2: Understanding the Transaction Log Architecture
- Lesson 3: Understanding and Querying System and Database Catalogs
- Review
-
Chapter 6 Creating and Configuring User Databases - About This Chapter
- Lesson 1: Creating a User Database
- Lesson 2: Setting Database Options
- Lesson 3: Managing User Database Size
- Lesson 4: Placing Database Files on Multiple Disks
- Review
-
Chapter 7 Populating a Database - About This Chapter
- 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
- Review
-
Chapter 8 Developing a Data Restoration Strategy - About This Chapter
- Lesson 1: Understanding Data Restoration Issues
- Lesson 2: Understanding the Types of Database Backups
- Lesson 3: Understanding the Restoration Process
- Review
-
Chapter 9 Backing Up and Restoring SQL Server - About This Chapter
- 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
- Review
-
Chapter 10 Managing Access to SQL Server 2000 - About This Chapter
- Lesson 1: Understanding the Authentication Process
- Lesson 2: Understanding the Authorization Process
- Lesson 3: Creating and Managing Logins
- Review
-
Chapter 11 Managing SQL Server Permissions - About This Chapter
- Lesson 1: Granting Database-Specific Permissions
- Lesson 2: Using Application Roles
- Lesson 3: Designing an Access and Permissions Strategy
- Review
-
Chapter 12 Performing Administrative Tasks - About This Chapter
- Lesson 1: Performing Configuration Tasks
- Lesson 2: Setting Up Additional Features
- Lesson 3: Performing Maintenance Tasks
- Review
-
Chapter 13 Automating Administrative Tasks - About This Chapter
- Lesson 1: Defining Operators
- Lesson 2: Creating Jobs
- Lesson 3: Configuring Alerts
- Lesson 4: Creating a Database Maintenance Plan
- Lesson 5: Creating Multiserver Jobs
- Review
-
Chapter 14 Monitoring SQL Server Performance and Activity - About This Chapter
- Lesson 1: Developing a Performance Monitoring Methodology
- Lesson 2: Choosing Among Monitoring Tools
- Lesson 3: Performing Monitoring Tasks
- Review
-
Chapter 15 Using SQL Server Replication - About This Chapter
- Lesson 1: Introducing Replication
- Lesson 2: Planning for Replication
- Lesson 3: Implementing Replication
- Lesson 4: Monitoring and Administering Replication
- Review
-
Chapter 16 Maintaining High Availability - About This Chapter
- Lesson 1: Using Standby Servers
- Lesson 2: Using Failover Clustering
- Review
-
Preparation for MCP Exam 70-228 -
Chapter 17 Objective Domain 1: Installing and Configuring SQL Server 2000 - Tested Skills and Suggested Practices
- Objective 1.1: Install SQL Server 2000.
- Objective 1.2: Upgrade to SQL Server 2000.
- Objective 1.3: Create a linked server.
- Objective 1.4: Configure SQL Mail and SQLAgentMail.
- Objective 1.5: Configure network libraries.
- Objective 1.6: Troubleshoot failed installations.
-
Chapter 18 Objective Domain 2: Creating SQL Server 2000 Databases - Tested Skills and Suggested Practices
- Objective 2.1: Configure database options for performance.
- Objective 2.2: Attach and detach databases.
- Objective 2.3: Create and alter databases.
- Objective 2.4: Create and manage objects.
-
Chapter 19 Objective Domain 3: Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases - Tested Skills and Suggested Practices
- Objective 3.1: Optimize database performance.
- Objective 3.2: Optimize data storage.
- Objective 3.3: Modify the database schema.
- Objective 3.4: Perform disaster recovery operations.
- Objective 3.5: Perform integrity checks.
- Objective 3.6: Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL.
-
Chapter 20 Objective Domain 4: Extracting and Transforming Data with SQL Server 2000 - Tested Skills and Suggested Practices
- Objective 4.1: Set up Internet Information Services (IIS) virtual directories to support XML.
- Objective 4.2: Import and export data.
- Objective 4.3: Develop and manage Data Transformation Services (DTS) packages.
- Objective 4.4: Manage linked servers.
- Objective 4.5: Convert data types.
- Objective 4.6: Configure, maintain, and troubleshoot replication services.
-
Chapter 21 Objective Domain 5: Managing and Monitoring SQL Server 2000 Security - Tested Skills and Suggested Practices
- Objective 5.1: Configure mixed security modes or Windows Authentication.
- Objective 5.2: Create and manage logons.
- Objective 5.3: Create and manage database users.
- Objective 5.4: Create and manage security roles.
- Objective 5.5: Enforce and manage security by using stored procedures, triggers, views, and user-defined functions.
- Objective 5.6: Set permissions in a database.
- Objective 5.7: Manage security auditing.
-
Chapter 22 Objective Domain 6: Managing, Monitoring, and Troubleshooting SQL Server 2000 - Tested Skills and Suggested Practices
- Objective 6.1: Create, manage, and troubleshoot SQL Server Agent jobs.
- Objective 6.2: Configure alerts and operators by using SQL Server Agent.
- Objective 6.3: Optimize hardware resource usage.
- Objective 6.4: Optimize and troubleshoot SQL Server system activity.
-
Appendix Questions and Answers -
: Overview of SQL Server 2000 -
Chapter 2: Installing SQL Server 2000 -
Chapter 3: Preparing to Use SQL Server 2000 -
Chapter 4: Upgrading to SQL Server 2000 -
Chapter 5: Understanding System and User Databases -
Chapter 6: Creating and Configuring User Databases -
Chapter 7: Populating a Database -
Chapter 8: Developing a Data Restoration Strategy -
Chapter 9: Backing Up and Restoring SQL Server -
Chapter 10: Managing Access to SQL Server 2000 -
Chapter 11: Managing SQL Server Permissions -
Chapter 12: Performing Administrative Tasks -
Chapter 13: Automating Administrative Tasks -
Chapter 14: Monitoring SQL Server Performance and Activity -
Chapter 15: Using SQL Server Replication -
Chapter 16: Maintaining High Availability -
Glossary -
Appendix -
Appendix System Requirements |
- Title:
- MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server™ 2000 System Administration, Exam 70-228, 2nd Edition
- By:
- Microsoft Corporation
- Publisher:
- Microsoft Press
- Formats:
-
- Print
- Ebook
- Safari Books Online
- Print:
- June 2003
- Ebook:
- January 2010
- Pages:
- 1024
- Print ISBN:
- 978-0-7356-1961-6
- | ISBN 10:
- 0-7356-1961-1
- Ebook ISBN:
- 978-0-7356-9224-4
- | ISBN 10:
- 0-7356-9224-6
|
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
 |
|
 |
|
|
|
Recommended for You
|
Recently Viewed
|
 |
|
By G. Andrew Duthie
April 2003
By Microsoft Corporation
April 2003
By Microsoft Corporation
January 2003
Ebook: $39.99
Print: $49.99
|
Customer Reviews
|
|
|