SQL queries for mere mortals : a hands-on guide to data manipulation in SQL / John L. Viescas, Michael J. Hernandez.
Material type:
TextSeries: For mere mortals series: Publisher: Upper Saddle River, NJ : Addison-Wesley, c2008Edition: 2nd edDescription: xxxiii, 631 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.)ISBN: 0321444434 (pbk. : alk. paper); 9780321444431 (pbk. : alk. paper)Subject(s): SQL (Computer program language) | Database searchingDDC classification: 005.75/85 LOC classification: QA76.73.S67 | H48 2008Online resources: Table of contents only | Item type | Current library | Call number | Copy number | Status | Notes | Date due | Barcode |
|---|---|---|---|---|---|---|---|
Books
|
Female Library | QA76.73 .S67 H48 2008 (Browse shelf (Opens below)) | 1 | Available | STACKS | 51952000097761 | |
|
Books
|
Main Library | QA76.73 .S67 H48 2008 (Browse shelf (Opens below)) | 1 | Available | STACKS | 51952000124351 |
Includes bibliographical references (p. 615) and index.
On t.p. of previous ed. Michael J. Hernandez's name appeared first.
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.
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.
1 2
There are no comments on this title.