Getting started with SQL Server 2000
SQL Server introduction
SQL Server features
SQL Server installation
Special installation concerns
Database administration
Databases and capacity planning
SQL Server organization and data storage
Database management
Capacity planning and management
Database and object management
Managing databases
Database object fundamentals
Data management
Data conversions
Bulk copy program (bcp) and BULK INSERT
INSERT, UPDATE, DELETE, and SELECT INTO
Data Transformation Services (DTS)
Data migration planning
Backup, restore, and fault tolerance
Data security
Database backup
Database restore
Managing data security
Client configuration and management
Network communications
XML support
Security management
Server login and database user management
Security management
Security planning
Distributed data environment
Nonlinked servers
Linked servers
Replication management
Replication concepts
Publishing and distribution
Managing subscriptions
Replication planning and management
Ongoing management
SQL Mail
Automating management
SQL Server management
Monitoring and optimization
Monitoring overview
Windows monitoring tools
SQL Server monitoring tools
Database optimization
| |
