Softcover

ISBN 10: 0072120789 ISBN 13: 9780072120783

Publisher: Mcgraw-Hill Osborne Media, 1999

A study of SQL Server 7. It is designed to help candidates prepare for the Microsoft Certified Database Administrator (MCDBA) exam 70-29. It directly maps to the certification objectives with more than 250 questions. There are "Exam Watch Warnings", which point out the troublesome parts of the exam, and certification summaries, which offer succinct review of important information. The accompanying CD-ROM includes "Test Yourself" practice exam software with detailed core score analysis, timed live exams and expert answers, as well as IE 4.0.

From the Back Cover:

Don't Let the Real Test Be Your First Test! Prepare to pass the MCDBA/MCSE SQL Server 7 Database Design exam - while gaining practical knowledge of Microsoft's relational database technology for on-the-job success. Built on the proven training methodology of Global Knowledge, this complete study guide and CD-ROM package offers actual classroom techniques used by more than 200,000 IT professionals each year. The MCDBA SQL Server 7 Database Design Study Guide covers the topics you need to review for the exam, including how to: Group data into entities by applying normalization rules. Choose the foreign key that will enforce a relationship between entities and will ensure referential integrity. Assess the potential impact of the logical design on performance, maintaining, extensibility, scalability, availability, and security. Create and manage explicit, implicit, and distributed transactions to ensure data consistency and recoverability. Write INSERT, DELETE, UPDATE, and SELECT statements that retrieve and modify data. Create scripts using Transact-SQL. Programming elements include control-of-flow methods, local and global variables, functions, and error-handling methods. Create result sets that provide summary data. Query types include TOP n PERCENT and GROUP BY, specifically HAVING,CUBE, and ROLLUP. Create and manage files, file groups, and transaction logs that define a database. Populate the database with data from an external data source.

About the Author:

Syngress Media, Inc. (Rockland, MA) is an independent company committed to creating the very best book, software and Internet based exam preparation tools. They have published over 20 certification study guides and over a dozen Personal Testing Centers. All of these products are created by leading content experts, many of whom are also full-time trainers.