I didn't delve into data warehousing, MOLAP, or Dimensional Modeling (DM) in my book. Date warehousing leads us to use denormalization techniques to optimize the database schema for certain types of reporting. Instead I covered standard relational design, with normalization being the default, which is better for OLTP or OLCP type applications.
Overall, my book tries to address the most common mistakes that I see database developers make. These naturally tend to be more to do with fundamentals of database usage, instead of the most advanced usage.
I do assume the reader has moderate knowledge of SQL or at least she has access to a reference for basic SQL queries, data definition, data types, and other terminology. My book is not an introduction to SQL concepts or syntax.