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
Certified Ethical Hacker Exam Prep
Key Terms
Wireless TechnologiesA Brief History
Apply Your Knowledge
Summary
Trojans and Backdoors
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Identifying Project Scope Risk
Identifying Project Resource Risk
Managing Activity Risks
Quantifying and Analyzing Project Risk
Conclusion
Adobe After Effects 7.0 Studio Techniques
Uber-mastery
Conclusion
Storytelling and the Camera
Film 101
Creating a Look with Color
Managing Enterprise Systems with the Windows Script Host
Introduction
Networking Resources
Network Administration/WMI
Internet Applications
Security
The Lean Six Sigma Pocket Toolbook. A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity
Working with Ideas
Value Stream Mapping and Process Flow Tools
Descriptive Statistics and Data Displays
Variation Analysis
Identifying and Verifying Causes
Quantitative Methods in Project Management
Introduction to Probability and Statistics for Projects
Making Quantitative Decisions
Risk-Adjusted Financial Management
Expense Accounting and Earned Value
Quantitative Methods in Project Contracts
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