SQL Server 7.0 Data Warehousing Training Kit

Microsoft-official training for the skills you need on the job—and on the exam.
Learn how to design and implement data warehouse solutions using SQL Server™ 7.0—and prepare for the Microsoft® Certified Professional (MCP) exam—with this single training kit. Work at your own pace through a system of modular lessons and hands-on labs for practical experience building and managing solutions that facilitate data analysis and decision support across the enterprise. As you gain this work-ready expertise, you'll also be preparing for MCP Exam 70-019—an elective credit toward the Microsoft Certified Database Administrator and Microsoft Certified Systems Engineer credentials. Make this official Microsoft Training Kit your next step to career advancement!
HERE'S WHAT YOU'LL LEARN.
• Analyzing business requirements—performance, scalability, maintainability, availability, and security
• Defining the technical architecture for a data warehouse solution
• Developing the logical design—selecting a data warehouse model; specifying requirements and relationships
• Deriving the physical design
• Creating data services using OLE DB, ODBC, and ActiveX Data Objects (ADO); writing SQL statements
• Creating a physical database—file management, data integrity, referential integrity, indexes, and OLAP
• Maintaining a database; monitoring and optimizing performance; backup and disaster recovery procedures
HERE'S WHAT'S INSIDE.
• A comprehensive training manual that maps to MCP exam goals and objectives
• Hands-on, skill-building exercises with practice files on CD-ROM
• A complete online version of the book
• 120-day evaluation copy of Microsoft SQL Server 7.0