This official ""MCSE Training Kit"" teaches database administrators how to set up and support Microsoft SQL Server 2000 -- as they prepare for MCP Exam 70-228, a core exam for MCDBA certification and an elective on the Microsoft Windows ""RM"" 2000 MCSE track. Topics map directly to the objectives measured by the MCP exam, including installing and configuring SQL Server 2000, creating databases, optimizing database performance, extracting and transforming data, managing security, and monitoring and troubleshooting SQL Server system activity. Students learn through an integrated system of skill-building tutorials, case study examples, and self-assessment exercises. An economical alternative to classroom instruction, this kit enables students to set their own pace and learn by doing!

MCSE Training Kit (Exam 70-228): Microsoft SQL Server 2000 System Administration (MCSE Training Kits)

Computers & Technology

Microsoft Press

Rabeler, Carl

Certification

Teach yourself how to use SQL Server 2000 Data Transformation Services (DTS)—and begin writing your own data movement applications—one step at a time. This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through the easy-to-follow lessons and hands-on exercises to master essential techniques. And accelerate your productivity by working with instructive code examples and best practices for SQL Server 2000 DTS. Discover how to: <ul>
<li>Create simple data movement packages with the DTS Import/Export Wizard</li> <li>Create a complex data movement application with the DTS Designer that configures pre-built DTS tasks </li> <li>Exploit the flexibility of the Data Driven Query (DDQ) task without sacrificing performance</li> <li>Incorporate execution logic, flow control, branching, transaction control, and parallel execution into DTS packages and tasks</li> <li>Dynamically configure DTS packages and tasks at run time</li> <li>Save DTS packages in SQL Server, Meta Data Services, Structured Storage, and Microsoft Visual Basic file formats</li> <li>Extract and transform heterogeneous data using ActiveX Scripts</li> <li>Integrate customized logging, error handling, and batch control into your application</li> <li>Deploy and operate a data movement application</li> </ul>
About DTS in SQL Server 2000: Microsoft SQL Server 2000 Data Transformation Services (DTS) provides a set of graphical tools and programmable objects to extract, transform, and consolidate data from disparate sources into single or multiple destinations. By using DTS tools, you can create custom data movement solutions to support decision-making, improve system performance, upgrade existing systems, and more. CD features: <ul>
<li>Practice files for all the book’s procedures</li> </ul>
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Microsoft® SQL Server™ 2000 DTS Step by Step

Programming

See the best price to sell, buy, or rent books by Rabeler, Carl. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Rabeler, Carl

See the best price to sell, buy, or rent books by Rabeler, Carl. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

MCSE Training Kit (Exam 70-228): Microsoft SQL Server 2000 System Administration (MCSE Training Kits)

Microsoft® SQL Server™ 2000 DTS Step by Step