Flylib.com
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
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
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
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Executing SQL Server User-Defined Scalar Functions
Combining Data in Tables from Heterogeneous Data Sources
Binding Data to .NET User Interfaces
Binding Complex Data to Web Forms Controls
Working with XML
CompTIA Project+ Study Guide: Exam PK0-003
IT Project+ Study Guide
Project Initiation
Scope Planning
Project Closure
Appendix A Systems Development Life Cycle
Agile Project Management: Creating Innovative Products (2nd Edition)
Core Agile Values
Envision Summary
Phase: Speculate
Practice: Performance Requirements Cards
The Commitment-Accountability Protocol
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
Reverse Telnet
Split Horizon
Interior Routing Protocols
Configuring a Simple DDR Connection
Tunnels
The Lean Six Sigma Pocket Toolbook. A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity
Using DMAIC to Improve Speed, Quality, and Cost
Value Stream Mapping and Process Flow Tools
Data Collection
Descriptive Statistics and Data Displays
Complexity Value Stream Mapping and Complexity Analysis
.NET System Management Services
Querying WMI
Handling WMI Events
Instrumenting .NET Applications with WMI
The WMI Schema
WMI Providers
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies