SQL queries for mere mortals : a hands-on guide to data manipulation in SQL /
John L. Viescas, Michael J. Hernandez.
- 2nd ed.
- Upper Saddle River, NJ : Addison-Wesley, c2008.
- xxxiii, 631 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.)
- For mere mortals series .
- For mere mortals series. .
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.
System requirements for accompanying disc: 32 MB RAM; 20 MB free hard disk space; Windows 95/98/2000/NT; Internet Explorer 5; sound card; CD-ROM drive.