MCSE Database Design on SQL Server 7

The book goes beyond simple knowledge of SQL Server 7 to include SQL Server 7
concepts and procedures as tested on the exam.

• 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

Table of contents

Introduction
Self-Assessment
Chapter 1: Microsoft Certification Exams
Chapter 2: Data Models
Chapter 3: System Databases, Tables, and Stored Procedures
Chapter 4: Databases and Files
Chapter 5: Data Definition
Chapter 6: Retrieving Data
Chapter 7: Modifying Table Data
Chapter 8: Session Configuration
Chapter 9: Indexes
Chapter 10: Rules, Defaults, and Views
Chapter 11: Transact-SQL Programming
Chapter 12: Triggers
Chapter 13: Transactions
Chapter 14: Importing, Exporting, and Transforming Data
Chapter 15: Full-Text Search
Chapter 16: Monitoring
Chapter 17: Remote Data Access
Chapter 18: Sample Test
Chapter 19: Answer Key
Appendix A: Pubs Database
Appendix B: Functions
Appendix C: Transact-SQL Syntax
Glossary
Index