SQL Bible [Electronic resources]

Alex Kriegel

نسخه متنی -صفحه : 207/ 1
نمايش فراداده

Sitemap

Table of Contents

BackCover

SQL Bible

Preface

How This Book Is Organized

Conventions Used in This Book

Acknowledgments

Part I: SQL Basic Concepts and Principles

Chapter 1: SQL and Relational Database Management Systems (RDBMS)

Selecting Your Database Software

Everything in Details: DBMS Implementations

Real-Life Database Examples

Database Legacy

Relational Databases

Object Database and Object-Relational Database Models

Brief History of SQL and SQL Standards

Summary

Chapter 2: Fundamental SQL Concepts and Principles

SQL: The First Look

Any Platform, Any Time

Summary

Chapter 3: SQL Data Types

No Strings Attached

In Numbers Strength

Once Upon a Time: Date and Time Data Types

Object and User-Defined Data Types

Other Data Types

NULL

Summary

Part II: Creating and Modifying Database Objects

Chapter 4: Creating RDBMS Objects

Tables

Indexes

Views

Aliases and Synonyms

Schemas

Other SQL99 and Implementation-Specific Objects

CREATE Statement Cross-Reference

Summary

Chapter 5: Altering and Destroying RDBMS Objects

Tables

Indexes

Views

Aliases and Synonyms

Schemas

Other Implementation-Specific Objects

ALTER and DROP Statements Cross-Reference

Summary

Part III: Data Manipulation and Transaction Control

Chapter 6: Data Manipulation Language (DML)

INSERT: Populating Tables with Data

UPDATE: Modifying Table Data

DELETE: Removing Data from Table

Other SQL Statements to Manipulate Data

Summary

Chapter 7: Sessions, Transactions, and Locks

Sessions

Transactions

Understanding Locks

Summary

Part IV: Retrieving and Transforming Data

Chapter 8: Understanding SELECT Statement

Single Table SELECT Statement Syntax

SELECT Clause: What Do We Select?

FROM Clause: Select from What?

WHERE Clause: Setting Horizontal Limits

GROUP BY and HAVING Clauses: Summarizing Results

ORDER BY Clause: Sorting Query Output

Combining the Results of Multiple Queries

Summary

Chapter 9: Multitable Queries

Inner Joins

Outer Joins: Joining Tables on Columns Containing NULL Values

Joins Involving Inline Views

Multitable Joins with Correlated Queries

Improving Efficiency of Multitable Queries

Summary

Chapter 10: SQL Functions

Summary

Chapter 11: SQL Operators

Arithmetic Operators

Logical Operators

Operator Precedence

Assignment Operator

Comparison Operators

Bitwise Operators

User-defined Operators

Summary

Part V: Implementing Security Using System Catalogs

Chapter 12: SQL and RDBMS Security

Defining a Database User

Managing Security with Privileges

Managing Security with Roles

Using Views for Security

Using Constraints for Security

Using Stored Procedures and Triggers for Security

Database Auditing

Security Standards

Summary

Chapter 13: The System Catalog and INFORMATION_SCHEMA

Oracle 9i Data Dictionary

IBM DB2 UDB 8.1 System Catalogs

Microsoft SQL Server 2000 System Catalog

Summary

Part VI: Beyond SQL--Procedural Programming and Database Access Mechanisms

Chapter 14: Stored Procedures, Triggers, and User-Defined Functions

Procedural Extension Uses and Benefits

Key Elements of a SQL Procedural Language

Stored procedures

User-Defined Functions

Triggers

Summary

Chapter 15: Dynamic and Embedded SQL Overview

SQL Statement Processing Steps

Embedded (Static) SQL

Dynamic SQL Techniques

The Future of Embedded SQL

Summary

Chapter 16: SQL API

Microsoft Open Database Connectivity (ODBC)

Java Database Connectivity (JDBC)

IBM DB2 UDB Call-Level Interface (CLI)

Oracle Call Interface (OCI)

Oracle Objects for OLE (OO4O)

Microsoft Data Access Interfaces

Summary

Chapter 17: New Developments--XML, OLAP, and Objects

XML

OLAP and Business Intelligence

Objects

Summary

Part VII: Appendix

Appendix A: What's on the CD-ROM

Using the CD with Windows

What's on the CD

Troubleshooting

Appendix B: The ACME Sample Database

General Information and Business Rules

Naming Conventions

Relationships Between Tables

Column Constraints and Defaults

Indexes

SQL Scripts to Create ACME Database Objects

Appendix C: Basics of Relational Database Design

Identifying Entities and Attributes

Normalization

Specifying Constraints

Pitfalls of Relational Database Design

Appendix D: Installing RDBMS Software

Installing IBM DB2 UDB 8.1 Personal Edition

Installing Microsoft SQL Server 2000

Appendix E: Accessing RDBMS

Using IBM DB2 UDB 8.1 Command-Line Processor (CLP)

Using Microsoft SQL Server Utilities to Access Database

Appendix F: Installing the ACME Database

Installing the ACME Database on Oracle 9i (Unix/Linux) Using SQL*Plus

Installing the ACME Database on DB2 UDB 8.1 (Windows) Using CLP

Installing ACME Database on Microsoft SQL Server 2000 Using OSQL Utility

Appendix G: SQL Functions

Appendix H: SQL Syntax Reference

DDL Statements

DCL Statements

DML Statements

DQL Statements

Transactional Control Statements

Predicates

Appendix I: SQL-Reserved Keywords

Future Keywords

ODBC 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

The Number Systems

Logic Elements of Boolean Algebra

Set Theory

Index

Index_A

Index_B

Index_C

Index_D

Index_E

Index_F

Index_G

Index_H

Index_I

Index_J

Index_K

Index_L

Index_M

Index_N

Index_O

Index_P

Index_Q

Index_R

Index_S

Index_T

Index_U

Index_V

Index_W

Index_X

Index_Y

Index_Z

List of Figures

List of Tables

List of Code Examples

List of Sidebars