SQL Queries for Mortals has gained worldwide recognition as the clearest and simplest tutorial for writing effective queries using the latest SQL standards and database applications. Now, author John L. Viescas has updated this practical classic with even more advanced and valuable techniques. Step by step, Viescas guides readers through creating reliable queries for nearly any current SQL-based database. He demystifies all aspects of writing SQL queries, from simple data selection and filtering to joining multiple tables and modifying records. Building on the fundamentals, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions to a table, performing sophisticated logical evaluations, and leveraging unjoined tables to think outside the box. In two brand new chapters, students learn how to perform complex calculations on groups for advanced reporting and how to partition data into windows to enable more flexible aggregations. Students can practice everything they need with downloadable sample databases for the current versions of Microsoft Office Access, Microsoft SQL Server, and the open-source databases MySQL and PostgreSQL.

Resources for instructors include a teaching guide, PowerPoint presentations, and a question bank.