TY - BOOK AU - Weinberg,Paul N. AU - Groff,James R. AU - Oppel,Andrew J. AU - Groff,James R. TI - SQL, the complete reference SN - 9780071592550 AV - QA76.73.S67 G873 2010 PY - 2010/// CY - New York PB - McGraw-Hill KW - SQL (Computer program language) KW - Relational databases N1 - Includes index; On t.p. of previous ed., James R. Groff's name appeared first; 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 ER -