Introduction to PART I
1. Microsoft SQL Server 2000 Overview
SQL Server system
SQL Server 2000 features and new features
Summary of this chapter.
2. Microsoft Windows 2000 Platform
Windows 2000 family
WINDOWS 2000 components and features
Summary of this chapter.
3. Microsoft SQL Server Database Administrator's role and task Microsoft Windows 2000 Platform
SQL SEVER DBA Basic / Selection Work Project
DBA small technology
Summary of this chapter.
PART II installation and setting
4. Design Microsoft SQL Server System
. system requirement
Components and options
Database arrangement
. application
Summary of this chapter.
5. Setting and planning the I / O subsystem
Disk system characteristics
- Disk array overview
. Concept of I / O subsystem
Common RAID level overview
RAID hierarchy comparison
. I / O Delayed and SQL Server
Planning SQL Server Disk Architecture
Skills and suggestions for I / O subsystem
Summary of this chapter.
6. Capacity plan
Capacity plan
Capacity planning history
Transaction
Principle of capacity planning
Memory planning
Processor's capacity planning
Sprinkler system capacity planning
Internet capacity plan
. Select information collected
Summary of this chapter.
7. Install Microsoft SQL Server
Install Microsoft SQL Server 2000
Old upgrade
User installation
Summary of this chapter.
8. Manage Microsoft SQL Server Services
SQL Server service components
. Use the SQL Server service administrator
. Using the Windows 2000 Service Control Administrator
. Using SQL Server Enterprise Manager
Summary of this chapter.
9. Establish a database
Database structure
System database
Establish a database
View database
Delete database
Summary of this chapter.
10. Establish a database
Basic work deployment
Basic concept of information sheet.
Establish a data sheet in the archives group
Use null value
Increase Identity property
Establish information table with Enterprise Manager
Summary of this chapter.
11. Network settings for Microsoft SQL Server
Online service overview
. SQL Server application interface
Network program
. Network components and SQL Server Efficacy
Internet monitoring
Summary of this chapter.
12. Microsoft SQL Server and Microsoft Cluster Services
Fault type
MSCS Overview
Example of a cluster system.
SQL Server Cluster Settings
Beyond MSCS
Summary of this chapter.
Part III uses Microsoft SQL Server
13. T-SQL and SQL Query Analyzer
What is SQL?
What is T-SQL?
New features for T-SQL
How to use T-SQL
Summary of this chapter.
14. Retrieve data using T-SQL
SELECT statement
. Use the T-SQL function
SELECT Other Uses
Summary of this chapter.
15. Use Transact-SQL and Enterprise Manager management information sheets
. Use T-SQL to modify the information sheet
. Use Enterprise Manager to modify the information sheet
The impact of the modification of the data sheet
Delete information list
Summary of this chapter.
16. Establish and use preset values, conditional constraints and rules
. default value
Conditional constraint
Rule object
Summary of this chapter.
17. Establish and use indexes
What is an index?
Index concept
Establish index
Restipation index
. Using an index
Design effective index
Summary of this chapter.
18. Establishment and use of the view table
What is the viewing table?
Viewing table concept
Establish a view
Review and deletion of the test list
SQL Server 2000 enhancement function
Summary of this chapter.
19. Understand the transaction and transaction lock
What is the transaction?
ACID attribute
Trading mode
Transaction recovery
Transaction lock
Block and dead knot
Lock prompt
Summary of this chapter.
20. Understand the advanced T-SQL
INSERT statement
. Update statement
DELETE statement
Program design key
Summary of this chapter.
21. Establish and manage pre-deputables
What is the pre-deposit program?
. Establish a pre-stored program
. Use the T-SQL management pre-store
Summary of this chapter.
22. Establish and use trigger procedures
What is a trigger program?
SQL Server 2000 trigger program enhancement function
When to use trigger programs
Establish a trigger program
Management trigger program
Summary of this chapter.
23. Access Microsoft SQL Server from the Internet
Internet design concept
. Access SQL Server using ISAPI
Access SQL Server using ASP
Access SQL Server using XML
Summary of this chapter.
24. Load the database
. Efficiency of load operation
A large number of copy tools
Bulk INSERT statement
Conversion service
STAGING Data Sheet
SELECT ... INTO statement
Summary of this chapter.
Part IV uses internal server function
25. Components and Microsoft Distributed Trading Coordinator
Component service overview
Microsoft Distributed Trading Coordinator
Summary of this chapter.
26. Microsoft SQL Server Replication: Overview and Snapshot
What is the database replication?
Culture concept
. Set issuance and distribution
Snapshot
Management
Snapshot copy school
Summary of this chapter.
27. Trading Document
Docked overview
. Documentary application
. Set trading replication system
Set, surveillance and school transfer
Trading replication
. Executive trading
Summary of this chapter.
28. Credit
Combined copy introduction
.
. Set a merged copy system
Management
Monitoring and commanding of consolidated replications
Summary of this chapter.
29. Use Microsoft SQL Server Analysis Services
Analysis SERVICES Overview
Install Analysis Services
. Using Analysis Services
Summary of this chapter.
PART V Management, Calling, Maintenance and Troubleshooting
30. Microsoft SQL Server Management
SQL Server automatic setting function
Database maintenance plan
Summary of this chapter.
31. Manage job automation
SQLServer agent service
Homework
Warning
. operator
SQLServer agent program error record file
Summary of this chapter.
32. Backup SQL Server
Backup terminology
. system error
SQL Server record file
Backup method
Execution backup
Screen backup
Improve backup
Summary of this chapter.
33. Restore and Reply Database
Reduction method
Database Restore
Damaged reply
Summary of this chapter.
34. Users and security management
Establishing a login account
Management information
Database role
Security account authorization
Summary of this chapter.
35. Using SQL Query Analyzer and SQL PROFILER
. Using SQL Query Analyzer
. Using SQL Profiler
Best T-SQL statement
Summary of this chapter.
36. Solve common performance issues
What is a bottleneck?
. problem found
General performance bottleneck
SQL Server configuration setting
Summary of this chapter.
PART VI Appendix
Microsoft SQL Server configuration settings. Configuration settings
Configuration option regulations
Change configuration settings with Enterprise Manager
Microsoft SQL Server Monitor
DBCC command
