Learn how to deliver powerful database solutions-and prepare for MCP Exam 70-229-with this official Microsoft study guide. 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.