MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation - Hardcover

Moore, Thomas

Hardcover

ISBN 10: 0735711291 ISBN 13: 9780735711297

Publisher: Pearson IT Certification, 2002

Synopsis

Organized according to the actual exam objectives, our Training Guide series features pedagogy that provide readers with the most effective learning tools in the marketplace. The book is organized according to the exam objectives, including:

• Introducing SQL Server 2000
• Database design
• Grouping and normalizing data
• Data access and modification
• Programming
• Views
• Constraints, defaults and triggers
• Stored Procedures and UD functions
• Indexes
• Replication
• Monitoring

The book also features several effective learning tools, including Exam Tips, Study Strategies, Step-by-Step Exercises, Case Studies, Summaries & Review Breaks, Review Questions, Exam Questions, Hands-On Exercises, and Fast Facts.

About this title

About the Author

Thomas Moore, MCSE, MCSE, MCDBA, MCT, CTT, has been in the computer industry for more than 20 years. Thomas has a wide variety of expertise in all hardware environments and with most Microsoft Server products. "My first and lasting love, besides my wife and family, however, is programming." Thomas is comfortable in any programming language environment, achieving his MCSD and MCDBA certifications from their inception. Over the past 12 years he has been working for a variety of Microsoft partners and currently is a Systems Analyst for TechServices Web Development Group in Fort Wayne, Indiana, where he has been for the past three years. Thomas enjoys staying up-to-date, although like most of us, he finds it a challenge to keep up with the pace of the industry. Thomas's most recent certification achievements include being one of the first Windows 2000 MCSEs in the world and achieving the same standard as a SQL Server 2000 MCDBA.

From the Back Cover

Organized according to the actual exam objectives, our Training Guide series features pedagogy that provide readers with the most effective learning tools in the marketplace.

The book is organized according to the exam objectives, including:

* Introducing SQL Server 2000
* Database design
* Grouping and normalizing data
* Data access and modification
* Programming
* Views
* Constraints, defaults and triggers
* Stored Procedures and UD functions
* Indexes
* Replication
* Monitoring

The book also features several effective learning tools, including Exam Tips, Study Strategies, Step-by-Step Exercises, Case Studies, Summaries & Review Breaks, Review Questions, Exam Questions, Hands-On Exercises, and Fast Facts.

Edition details

• Publisher: Pearson IT Certification
• Publication date: 2002
• Language: English
• ISBN 10: 0735711291
• ISBN 13: 9780735711297
• Binding: Hardcover
• Edition number: 1
• Number of pages: 928