70-229 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Description
The 070-229 module provides students with the technical skills required to program a database solution using Microsoft SQL Server 2000.
Entrance Requirements
It is recommended that the students in this course have already completed Implementing MS Windows 2000 Professional and Server or Managing a MS Windows Server 2003 Environment. If these modules have not been completed, the candidate should have equivalent knowledge and skills.
Who Should Attend
This course is intended for those who are responsible for implementing Microsoft SQL Server 2000 and writing Transact SQL code.
Course Outline
- Developing a logical data model
- Implementing the physical database
- Retrieving and Modifying data
- Programming business logic
- Tuning and optimizing data access
- Designing a database security plan
Examinations and Assessments
Learners write the CCS IT examination, the pass mark for which is 60%. Learners may elect to write the International Microsoft examinations at CCS’s Authorised Prometric Testing Centre. The costs for International exams are not included in the course fees.
Learning Materials
All standard learning materials are included in the course fee.