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

by Microsoft Corporation (Author)

• Used

  Hardcover
  2003

  $3.22

  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 roles

  Ready 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

  For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.