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

Book Description
Learn how to design and implement database solutions using SQL Server 2000 Enterprise Edition--as you prepare for MCP Exam 70-229, a core requirement for MCDBA certification and an elective for the MCAD, MCSE, and MCSA tracks.


Buy from Amazon     Compare Prices

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.


Buy from Barnes & Noble     Compare Prices