Covers how to design databases for information systems that incorporate Microsoft SQL Server 7.0. The book goes beyond simple knowledge of SQL Server 7 to include SQL Server 7 concepts and procedures as tested on the exam. A complete review: developing a logical data model, deriving the physical design, creating a physical database, data service design, and database maintenance. Includes resource sections at the end of each chapter to help the reader make use of the best study aids available. Serves as a complement to study guides for Exam 70-029: Implementing a Database Design on SQL Server 7.0. Exam 70-029 doubles as a MCSE elective and an MCDBA core requirement. Includes sections on proven test-taking strategies, warnings on trick questions, time-saving study tips, multiple-part question strategies, and shortcuts. Provides practice exams that feature questions arranged in a similar format to the ones found on the actual exam. Provides all of the necessary overviews, concepts, and Microsoft networking terminology to help potential test takers get up to speed as quickly as possible. Guarantees long shelf life because tests are not made available until roughly 90-120 days after the release of the software.

by Jeffrey Garbus, David Pascuzzi, Alvin Chang

Jeffrey R. Garbus

United States, United States of America

Scottsdale (Arizona), cop. 1999

Exam cram, Albany, ©1999

PS, 1999

A test preparation guide for the Microsoft's Designing and Implementing a Database with SQL Server 7.0 certification exam 70-029. Individual chapters cover data definition, retrieving data, modifying table data, session configuration, triggers, transactions, the data transaction service, and monitoring. Annotation c. Book News, Inc., Portland, OR (booknews.com)

2023-06-28