Rabeler C. MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228 / Table of content

Computers & Technology
Education & Reference
Business & Investing
Science & Math

Table of content

MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
Authors: Rabeler C.
Published year: 2001
Pages: 1/126

Buy this book on amazon.com >>

Cover Page
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

MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
Authors: Rabeler C.
Published year: 2001
Pages: 1/126

Buy this book on amazon.com >>