gogo
Amazon cover image
Image from Amazon.com

SQL fundamentals / John J. Patrick.

By: Material type: TextTextPublication details: Upper Saddle River, N.J. : Prentice Hall PTR, c2002.Edition: 2nd edDescription: xxvi, 834 p. : ill. ; 24 cmISBN:
  • 9780130669476 (pbk.) :
  • 0130669474
Subject(s): DDC classification:
  • 005.7565 PAT
LOC classification:
  • QA76.73.S67 P38 2002
Contents:
1.Storing information in tables -- 2.Getting information from a table -- 3.Compound conditions in the where clause -- 4.Saving your results -- 5.Modifying data through a view -- 6.Creating your own tables -- 7.Formats, sequences, and indexes -- 8.Data integrity -- 9.Row functions -- 10.Using row functions -- 11.Summarizing data -- 12.Controlling the level of summarization -- 13.Inner joins -- 14.Outer joins -- 15.Union and union all -- 16.Cross joins and self joins -- 17.Combining talbes in a production database -- 18.If-then-else and subqueries -- 19.The multiuser environment -- 20.The design of SQL -- Appendix A.Obtaining and installing ORACLE -- Appendix B.Tips on using ORACLE -- Appendix C.Tips on using ACCESS -- Appendix D.Diagram of the lunches database.
Summary: SQL is a standardised query language for requesting information from a database. Covering topics such as inner joins, self joins and subqueries using clear, easy to follow examples, this book compares and contrasts Oracle 9I and Access 2000 databases.
Holdings
Item type Current library Call number Copy number Status Date due Barcode
Long Loan TUS: Midlands, Main Library Athlone General Lending 005.7565 PAT (Browse shelf(Opens below)) 1 Available 123920

Previous ed.: 1999.

Includes index.

CD-ROM in back pocket.

1.Storing information in tables -- 2.Getting information from a table -- 3.Compound conditions in the where clause -- 4.Saving your results -- 5.Modifying data through a view -- 6.Creating your own tables -- 7.Formats, sequences, and indexes -- 8.Data integrity -- 9.Row functions -- 10.Using row functions -- 11.Summarizing data -- 12.Controlling the level of summarization -- 13.Inner joins -- 14.Outer joins -- 15.Union and union all -- 16.Cross joins and self joins -- 17.Combining talbes in a production database -- 18.If-then-else and subqueries -- 19.The multiuser environment -- 20.The design of SQL -- Appendix A.Obtaining and installing ORACLE -- Appendix B.Tips on using ORACLE -- Appendix C.Tips on using ACCESS -- Appendix D.Diagram of the lunches database.

SQL is a standardised query language for requesting information from a database. Covering topics such as inner joins, self joins and subqueries using clear, easy to follow examples, this book compares and contrasts Oracle 9I and Access 2000 databases.

Powered by Koha