MCDBA SQL Server 7 Database Design, Study Guide (Exam 70-29) [Paperback]

Inc. Syngress Media (Editor, Corporate Author)

Book Description

Publication Date: May 25, 1999 | ISBN-10: 0072120789 | ISBN-13: 978-0072120783

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.

Editorial Reviews

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.

Product Details

• Paperback: 557 pages
• Publisher: Mcgraw-Hill Osborne Media (May 25, 1999)
• Language: English
• ISBN-10: 0072120789
• ISBN-13: 978-0072120783
• Product Dimensions: 7.8 x 5.1 x 1 inches
• Shipping Weight: 1 pounds (View shipping rates and policies)
• Average Customer Review: 2.0 out of 5 stars  See all reviews (18 customer reviews)
• Amazon Best Sellers Rank: #8,497,229 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

10 of 10 people found the following review helpful:

2.0 out of 5 stars Poor - not recommended, November 28, 1999

By A Customer

This review is from: MCDBA SQL Server 7 Database Design, Study Guide (Exam 70-29) (Paperback)

The material has no correspondence with the Microsoft requirements. Some of the topics actually belong in the Administration exam. The rest of the material isn't exactly wrong, just highly inadequate. The questions are utterly childish, and will give anyone a real shock when they try to sit the real exam. The supervising editor Michael Lane feels compelled to trot out his certifications MCP, MCSD, MCSE etc... every 20 pages or so. Perhaps he should read a book or two about editing instead.

9 of 9 people found the following review helpful:

1.0 out of 5 stars Complete waste of a perfectly good tree, October 20, 1999

By 

"shadow2718" - See all my reviews

This review is from: MCDBA SQL Server 7 Database Design, Study Guide (Exam 70-29) (Paperback)

This book does practically nothing to help prepare for the SQL test. The examples are simplistic, the exam questions are nothing like you will see on the actual test, and the information hardly even qualifies this book as a reference. There's a lot to learn for this test. Don't get suckered into thinking that this will help.

7 of 7 people found the following review helpful:

1.0 out of 5 stars Misleading material, March 21, 2000

By A Customer

This review is from: MCDBA SQL Server 7 Database Design, Study Guide (Exam 70-29) (Paperback)

I purchased this book after taking the 029 test. I can honestly say that the "test questions" in this book bear very little resemblance to the questions on the actual test. The questions on the test are complex and difficult (often taking more 4 screens to present), while the sample questions in this book are just too simple.

The actual test is much more weighted toward practical how-to, and toward interpretation of complex t-sql scripts. The MS Press "SQL Server 7.0 Database Implementation Training Kit" is much closer to the mark, but still not adequate.

More to the point is MS Press "Inside SQL Server 7.0." In order to pass the test, spend a lot of time examining t-sql and thinking about how to use SQL profiler. The real test is about SQL practice, and not about the "2-minute drills" that this author seems to think are important.