MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
ISBN: N/A
EAN: N/A
EAN: N/A
Year: 2001
Pages: 126
Pages: 126
- 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
MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
ISBN: N/A
EAN: N/A
EAN: N/A
Year: 2001
Pages: 126
Pages: 126
- Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
- Performing Multiple-table Queries and Creating SQL Data Views
- Understanding Transaction Isolation Levels and Concurrent Processing
- Working with Data BLOBs and Text
- Monitoring and Enhancing MS-SQL Server Performance