000			02183nam a2200409 a 4500
001			BDZ0004929165
003			StDuBDS
005			20180923143606.0
008			010920s2002 njua f 001 0 eng d
020			_a9780130669476 (pbk.) : _c£35.99
020			_a0130669474
040			_aStDuBDS _cStDuBDS _dStDuBDSZ
050		0	_aQA76.73.S67 _bP38 2002
072		7	_aCOM _2ukslc
072		7	_aUMT _2thema
082	0		_a005.7565 PAT
100	1		_aPatrick, John J.
245	1	0	_aSQL fundamentals / _cJohn J. Patrick.
250			_a2nd ed.
260			_aUpper Saddle River, N.J. : _bPrentice Hall PTR, _cc2002.
300			_axxvi, 834 p. : _bill. ; _c24 cm.
500			_aPrevious ed.: 1999.
500			_aIncludes index.
500			_aCD-ROM in back pocket.
505	0		_a1.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.
520	8		_aSQL 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.
650		0	_aSQL (Comptuer program language).
650		0	_aSQL (Computer program language)
650		0	_aRelational databases.
650		0	_aDatabase management.
650		7	_aComputers and IT. _2ukslc
650		7	_aDatabase programming _2thema
902			_a170814
907			_a.b1031572x _bmain _c-
942			_n0
998			_b0 _c050316 _dm _ea _f- _g0
999			_c8024 _d8024