| MP9004: Microsoft - SQL Server 2000 Database Design MCSE 70-229  | SQL Server 2000 Database Design MCSE 70-229 | This series of courses serves as preparation for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition," which is one of several electives for the MCSE certification track, and a core requirement for MCDBA certification. Topics covered include developing a logical data model, implementing the database and objects, retrieving and modifying data using Transact-SQL and XML, using indexes and views, programming business logic (stored procedures, functions, views, triggers), tuning and optimizing data access, and designing a database security plan. This series is tightly focused on exam preparation and review, not on providing general knowledge. Some background knowledge and hands-on experience with enterprise systems and relational databases is assumed. | Audience:
This series is for anyone preparing for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."
Features:
- Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
- Activities allow learners to apply course concepts in an interactive questioning environment.
- Exercises allow learners to practice in the actual application being studied.
- A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
- Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
- Search text enables learners to rapidly search all text within a course to easily retrieve information required.
- Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
- A skill assessment generates a customized learning path based on the results of a pre-test.
- A glossary provides a reference for definitions of unfamiliar terms.
- Bookmarking tracks the learner's progress in a course.
Includes:
|
|
|
