Taylor's Library

Normal view MARC view ISBD view

SQL bible / Alex Kriegel, Boris M. Trukhnov.

By: Kriegel, Alex.
Contributor(s): Trukhnov, Boris M.
Publisher: Indianapolis, IN : Wiley Pub, c2008Edition: 2nd ed.Description: xxx, 857 p. : ill. ; 24 cm.ISBN: 9780470229064 (pbk.); 0470229063 (pbk.).Subject(s): SQL (Computer program language)DDC classification: 005.7565
Contents:
Pt. I. SQL basic concepts and principles -- SQL and relational database management systems -- Fundamental SQL concepts and principles -- SQL data types -- Pt. II. Creating and modifying database objects -- Creating RDBMS objects -- Altering and destroying RDBMS objects -- Pt. III. Data manipulation and transaction control -- Data manipulation language (DML) -- Sessions, transactions, and locks -- Pt. IV. Retrieving and transferring data -- Understanding the select statement -- Multitable queries -- SQL functions -- SQL operators -- Pt. V. Implementing security using the system catalog -- SQL and RDBMS security -- The system catalog and information schema -- Pt. VI. Beyond SQL: procedural programming and database access mechanisms / Stored procedures, triggers, and user-defined functions -- SQL and XML -- SQL and procedural programming -- The future of SQL.
Item type Current location Call number Copy number Status Notes Date due Barcode Remark
Main Collection TU External Storage-LCS
005.7565 KRI (Browse shelf) 1 Available SOCIT,15010,03,GR 5000048013 Please fill up online form at https://taylorslibrary.taylors.edu.my/services/external_storage1

Includes Internet access.

Previous ed.: 2003.

Includes index.

Pt. I. SQL basic concepts and principles -- SQL and relational database management systems -- Fundamental SQL concepts and principles -- SQL data types -- Pt. II. Creating and modifying database objects -- Creating RDBMS objects -- Altering and destroying RDBMS objects -- Pt. III. Data manipulation and transaction control -- Data manipulation language (DML) -- Sessions, transactions, and locks -- Pt. IV. Retrieving and transferring data -- Understanding the select statement -- Multitable queries -- SQL functions -- SQL operators -- Pt. V. Implementing security using the system catalog -- SQL and RDBMS security -- The system catalog and information schema -- Pt. VI. Beyond SQL: procedural programming and database access mechanisms / Stored procedures, triggers, and user-defined functions -- SQL and XML -- SQL and procedural programming -- The future of SQL.