Your cart is empty.
  • Home

    SQL queries for mere mortals : a hands-on guide to data manipulation in SQL / John L. Viescas, Michael J. Hernandez.

    By: Viescas, John, 1947-Contributor(s): Hernandez, Michael J. (Michael James), 1955- | Hernandez, Michael J. (Michael James), 1955-. SQL queries for mere mortalsMaterial type: TextTextSeries: 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
    Contents:
    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.
    Tags from this library: No tags from this library for this title. Log in to add tags.
        Average rating: 0.0 (0 votes)
    Item type Current library Call number Copy number Status Notes Date due Barcode
    Books Books Female Library
    		QA76.73 .S67 H48 2008 (Browse shelf (Opens below)) 1 Available STACKS 51952000097761
    Books 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.

    to post a comment.