SQL Queries for Mere Mortals Third edition

SQL Queries for Mere Mortals is the easiest, most practical guide to writing modern SQL queries. Now extensively updated to cover new database platforms and include more advanced techniques, it guides the reader step-by-step through creating and modifying queries for virtually any SQL-based database. Michael J. Hernandez and John L. Viescas demystify all facets of query writing with SQL Features SQL queries explained in plain English, with plenty of examples using the latest database products and SQL standards Covers everything needed to create efficient queries, work with multiple tables, summarize and group data, modify datasets, and more Includes three new chapters of advanced techniques, covering complex Not/And problems, unlinked tables, and problem-solving with CASE and driver tables Content Chapter 1 What Is Relational Chapter 2 Ensuring Your Database Structure Is Sound Chapter 3 A Concise History of SQL Chapter 4 Creating a Simple Query Chapter 5 Getting More Than Simple Columns Chapter 6 Filtering Your Data Chapter 7 Thinking in Sets Chapter 8 INNER JOINs Chapter 9 OUTER JOINs Chapter 10 UNIONs Chapter 11 Subqueries Chapter 12 Simple Totals Chapter 13 Grouping Data Chapter 14 Filtering Grouped Data Chapter 15 Updating Sets of Data Chapter 16 Inserting Sets of Data Chapter 17 Deleting Sets of Data Chapter 18 “NOT” and “AND” Problems Chapter 19 Condition Testing