SQL Queries for Mere Mortals, 3/E (Paperback)

SQL Queries for Mere Mortals, 3/E (Paperback)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 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

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--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 drivertables ContentChapter 1 What Is RelationalChapter 2 Ensuring Your Database Structure Is SoundChapter 3 A Concise History of SQLChapter 4 Creating a Simple QueryChapter 5 Getting More Than Simple ColumnsChapter 6 Filtering Your DataChapter 7 Thinking in SetsChapter 8 INNER JOINsChapter 9 OUTER JOINsChapter 10 UNIONsChapter 11 SubqueriesChapter 12 Simple TotalsChapter 13 Grouping DataChapter 14 Filtering Grouped DataChapter 15 Updating Sets of DataChapter 16 Inserting Sets of DataChapter 17 Deleting Sets of DataChapter 18 "NOT" and "AND" ProblemsChapter 19 Condition Testing