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

  • Microsoft Starts Countdown to Dynamics GP End-of-Support

    Dynamics GP, Microsoft's venerable enterprise resource planning (ERP) solution for midsized businesses, is set to lose support in four years.

  • Image of a futuristic maze

    The 2024 Microsoft Product Roadmap

    Everything Microsoft partners and IT pros need to know about major Microsoft product milestones this year.

  • Windows Recall Preview Starts Rolling Out with Windows 11 24H2

    Microsoft on Tuesday began rolling out Windows 11 version 24H2, describing the update as a "full OS swap that contains new foundational elements required to deliver transformational Al experiences and exceptional performance."

  • An image of planes flying around a globe

    2024 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.