SQL Bible
byAlex KriegelandBoris 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