TY - BOOK AU - Viescas,John AU - Hernandez,Michael J. AU - Hernandez,Michael J. TI - SQL queries for mere mortals: a hands-on guide to data manipulation in SQL T2 - For mere mortals series SN - 0321444434 (pbk. : alk. paper) AV - QA76.73.S67 H48 2008 U1 - 005.75/85 22 PY - 2008/// CY - Upper Saddle River, NJ PB - Addison-Wesley KW - SQL (Computer program language) KW - Database searching N1 - On t.p. of previous ed. Michael J. Hernandez's name appeared first; Includes bibliographical references (p. 615) and index; pt. 1. Relational databases and SQL. What is relational? -- Ensuring your database structure is sound -- A concise history of SQL -- pt. 2. SQL basics. Creating a simple query -- Getting more than simple columns -- Filtering your data -- pt. 3. Working with multiple tables. Thinking in sets -- INNER JOINs -- OUTER JOINs -- UNIONs -- Subqueries -- pt. 4. Summarizing and grouping data. Simple totals -- Grouping data -- Filtering grouped data -- pt. 5. Modifying sets of data. Updating sets of data -- Inserting sets of data -- Deleting sets of data UR - http://catdir.loc.gov/catdir/toc/ecip0721/2007026881.html ER -