SQL Bible [Electronic resources] نسخه متنی

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