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 Warns SameSite Cookie Changes Could Break Some Apps

    IT pros could face Web application issues as early as next month with the implementation of a coming SameSite Web change, which will affect how cookies are used across sites.

  • Populating a SharePoint Document Library by E-Mail, Part 1

    While Microsoft doesn't allow you to build a SharePoint Online document library using e-mail, there is a roundabout way of getting the job done using the tools that are included with Office 365. Brien shows you how.

  • Microsoft Previews New App Reporting and Consent Tools in Azure AD

    Microsoft last week described a few Azure Active Directory improvements for organizations wanting to connect their applications to Microsoft's identity and access service.

  • Free Software Foundation Asks Microsoft To Release Windows 7 Code

    The Free Software Foundation this week announced that it has established a petition demanding that Microsoft release its proprietary Windows 7 code as free software.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.