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

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

  • Microsoft, Oracle Announce Updates to Joint Database IaaS Service

    The Oracle Database@Azure infrastructure-as-a-service offering from Oracle and Microsoft is getting new capabilities, including integrations with key Microsoft data and security services.

  • 2025 Support Cliffs Approaching for Exchange 2016, Dynamics 365 PSA

    Microsoft recently sounded the warning bell for two of its products, Exchange Server 2016 and Dynamics 365 Project Service Automation (PSA), both of which are set to reach end-of-support milestones next year.

  • Windows Recall To Finally See Daylight in October Preview

    After postponing the public debut of its controversial Windows Recall AI feature, Microsoft is has finally settled on releasing it as a broad preview in October.

Most   Popular