MCSE Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229
Learn how to deliver powerful database solutions using SQL Server 2000 Enterprise Edition-and prepare for the Microsoft Certified Professional (MCP) ... Show synopsis Learn how to deliver powerful database solutions using SQL Server 2000 Enterprise Edition-and prepare for the Microsoft Certified Professional (MCP) exam-with this official Microsoft study guide. Work at your own pace through the lessons and hands-on exercises. And use the special exam-prep section and testing tool to measure what you know and where to focus your studies-before taking the actual exam. As you build the real-world expertise for designing data-driven business solutions, you're also preparing for MCP Exam 70-229-a core exam for MCDBA certification and a key elective on the MCSE, MCAD, and MCSD tracks. Build the skills to: * Develop a logical data model * Create databases-files, objects, space management, and growth strategy * Use Transact-SQL and Data Transformation Services (DTS) to manipulate data; extract data in XML format * Program business logic using stored procedures, transactions, triggers, user-defined functions, and views * Optimize database performance by using SQL Profiler and the Index Tuning Wizard * Design a security plan-data access, object-level security, and application roles Ready for the exam? Take practice tests on the CD. Your kit includes: * Comprehensive self-paced study guide that maps to MCP exam goals and objectives * NEW-Test-readiness tool that generates timed, 50-question practice exams with automated scoring * NEW-More than 200 pages of exam prep and objective-by-objective review * Learn-by-doing exercises for skills you can apply to the job *120-day evaluation version of SQL Server 2000 Enterprise Edition * Fully searchable eBook For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.