SQL Queries for Mere Mortals
Subtitle: a hands-on guide to data manipulation in SQL
Publisher: Addison-Wesley Professional; Addison-Wesley
Published: 2014
Place of publication: Upper Saddle River, NJ
Language: eng
Format: Paperback
Number of pages: 760
ISBN-13: 9780321992475
Table of contents: title: About the authors; title: Introduction; title: Part one : Relational databases and SQL.; title: What is relational?; title: Ensuring your database structure is sound; title: A concise history of SQL; title: Part two : SQL basics.; title: Creating a simple query; title: Getting more than simple columns; title: Filtering your data; title: Part three : Working with multiple tables.; title: Thinking in sets; title: Inner joins; title: Outer joins; title: Unions; title: Subqueries; title: Part four : Summarizing and grouping data.; title: Simple totals; title: Grouping data; title: Filtering grouped data; title: Part five : Modifying sets of data.; title: Updating sets of data; title: Inserting sets of data; title: Deleting sets of data; title: Part six : Introduction to solving tough problems.; title: "NOT" and "AND" problems; title: Condition testing; title: Using unlinked data and "driver" tables; title: In closing; title: Appendices.; title: SQL standard diagrams; title: Schema for the sample databases; title: Date and time types, operations, and functions; title: Suggested reading