SQL Queries for Mere Mortals, 4th Edition
John L. Viescas
ISBN No. 978-0134858333
Anyone who has to use a database system that supports SQL can use this book. As a beginning database user who has just discovered that the data you need is fetched using SQL, this book will teach you all the basics and more. For an expert user who is suddenly faced with solving complex problems or integrating multiple systems that support SQL, this book provides insights into leveraging the complex abilities of the SQL database language.
This fourth edition has been thoroughly revised, with two new “advanced” chapters on grouping (using ROLLUP, CUBE, and GROUPING SETS) and partitioning your data into Windows. The sample databases are provided as SQL scripts, SQL Server 2016 databases, Microsoft Access 2016 databases, and MySQL and PostgreSQL scripts. You can download the sample files from: http://www.informit.com/title/9780134858333.