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 Adds Privileged Identity Management Delegation to Azure Lighthouse

    The commercial release of Privileged Identity Management (PIM)-enabled Azure Lighthouse delegations is now available, Microsoft on Monday announced.

  • Microsoft Commercially Releases Entra Workload Identities

    Microsoft announced on Monday that its Entra Workload Identities service is now available as a commercial product offering, having reached the "general availability" stage.

  • The 2022 Microsoft Product Roadmap

    Microsoft has a lot in the docket for 2022, including new products like SQL Server 2022, Exchange Subscription Edition and Visual Studio 2022 for Mac.

  • OpenSSF Adopts Microsoft Open Source Software Security Guidelines

    The Open Source Security Foundation (OpenSSF) announced on Wednesday that it has adopted the Secure Supply Chain Consumption Framework (S2C2F) for ensuring the secure use of open source software (OSS) by developers.