Objectives
This course is appropriate for anyone who will be installing and managing SQL Server 2000.
This includes implementation in small LANs, large enterprises, or any environment
in between. It will also be helpful for anyone involved with database
administration, anyone managing SQL Server implementation, and anyone considering SQL
Server 2000 as part of a business solution. This course can be used for test
preparation for Microsoft Exam 70-228, Installing, Configuring and Administering Microsoft
SQL Server 2000 Enterprise Edition.
Requirements
Windows 2000 Server Administration Principles or equivalent experience
Contents
Unit 1: Getting started with SQL Server 2000
Topic A: SQL Server introduction
Topic B: SQL Server features
Topic C: SQL Server installation
Topic D: Special installation concerns
Topic E: Database administration
Unit summary: Getting started with SQL Server 2000
Unit 2: Databases and capacity planning
Topic A: SQL Server organisation and data storage
Topic B: Database management
Topic C: Capacity planning and management
Unit 3: Database and object management
Topic A: Managing databases
Topic B: Database object fundamentals
Unit 4: Data management
Topic A: Data conversions
Topic B: Bulk copy program (bcp) and BULK INSERT
Topic C: INSERT, UPDATE, DELETE and SELECT INTO
Topic D: Data Transformation Services (DTS)
Topic E: Data migration planning
Unit 5: Backup, restore, and fault tolerance
Topic A: Data security
Topic B: Database backup
Topic C: Database restore
Topic D: Managing data security
Unit 6: Client configuration and management
Topic A: Network communications
Topic B: XML support
Unit 7: Security management
Topic A: Server login and database user management
Topic B: Security management
Topic C: Security planning
Unit 8: Distributed data environment
Topic A: Nonlinked servers
Topic B: Linked servers
Unit 9: Replication management
Topic A: Replication concepts
Topic B: Publishing and distribution
Topic C: Managing subscriptions
Topic D: Replication planning and management
Unit 10: Ongoing management
Topic A: SQL Mail
Topic B: Automating management
Topic C: SQL Server management
Unit 11: Monitoring and optimisation
Topic A: Replication concepts
Topic B: Publishing and distribution
Topic C: Managing subscriptions
Topic D: Replication planning and management
Unit 12: Case study
Topic A: Sample setup.iss
Topic B: Project goals
Unit 13: Additional object references
Topic A: System tables
Topic B: System functions
Topic C: Data types and precision storage
Topic D: DBCC command statements
Course Fees |
.gif)