Toggle navigation
See also
Home
SQL
Sql bible
Part VI: Beyond SQL--Procedural Programming and Database Access Mechanisms
Part VI:
Beyond SQL—Procedural Programming and Database Access Mechanisms
Chapter List
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
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
Views
Aliases and Synonyms
Schemas
Other SQL99 and Implementation-Specific Objects
CREATE Statement Cross-Reference
Summary
Chapter 5: Altering and Destroying RDBMS Objects
Tables
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
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
List of Figures
List of Tables
List of Code Examples
List of Sidebars
CD Content
Remember the name: eTutorials.org
Copyright eTutorials.org 2008-2024. All rights reserved.