01342pamaa2200229 4500 0000047114 20120404090000.0 9780071592550 (pbk) 005.75 GRO QA76.73.S67 GRO 2010 Groff SQL : the complete reference James R. Groff, Paul N. Weinberg, Andrew Oppel. 3rd ed. New York: Osborne McGraw-Hill, 2010. xxviii, 882p.: ill.; 24cm. Includes index Introduction -- A quick tour of SQL -- SQL in perspective -- Relational databases -- SQL basics -- Simple queries -- Multitable queries (Joins) -- Summary queries -- Subqueries and query expressions -- Database updates -- Data integrity -- Transaction processing -- Creating a database -- Views -- SQL security -- The system catalog -- Embedded SQL-- Dynamic SQL* -- SQL APIs -- Database processing and stored procedural SQL -- SQL and data warehousing -- SQL and application servers -- SQL Networking and distributed databases -- SQL and objects -- SQL and XML -- Specialty databases -- The future of SQL -- The sample database -- DBMS vendor profiles -- SQL syntax reference SQL (Computer program language) Database management WEINBERG, Paul N. Oppel, Andrew J. www.mhhe.com