This accelerated course provides technical training for system administrators, implementers, system engineers, and developers who are responsible for administering and implementing Microsoft SQL Server. This course provides students with the knowledge and skills required to configure, administer, implement, and troubleshoot SQL Server version 6.5. This course is not intended for individuals who have no prior SQL Server knowledge.
The materials you receive in this course are the complete materials for the following Microsoft Official Curriculum courses:
- Course 867, System Administration for Microsoft SQL Server 6.5
- Course 750, Implementing a Database Design on Microsoft SQL Server 6.5
To ensure the completion of these materials in one week, the instructor-led portion of this course covers only selected modules or topics from the two courses. Most modules or topics not covered in the classroom are assigned as self-study within the week of instruction.
At the end of the course, students will be able to:
- Configure Microsoft SQL Server 6.5.
- Manage the storage requirements of a database.
- Create database devices, databases, user-defined data types, and tables.
- Manage user accounts, login security, and database permissions.
- Write Transact-SQL statements to query data, manipulate data, and program the server.
- Identify issues to consider when creating indexes.
- Enforce data integrity by creating and implementing constraints, defaults, and rules.
- Create views, triggers, and stored procedures.
- Describe the characteristics of transaction management.
- Describe how to use cursors to perform row operations.
- Maintain the system and perform day-to-day operations including backing up and restoring a database, determining how to distribute data, recovering from a system disaster, scheduling tasks, setting alerts, monitoring, and tuning.
- Manage the import, export, and replication of data.