Useful Books for the SQL 7.0 Data Warehouses Exam

Get a thorough understanding of OLAP with this excellent resource.

Microsoft OLAP Solutions is the only book I know that concentrates specifically on Microsoft OLAP Server (formerly code-named "Plato"). The authors do an excellent job of covering the architecture of this product, and show how to design databases to be used as data warehouses. The discussion of the MDX query language covers everything you might need for the Data Warehouses exam and much more. They also offer excellent coverage of optimization and security, as well as two fully worked-out hands-on tutorials. The book's CD includes all of the data for the tutorials and examples plus several utilities for working with data stored in Microsoft OLAP Server. I'd recommend this one for any front-end developer who needs to understand this form of data storage.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.

Featured

  • Salesforce To Acquire Informatica in $8 Billion Deal

    Salesforce announced on Tuesday it plans to acquire data management firm Informatica for $8 billion.

  • An image of planes flying around a globe

    2025 Microsoft Conference Calendar: For Partners, IT Pros and Developers

    Here's your guide to all the IT training sessions, partner meet-ups and annual Microsoft conferences you won't want to miss.

  • Microsoft Gives Orgs More Power to 'Tune' AI Agents

    At its Build 2025 conference this week, Microsoft unveiled significant advancements aimed at empowering enterprises to create more sophisticated AI agents.

  • Build 2025: Microsoft Charts Wider Path for AI Agents

    At Build 2025, Microsoft unveiled its strategic vision for the future of AI agents, emphasizing the development of autonomous systems capable of performing complex tasks across various applications.

Most   Popular