The MICROSOFT(R) SQL SERVER(R) 7 DATA WAREHOUSING TRAINING KIT prepares students for MCP Exam 70-019-Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0 and Microsoft(R) Decision Support Services 1.0. The Kit covers the installation, configuration, and support of the Microsoft SQL Server client/server database management system, version 7.0. THE MICROSOFT SQL SERVER 7 DATA WAREHOUSING TRAINING KIT is designed to train professionals (SQL Server administrators, Corporate IS/MIS staff, Database administrators, and system engineers) in the skills they need to do their job and assist them in passing the exam.
Provides the official Microsoft SQL Server training for Microsoft Certified Professional Exam 70-019, hands-on, skill building exercises with practice files on CD-ROM, and 120-day evaluation edition of Microsoft SQL Server 7.0.
Welcome to Microsoft SQL Server 7.0 Data Warehousing Training kit. The book provides you with the technical skills required to implement a data warehouse with Microsoft SQL Server client/server database management system version 7.0 and Microsoft SQL Server OLAP Services. The content of this book provides a theoretical and practical discussion of data warehouse design and the important features that SQL Server provides for implementing a data warehouse.
Each chapter in this book is divided into lessons. Most lessons include hands-on exercises that allow you to practice or demonstrate a particular concept or skill. Each lesson ends with a short summary and each chapter has a set of review questions to test your knowledge of the chapter material.
This book was developed for information system (IS) professionals who need to design, plan, implement, and support data warehouses using Microsoft SQL Server 7.0 and Microsoft SQL Server OLAP Services or who plan to take the related Microsoft Certified Professional exam 70-019: Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0.
Experience using the Microsoft Windows NT Server network operating system:
- Working knowledge of the Windows NT 4.0 interface
- Understand basic Microsoft network functions and terminology
- One year of experience with relational databases:
Have supported or designed a relational database
Understand the fundamental concepts of relational database design
- Three to six months of SQL Server experience:
Installed at least one SQL Server
Designed relational databases
Worked with SQL Server client tools
- Understand basic ANSI SQL statements and basic Transact-SQL statements
- Understand basic Visual Basic programming.
You should also have passed the Microsoft Certified Professional Exam 70-028 (Administering Microsoft SQL Server 7.0) and the Microsoft Certified Professional Exam 70-029 (Designing and Implementing Databases with Microsoft SQL Server 7.0) or have mastered the Microsoft SQL Server 7.0 System Administration Training Kit and the Microsoft SQL Server 7.0 Database Implementation Training Kit.