quantum

Author: Microsoft Corporation
Isbn 13: 9780735619609
ISBN: 0735619603
Pub Date: Jun 4, 2003
Publisher: Microsoft Press
Shipping Weight: 3.80 pounds
Status: In stock ships within 1 day

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.
view more info, including table of contents
(opens in pop-up window)