Table of Contents

Chapter 1. Select: Single Table; Chapter 2. Where; Chapter 3. Order By; Chapter 4. Select: Multiple Tables; Chapter 5. Aggregates; Chapter 6. Select: New Tables; Chapter 7. Except/Intersect/Union; Chapter 8. Group By; Chapter 9. System Functions; Chapter 10. Subqueries; Chapter 11. Delete/Insert/Update; Chapter 12. Views/User-Defined Functions; Chapter 13. Stored Procedures/Programming; Chapter 14. Data Definition Language (DDL) and Data Control Language (DCL); Chapter 15. After You Finish; Index

About the Author

Art Tennick has worked in relational database design and SQL queries for more than 20 years. He has been involved in multi-dimensional database design, cubes, data mining, DMX, and MDX for 10 years. Art is the author of Practical MDX Queries for Microsoft SQL Server Analysis Services 2008, Practical DMX Queries for Microsoft SQL Server Analysis Services 2008, and Practical PowerPivot & DAX Formulas for Excel 2010. His website is www.MrCube.net.