MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server™ 2000 Database Design and Implementation, Exam 70-229, Second Edition

MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server™ 2000 Database Design and Implementation, Exam 70-229, Second Edition
Published:May 07, 2003Language:English
Author:Microsoft CorporationTechnology:Microsoft SQL Server 2000
Length:880 PagesISBN 13:9780735619609

List Price:

$ 59.99
About The BookOfficial Microsoft study guide for the skills you need on the job—and on the exam.

Learn how to deliver powerful database solutions using SQL Server 2000 Enterprise Edition—and prepare for the Microsoft Certified Professional (MCP) exam—with this official Microsoft study guide. Work at your own pace through the lessons and hands-on exercises. And use the special exam-prep section and testing tool to measure what you know and where to focus your studies—before taking the actual exam. As you build the real-world expertise for designing data-driven business solutions, you’re also preparing for MCP Exam 70-229—a core exam for MCDBA certification and a key elective on the MCSE, MCAD, and MCSD tracks.Build the skills to:
  • Develop a logical data model
  • Create databases—files, objects, space management, and growth strategy
  • Use Transact-SQL and Data Transformation Services (DTS) to manipulate data; extract data in XML format
  • Program business logic using stored procedures, transactions, triggers, user-defined functions, and views
  • Optimize database performance by using SQL Profiler and the Index Tuning Wizard
  • Design a security plan—data access, object-level security, and application rolesReady for the exam? Take practice tests on the CD.Your kit includes:
  • Comprehensive self-paced study guide that maps to MCP exam goals and objectives
  • NEW—Test-readiness tool that generates timed, 50-question practice exams with automated scoring
  • NEW—More than 200 pages of exam prep and objective-by-objective review
  • Learn-by-doing exercises for skills you can apply to the job
  • 120-day evaluation version of SQL Server 2000 Enterprise Edition
  • Fully searchable eBook
  • About Microsoft CorporationFounded in 1975, Microsoft (NASDAQ 'MSFT') is the worldwide leader in software for personal and business computing. The company offers a wide range of products and services designed to empower people through great software—any time, any place, and on any device.
    Other Books By Microsoft Corporation
    Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:
    What do you think of this book? Your feedback is important in helping us create books that serve your needs and meet your expectations.Please take our survey at

    Note: You will need this book's 13-digit International Standard Book Number (ISBN) to take the survey.The ISBN 13 can be found above.
    To report or search for corrections in this book or its companion content,
    search for the title in our online store and then check the Errata & Updates tab. To report errors, please go to our Submit errata page.