SQL. Библия пользователя

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. Alex Kriegel, Boris M. Trukhnov. Includes Index. "Combining theory with everyday practicality, this definitive volume is packed with 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."--Jacket A guide to SQL describes how the new SQL standard applies to Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008 along with information on such topics as database objects, data manipulation and transaction control, and retrieving and transferring data. Information may be the most valuable commodity in the modern world.