---

MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228

ISBN: N/A
EAN: N/A

Year: 2001
Pages: 126

BUY ON AMAZON

• Cover Page
• LOC
• About This Book
• Intended Audience
• Prerequisites
• Reference Material
• About the CD-ROMs
• Features of This Book
• Chapter and Appendix Overview
• Finding the Best Starting Point for You
• Getting Started
• Technical Support
• 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?
• Review
• Chapter 2 -- Installing SQL Server 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
• Review
• 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
• Review
• 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
• Review
• 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
• Review
• Chapter 6 -- Creating and Configuring User Databases
• 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
• 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
• 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
• 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
• 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
• 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
• Lesson 1: Performing Configuration Tasks
• Lesson 2: Setting Up Additional Features
• Lesson 3: Performing Maintenance Tasks
• Review
• 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
• Review
• 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
• Review
• 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
• Review
• Chapter 16 -- Maintaining High Availability
• Lesson 1: Using Standby Servers
• Lesson 2: Using Failover Clustering
• Review
• Appendix
• Glossary
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• About This Electronic Book
• Create a List of Favorite Topics
• External Links
• Enlarge Graphics
• Use Accessibility Shortcut Keys
• Use the Shortcut Menu Commands
• Customize the Help Viewer
• Print the Current Topic
• Full-Text Search
• Use Full-Text Search
• Advanced Full-Text Search
• Search for Information
• Find Information with Advanced Full-Text Search
• Search for Words or Phrases
• Define Search Terms
• Use Nested Expressions
• Search for Words in the Titles of Topic Files
• Find Words Similar to Your Search Term
• Search Previous Results
• About Microsoft Press