SQL fundamentals / John J. Patrick.
Material type: TextPublication details: Upper Saddle River, N.J. : Prentice Hall PTR, c2002.Edition: 2nd edDescription: xxvi, 834 p. : ill. ; 24 cmISBN:- 9780130669476 (pbk.) :
- 0130669474
- 005.7565 PAT
- QA76.73.S67 P38 2002
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.