Viescas, John, 1947-
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.
0321444434 (pbk. : alk. paper) 9780321444431 (pbk. : alk. paper)
2007026881
SQL (Computer program language)
Database searching.
QA76.73.S67 / H48 2008
005.75/85
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.
0321444434 (pbk. : alk. paper) 9780321444431 (pbk. : alk. paper)
2007026881
SQL (Computer program language)
Database searching.
QA76.73.S67 / H48 2008
005.75/85