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

Official Microsoft study guide for the database development skills tested on the job—and on MCP Exam 70-229 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.