Course Content:

Unit 1 : Getting started with SQL Server 2000

• SQL Server introduction
• SQL Server features
• SQL Server installation
• Special installation concerns
• Database administration

Unit 2: Databases and capacity planning

• SQL Server organization and data storage
• Database management
• Capacity planning and management

Unit 3: Database and object management

• Managing databases
• Database object fundamentals

Unit 4: Data management

• Data conversions
• Bulk copy program (bcp) and BULK INSERT
• INSERT, UPDATE, DELETE, and SELECT INTO
• Data Transformation Services (DTS)
• Data migration planning

Unit 5: Backup, restore, and fault tolerance

• Data security
• Database backup
• Database restore
• Managing data security

Unit 6: Client configuration and management

• Network communications
• XML support

Unit 7: Security management

• Server login and database user management
• Security management
• Security planning

Unit 8: Distributed data environment

• Nonlinked servers
• Linked servers

Unit 9: Replication management

• Replication concepts
• Publishing and distribution
• Managing subscriptions
• Replication planning and management

Unit 10: Ongoing management

• SQL Mail
• Automating management
• SQL Server management

Unit 11:Monitoring and optimization

• Monitoring overview
• Windows monitoring tools
• SQL Server monitoring tools
• Database optimization

For more information on Acumen Classes
Please contact Deb Wagnon 314.333.3330
or This e-mail address is being protected from spambots. You need JavaScript enabled to view it