Taylor's Library

Normal view MARC view ISBD view

SQL bible / Alex Kriegel and Boris M. Trukhnov

By: Kriegel, Alex.
Contributor(s): Trukhnov, Boris M.
Publisher: Indianapolis, Ind. : Wiley Pub., c2003Description: xxvii, 831 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.).ISBN: 0764525840 (pbk.).Subject(s): SQL (Computer program language)DDC classification: 005.7565
Contents:
Preface. - Acknowledgments. - Pt. I. SQL basic concepts and principles. Ch. 1 : SQL and relational database management systems (RDBMS). Ch. 2 : Fundamental SQL concept and principles. Ch. 3 : SQL data types. - Pt. II. Creating and modifying database objects. Ch. 4. Creating RDBMS objects. Ch. 5 : Altering and destroying RDBMS objects. - Pt. III. Data manipulation and transaction control. Ch. 6. Data manipulation language (DML). Ch. 7 : Sessions, transactions, and locks. - Pt. IV : Retrieving and transforming data. Ch. 8 : Understanding SELECT statement. Ch. 9 : Multitable queries. Ch. 10 : SQL functions. Ch. 11 : SQL operators. - Pt. V : Implementing security using system catalogs. Ch. 12 : SQL and RDBMS security. Ch. 13 : The system catalog and INFORMATION _SCHEMA. - Pt. VI : Beyond SQL : procedural programming and database access mechanisms. Ch. 14 : stored procedures, triggers, and user-defined functions. Ch. 15. Dynamic and embedded SQL overview. Ch. 16. SQL API. Ch. 17 : New developments : XML, OLAP, and objects. - Appendix A : What's on the CD-ROM. - Appendix B : The ACME sample database. - Appendix C : Basics of relatonal database design. - Appendix D : Installing RDBMS software. - Appendix E : Accessing RDBMS. - Appendix F : Installing the ACME database. - Appendix G : SQL functions. - Appendix H : Syntax reference. - Appendix I : SQL reserved keywords. - Appendix J : SQL99 major features compliance accross different RDBMS. - Appendix K : The other RDBMS. - Appendix L : A brief introduction to the number systems, boolean algebra, and set theory. - Index. - End-user licence agreement.
Item type Current location Call number Copy number Status Notes Date due Barcode
Accompanying Material (Media Resource) Taylor's Library-TU
005.7565 KRI (Browse shelf) 1 Available SOCIT,15010,03,GR 1000117752

"Covers SQL99 standard"--Cover.

Includes index.

Preface. - Acknowledgments. - Pt. I. SQL basic concepts and principles. Ch. 1 : SQL and relational database management systems (RDBMS). Ch. 2 : Fundamental SQL concept and principles. Ch. 3 : SQL data types. - Pt. II. Creating and modifying database objects. Ch. 4. Creating RDBMS objects. Ch. 5 : Altering and destroying RDBMS objects. - Pt. III. Data manipulation and transaction control. Ch. 6. Data manipulation language (DML). Ch. 7 : Sessions, transactions, and locks. - Pt. IV : Retrieving and transforming data. Ch. 8 : Understanding SELECT statement. Ch. 9 : Multitable queries. Ch. 10 : SQL functions. Ch. 11 : SQL operators. - Pt. V : Implementing security using system catalogs. Ch. 12 : SQL and RDBMS security. Ch. 13 : The system catalog and INFORMATION _SCHEMA. - Pt. VI : Beyond SQL : procedural programming and database access mechanisms. Ch. 14 : stored procedures, triggers, and user-defined functions. Ch. 15. Dynamic and embedded SQL overview. Ch. 16. SQL API. Ch. 17 : New developments : XML, OLAP, and objects. - Appendix A : What's on the CD-ROM. - Appendix B : The ACME sample database. - Appendix C : Basics of relatonal database design. - Appendix D : Installing RDBMS software. - Appendix E : Accessing RDBMS. - Appendix F : Installing the ACME database. - Appendix G : SQL functions. - Appendix H : Syntax reference. - Appendix I : SQL reserved keywords. - Appendix J : SQL99 major features compliance accross different RDBMS. - Appendix K : The other RDBMS. - Appendix L : A brief introduction to the number systems, boolean algebra, and set theory. - Index. - End-user licence agreement.