TY - BOOK AU - Groff,James R. AU - Weinberg,Paul N. AU - Groff,James R. AU - Oppel,Andrew J. AU - Groff,James R. TI - SQL: the complete reference SN - 9780071592550 (pbk.) : AV - QA76.73.S67 U1 - 005.756 WEI PY - 2009/// CY - Emeryville, Calif., London PB - McGraw-Hill/Osborne, McGraw-Hill [distributor] KW - SQL (Computer program language) KW - Handbooks, manuals, etc KW - Relational databases KW - Computers and IT KW - ukslc KW - Database software KW - thema N1 - Previous ed.: New York; London: McGraw-Hill/Osborne, 2002; Includes index; On t.p. of previous ed., James R. Groff\'s name appeared first; Part I.An overview of SQL -- 2.A quick tour of SQL -- 3.SQL in perspective -- 4.Relational databases -- Part II.Retrieving data -- 5.SQL basics -- 6.Simple queries -- 7.Multitable queires (joins) -- 8.Summary queires -- 9.Subqueries and query expressions -- Part III.Updating data -- 10.Database updates -- 11.Data integrity -- 12.Transaction processing -- Part IV.Database structure -- 13.Creating a database -- 14.Views -- 15.SQL security -- 16.The system catalog -- Part V.Programming with SQL -- 17.Embedded SQL -- 18.Dynamic SQL -- 19.SQL APIs -- Part VI.SQL today and tomorrow -- 20.Database processing and stored procedural SQL -- 21.SQL and data warehousing -- 22.SQL and application servers -- 23.SQL networking and distributed databases -- 24.SQL and objects -- 25.SQL and XML -- 26.Specialty databases --27.The future of SQL N2 - This reference guide to SQL delivers the conceptual framework and insight into relational database technology and its trends. The book covers the core SQL language and also describes the differences between popular SQL products ER -