MCSE Training Kit: Microsoft® SQL Server™ 2000 Database Design and Implementation

عن الكتاب

Official Microsoft® study guide for the skills you need on the job—and on the exam. Learn how to deliver powerful database solutions—and prepare for the Microsoft® Certified Professional (MCP) exam—with this official Microsoft study guide. Work through the modular system of lessons and hands-on exercises to gain practical experience designing and ... implementing data-driven business applications using SQL Server™ 2000 Enterprise Edition. As you build these real-world design skills, you’re also preparing for MCP Exam 70-229—a core exam for MCDBA certification and a key elective on the MCSE and MCSD tracks. HERE’S WHAT YOU’LL LEARN. • Developing a logical data model • Creating databases—files, objects, space management, and growth strategy • 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