Table of Contents

SQL Bible
by Alex Kriegel and Boris M. Trukhnov	ISBN:0764525840
John Wiley & Sons 2003 (831 pages)
This definitive volume contains all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard.
CD Content

Table of Contents
	SQL Bible
	Preface
	Part I - SQL Basic Concepts and Principles
	Chapter 1	-	SQL and Relational Database Management Systems (RDBMS)
	Chapter 2	-	Fundamental SQL Concepts and Principles
	Chapter 3	-	SQL Data Types
	Part II - Creating and Modifying Database Objects
	Chapter 4	-	Creating RDBMS Objects
	Chapter 5	-	Altering and Destroying RDBMS Objects
	Part III - Data Manipulation and Transaction Control
	Chapter 6	-	Data Manipulation Language (DML)
	Chapter 7	-	Sessions, Transactions, and Locks
	Part IV - Retrieving and Transforming Data
	Chapter 8	-	Understanding SELECT Statement
	Chapter 9	-	Multitable Queries
	Chapter 10	-	SQL Functions
	Chapter 11	-	SQL Operators
	Part V - Implementing Security Using System Catalogs
	Chapter 12	-	SQL and RDBMS Security
	Chapter 13	-	The System Catalog and INFORMATION_SCHEMA
	Part VI - Beyond SQL—Procedural Programming and Database Access Mechanisms
	Chapter 14	-	Stored Procedures, Triggers, and User-Defined Functions
	Chapter 15	-	Dynamic and Embedded SQL Overview
	Chapter 16	-	SQL API
	Chapter 17	-	New Developments—XML, OLAP, and Objects
	Part VII - Appendix
	Appendix A	-	What's on the CD-ROM
	Appendix B	-	The ACME Sample Database
	Appendix C	-	Basics of Relational Database Design
	Appendix D	-	Installing RDBMS Software
	Appendix E	-	Accessing RDBMS
	Appendix F	-	Installing the ACME Database
	Appendix G	-	SQL Functions
	Appendix H	-	SQL Syntax Reference
	Appendix I	-	SQL-Reserved Keywords
	Appendix J	-	SQL99 Major Features Compliance Across Different RDBMS
	Appendix K	-	The Other RDBMS
	Appendix L	-	A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory
	Index
	List of Figures
	List of Tables
	List of Code Examples
	List of Sidebars
	CD Content