MCDBA SQL Server 7 Database Design, Study Guide (Exam 70-29) - Softcover

Syngress Media, Inc.

Softcover

ISBN 10: 0072120789 ISBN 13: 9780072120783

Publisher: McGraw-Hill Osborne Media, 1999

Synopsis

Pass the MCDBA SQL Server 7 exam and upgrade your career The database administrator who passes exam 70-29 achieves Microsoft Certified Professional status ù and opens the door to a flourishing career. Syngress Media's MCDBA SQL Server 7 Database Design Study Guide (Exam 70-29) delivers deep insight into SQL 7 along with complete coverage of official certification objectives. Providing critical information that's easy-to-digest with an eye on exam preparation, it's a complete study package that you can entrust your career to. Here's what you get: *Over 250 practice exam questions *CD-ROM with exclusive test yourself exam software, detailed score analysis, timed live exams, and expert answers. *Special exam watch warnings based on post-exam research *Hands-on drills emphasizing skills likely to be on the exam *Certification summaries that offer to-the-point review of important information

About this title

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.

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.

Edition details

• Publisher: McGraw-Hill Osborne Media
• Publication date: 1999
• ISBN 10: 0072120789
• ISBN 13: 9780072120783
• Binding: Paperback
• Language: English
• Number of pages: 557
• Editor: Syngress Media Inc.