As far as I know, the book promises to deliver the core concepts of using SQL queries. It also covers an in depth explanation on joins.
The book is mainly intended to strengthen our basic SQL skills. One example to this would be the ALTER table queries that I encountered in chapter 5. I remember using ALTER queries before but most of the time I look to some reference to get the query right. Now after reading that Dataville for Alterations from the book, I'm sure that I'll never forget what ALTERATIONS I can do with my table.
SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!
Jothi is correct. There's so much you really need to know about just the core concept, SQL, that there isn't room to cover other topics. We take the most important concepts and really go deep with them. That way, when you look at more advanced topics, or topics that are related to SQL, you understand the SQL portion of it, leaving you free to focus on the new information.
It's not easy trying to learn two or three technologies at the same time. I prefer learning one at a time. I feel that leads me to understanding the combination of technologies that much better.