TY  - BOOK
AU  - Patrick,John J.
TI  - SQL fundamentals
SN  - 9780130669476 (pbk.) :
AV  - QA76.73.S67 P38 2002
U1  - 005.7565 PAT 
PY  - 2002///
CY  - Upper Saddle River, N.J.
PB  - Prentice Hall PTR
KW  - SQL (Comptuer program language)
KW  - SQL (Computer program language)
KW  - Relational databases
KW  - Database management
KW  - Computers and IT
KW  - ukslc
KW  - Database programming
KW  - thema
N1  - 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
N2  - 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
ER  -