SQL Bible

Format:

Book

Author/Creator:

Kriegel, Alex, Author.

Contributor:

Trukhnov, Boris M., Contributor.

Language:

English

Subjects (All):

SQL (Computer program language).

Physical Description:

1 online resource (xxx, 857 p. ) ill. ;

Edition:

2nd ed.

Place of Publication:

[Place of publication not identified] Wiley Imprint 2008

Language Note:

English

System Details:

text file

Summary:

Combining theory with everyday practicality, this definitive volume is packed with the up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

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.

Notes:

Bibliographic Level Mode of Issuance: Monograph

ISBN:

9780470355169

0470355166

OCLC:

402446308