Learn how to deliver powerful database solutions—and prepare for MCP Exam 70-229—with this official Microsoft study guide. Exam 70-229 is an elective for MCSE/MCSA certification and a core exam on the MCDBA track. Build your expertise designing and implementing data-driven business applications using SQL Server 2000 by working at your own pace through the book’s lessons and hands-on exercises. The second edition of this popular TRAINING KIT now features a testing tool to measure what you know and where to focus your studies—before taking the actual exam. Topics include developing a logical data model; creating databases; using Transact-SQL and Data Transformation Services (DTS) to manipulate data; extracting data in XML format; programming business logic using stored procedures, transactions, triggers, user-defined functions, and views; optimizing database performance by using SQL Profiler and the Index Tuning Wizard; and implementing security. You also get a CD-ROM loaded with practice exercises and an easy-search electronic version of the study guide.

Key Book Benefits:

Official Microsoft study guide helps you build the skills and expertise for designing database solutions with SQL Server 2000.

Provides in-depth preparation for MCP Exam 70-229, “Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition,” a core credit for MCDBA certification and an elective for the MCAD, MCSA, and MCSE tracks.

This TRAINING KIT delivers self-paced training that maps to MCP exam goals and objectives, a testing tool that generates timed practice exams with automated scoring, and an electronic version of the study guide.

CD-romskiva ingår