3 4
Before you begin to work with the material in the Training Kit, it is recommended that you have
- Experience using the Windows 2000 operating system. The skills you should be comfortable with include:
- Connecting clients running Windows 2000 to servers running Windows 2000
- Configuring the Windows 2000 environment
- Creating and managing user accounts
- Managing access to resources by using groups
- Configuring and managing disks and partitions, including disk striping and mirroring
- Securing data by using NTFS
- Securing access to Windows 2000
- Optimizing Windows 2000 server performance
- An understanding of basic relational database concepts. These concepts include:
- Logical and physical relational database design
- Data integrity
- Relationships between tables and columns (primary and foreign keys, one-to-one, one-to-many, and many-to-many)
- How data is stored in tables (rows and columns)
- Knowledge of basic Transact-SQL syntax (SELECT, INSERT, and UPDATE statements)
- An understanding of the role of a database administrator