Overview
Pass the MCDBA SQL Server 7 exam and upgrade your career The database administrator who passes exam 70-29 achieves Microsoft Certified Professional status u 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 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 onperformance,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.