Taylor's Library Banner
Image from Google Jackets

SQL bible / Alex Kriegel and Boris M. Trukhnov

By: Contributor(s): Publication details: Indianapolis, Ind. : Wiley Pub., c2003Description: xxvii, 831 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.)ISBN:
  • 0764525840 (pbk.)
Subject(s): DDC classification:
  • 005.7565 KRI
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.
Holdings
Cover image Item type Current library Home library Collection Shelving location Shelf location Call number Materials specified Vol info Copy number Status Notes Date due Barcode Item holds Item hold queue priority Course reserves
Accompanying Material (Media Resource) Taylor's Library-TU 005.7565 KRI (Browse shelf(Opens below)) 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.