Toggle navigation
See also
Home
SQL
Sql bible
List of Figures
List of Figures
Chapter 1: SQL and Relational Database Management Systems (RDBMS)
Figure 1-1: Hierarchical structure
Figure 1-2: Hierarchical database example
Figure 1-3: Network database example
Figure 1-4: Multiple columns to resolve multiple addresses for CUSTOMER
Figure 1-5: Multiple records to resolve multiple addresses for CUSTOMER
Figure 1-6: Primary/Foreign Key relationship between tables
Figure 1-7: Resolving the multiple customer addresses problem within relational model
Chapter 3: SQL Data Types
Figure 3-1: Fixed-length character string storage
Figure 3-2: Varying-length character string storage
Figure 3-3: Fixed-length Unicode character storage
Figure 3-4: Varying-length Unicode character storage
Figure 3-5: Table with column declared as an object type
Figure 3-6: Nested tables in Oracle
Chapter 4: Creating RDBMS Objects
Figure 4-1: Mary's rows in the
TMP_CUSTOMER_ORDER_TOTALS
temporary table
Figure 4-2: Susan's rows in the
TMP_CUSTOMER_ORDER_TOTALS
temporary table
Figure 4-3: Kyle's rows in the
TMP_CUSTOMER_ORDER_TOTALS
temporary table
Figure 4-4: Index use
Figure 4-5: B-Tree example
Figure 4-6: Database organization in Oracle
Figure 4-7: Database organization in MS SQL Server
Figure 4-8: Relationship between tablespace and datafile (one-to-many).
Figure 4-9: Using sequence-generated numbers to populate primary keys in multiple tables
Chapter 6: Data Manipulation Language (DML)
Figure 6-1: Using data from other table as an assignment value
Figure 6-2: Updating multiple rows using correlated subquery
Figure 6-3: Deleting from table referenced by ON DELETE CASCADE constraints
Figure 6-4: Deleting from table referenced by ON DELETE SET NULL constraints
Chapter 9: Multitable Queries
Figure 9-1: Simple inner join
Figure 9-2: Primary/foreign key nonequijoin
Figure 9-3: The contents of DISCOUNT table
Figure 9-4: Self-join
Figure 9-5: Four tables join
Chapter 16: SQL API
Figure 16-1: Microsoft ODBC Driver Manager console
Figure 16-2: ODBC drivers selection
Figure 16-3: IBM DB2 UDB ODBC driver configuration
Figure 16-4: New user DSN entry IBM DB2 UDB
Figure 16-5: illustrates generic RDBMS access using JDBS drivers.
Figure 16-6: Accessing IBM DB2 UDB through CLI
Figure 16-7: Connecting to Microsoft SQL Server 2000 through OLEDB
Figure 16-8: Results of the database C# program
Appendix B: The ACME Sample Database
Figure B-1: ACME database schema
Appendix D: Installing RDBMS Software
Figure D-1: Oracle 9
i
Autorun window
Figure D-2: Oracle Welcome window
Figure D-3: Oracle File Locations window
Figure D-4: Oracle Database Identification window
Figure D-5: Oracle Database Character Set window
Figure D-6: Oracle Summary window
Figure D-7: Oracle Install window / Disk Location pop-up screen
Figure D-8: Oracle Configuration Tools and Database Configuration assistant windows
Figure D-9: Oracle Change passwords for system users on the Database Configuration assistant window
Figure D-10: Oracle Windows Services window
Figure D-11: Removing Oracle software with the Inventory window
Figure D-12: Oracle Administration Assistant for Windows NT
Figure D-13: DB2 UDB 8.1 Installation window
Figure D-14: DB2 UDB 8.1 Products selection screen
Figure D-15: DB2 UDB 8.1 Setup wizard screen
Figure D-16: DB2 UDB 8.1 Select installation folder screen
Figure D-17: DB2 UDB 8.1 Start copying files screen
Figure D-18: DB2 UDB 8.1 Creating database using Control Center window
Figure D-19: DB2 UDB 8.1 Creating ACME database in using Database Wizard
Figure D-20: This MS SQL 2000 installation window allows you to choose the destination computer name.
Figure D-21: MS SQL 2000 Installation Selection window
Figure D-22: MS SQL 2000 Installation Definition screen
Figure D-23: MS SQL 2000 Setup Type screen
Figure D-24: MS SQL 2000 Services Accounts screen
Figure D-25: MS SQL 2000 Authentication Mode screen
Figure D-26: MS SQL 2000 Server Service Manager
Appendix E: Accessing RDBMS
Figure E-1: SQL*Plus command-line interface started from MS-DOS
Figure E-2: Executing SQL commands from SQL*Plus
Figure E-3: SQL*Plus Worksheet window
Figure E-4: OSQL session window
Figure E-5: MS SQL Server Query Analyzer dialog box
Figure E-6: Executing SQL commands using Query Analyzer
Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory
Figure L-1: Set union
Figure L-2: Set intersection
Figure L-3: Set difference
Figure L-4: Cartesian product
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.