MTU Library Catalogue

Syndetics cover image
Image from Syndetics

SQL : the complete reference / James R. Groff and Paul N. Weinberg.

By: Groff, James R.
Contributor(s): Weinberg, Paul N.
Material type: materialTypeLabelBookPublisher: Berkeley, Calif. : Osborne/McGraw-Hill, 2002Edition: 2nd ed.Description: xxiv, 1050 p. : ill. ; 24 cm.ISBN: 0072225599.Other title: Complete reference SQL [Cover title].Subject(s): SQL (Computer program language) | Relational databasesDDC classification: 005.7565
Holdings
Item type Current library Call number Copy number Status Barcode
General lending MTU Bishopstown Library Lending 005.7565 (Browse shelf(Opens below)) 1 Available 00099050
Total holds: 0

Enhanced descriptions from Syndetics:

SQLis the standard tool/language for organizing, managing, and retrieving data stored by a database, and this one-step resource aims to cover all aspects about SQL. It contains a CD-ROM with four databases including SQL Server 2000, IBM DB2 Version 7.2, and mySQL. The resource shows how to set up and manage SQL-based databases and write programmes to access them. It also teaches how to use and programme SQL databases with application servers and the Web to create applications. This updated second edition includes coverage of XML and Web services, and of the popular open source database, mySQL and a look ahead at Yukon.

Includes index.

Table of contents provided by Syndetics

  • Acknowledgments (p. xxiii)
  • Preface (p. xxv)
  • Part I An Overview of SQL
  • 1 Introduction (p. 3)
  • The SQL Language (p. 4)
  • The Role of SQL (p. 6)
  • SQL Features and Benefits (p. 8)
  • Vendor Independence (p. 8)
  • Portability Across Computer Systems (p. 9)
  • SQL Standards (p. 9)
  • IBM Endorsement (DB2) (p. 9)
  • Microsoft Commitment (ODBC and ADO) (p. 9)
  • Relational Foundation (p. 10)
  • High-Level, English-Like Structure (p. 10)
  • Interactive, Ad Hoc Queries (p. 10)
  • Programmatic Database Access (p. 10)
  • Multiple Views of Data (p. 10)
  • Complete Database Language (p. 11)
  • Dynamic Data Definition (p. 11)
  • Client/Server Architecture (p. 11)
  • Extensibility and Object Technology (p. 11)
  • Internet Database Access (p. 11)
  • Java Integration (JDBC) (p. 12)
  • 2 A Quick Tour of SQL (p. 13)
  • A Simple Database (p. 14)
  • Retrieving Data (p. 14)
  • Summarizing Data (p. 17)
  • Adding Data to the Database (p. 18)
  • Deleting Data (p. 19)
  • Updating the Database (p. 19)
  • Protecting Data (p. 20)
  • Creating a Database (p. 21)
  • Summary (p. 22)
  • 3 SQL In Perspective (p. 23)
  • SQL and Database Management (p. 24)
  • A Brief History of SQL (p. 25)
  • The Early Years (p. 26)
  • Early Relational Products (p. 26)
  • IBM Products (p. 27)
  • Commercial Acceptance (p. 27)
  • SQL Standards (p. 29)
  • The ANSI/ISO Standards (p. 29)
  • Other SQL Standards (p. 31)
  • ODBC and the SQL Access Group (p. 31)
  • The Portability Myth (p. 32)
  • SQL and Networking (p. 34)
  • Centralized Architecture (p. 34)
  • File Server Architecture (p. 35)
  • Client/Server Architecture (p. 36)
  • Multi-Tier Architecture (p. 37)
  • The Proliferation of SQL (p. 38)
  • SQL and IBM's Unified Database Strategy (p. 39)
  • SQL on Minicomputers (p. 39)
  • SQL on Unix-Based Systems (p. 40)
  • SQL on Personal Computers (p. 40)
  • SQL and Transaction Processing (p. 41)
  • SQL and Workgroup Databases (p. 42)
  • SQL and Data Warehousing (p. 43)
  • Summary (p. 45)
  • 4 Relational Databases (p. 47)
  • Early Data Models (p. 48)
  • File Management Systems (p. 48)
  • Hierarchical Databases (p. 49)
  • Network Databases (p. 51)
  • The Relational Data Model (p. 53)
  • The Sample Database (p. 54)
  • Tables (p. 56)
  • Primary Keys (p. 57)
  • Relationships (p. 59)
  • Foreign Keys (p. 59)
  • Codd's Twelve Rules* (p. 61)
  • Summary (p. 64)
  • Part II Retrieving Data
  • 5 SQL Basics (p. 67)
  • Statements (p. 68)
  • Names (p. 72)
  • Table Names (p. 74)
  • Column Names (p. 74)
  • Data Types (p. 75)
  • Constants (p. 80)
  • Numeric Constants (p. 81)
  • String Constants (p. 81)
  • Date and Time Constants (p. 82)
  • Symbolic Constants (p. 83)
  • Expressions (p. 84)
  • Built-in Functions (p. 85)
  • Missing Data (NULL Values) (p. 86)
  • Summary (p. 88)
  • 6 Simple Queries (p. 91)
  • The SELECT Statement (p. 92)
  • The SELECT Clause (p. 94)
  • The FROM Clause (p. 94)
  • Query Results (p. 94)
  • Simple Queries (p. 98)
  • Calculated Columns (p. 100)
  • Selecting All Columns (SELECT *) (p. 103)
  • Duplicate Rows (DISTINCT) (p. 104)
  • Row Selection (WHERE Clause) (p. 105)
  • Search Conditions (p. 107)
  • Comparison Test (=, [], [, [=, ], ]=) (p. 108)
  • Range Test (BETWEEN) (p. 111)
  • Set Membership Test (IN) (p. 114)
  • Pattern Matching Test (LIKE) (p. 116)
  • Null Value Test (IS NULL) (p. 119)
  • Compound Search Conditions (AND,OR, and NOT) (p. 121)
  • Sorting Query Results (ORDER BY Clause) (p. 124)
  • Rules for Single-Table Query Processing (p. 127)
  • Combining Query Results (UNION)* (p. 128)
  • Unions and Duplicate Rows* (p. 130)
  • Unions and Sorting* (p. 132)
  • Multiple UNIONS* (p. 132)
  • Summary (p. 135)
  • 7 Multi-Table Queries (Joins) (p. 137)
  • A Two-Table Query Example (p. 138)
  • Simple Joins (Equi-Joins) (p. 140)
  • Parent/Child Queries (p. 142)
  • Joins with Row Selection Criteria (p. 145)
  • Multiple Matching Columns (p. 145)
  • Queries with Three or More Tables (p. 146)
  • Other Equi-Joins (p. 149)
  • Non-Equi Joins (p. 152)
  • SQL Considerations for Multi-Table Queries (p. 153)
  • Qualified Column Names (p. 153)
  • All-Column Selections (p. 155)
  • Self-Joins (p. 155)
  • Table Aliases (p. 159)
  • Multi-Table Query Performance (p. 160)
  • The Structure of a Join (p. 161)
  • Table Multiplication (p. 161)
  • Rules for Multi-Table Query Processing (p. 162)
  • Outer Joins* (p. 164)
  • Left and Right Outer Joins* (p. 168)
  • Outer Join Notation* (p. 172)
  • Joins and the SQL2 Standard (p. 174)
  • Inner Joins in SQL2* (p. 174)
  • Outer Joins in SQL2* (p. 177)
  • Cross Joins and Union Joins in SQL2* (p. 179)
  • Multi-Table Joins in SQL2 (p. 181)
  • Summary (p. 184)
  • 8 Summary Queries (p. 187)
  • Column Functions (p. 188)
  • Computing a Column Total (SUM) (p. 191)
  • Computing a Column Average (AVG) (p. 191)
  • Finding Extreme Values (MIN and MAX) (p. 192)
  • Counting Data Values (COUNT) (p. 194)
  • Column Functions in the Select List (p. 195)
  • NULL Values and Column Functions (p. 197)
  • Duplicate Row Elimination (DISTINCT) (p. 199)
  • Grouped Queries (GROUP BY Clause) (p. 201)
  • Multiple Grouping Columns (p. 204)
  • Restrictions on Grouped Queries (p. 208)
  • NULL Values in Grouping Columns (p. 210)
  • Group Search Conditions (HAVING Clause) (p. 211)
  • Restrictions on Group Search Conditions (p. 215)
  • NULL Values and Group Search Conditions (p. 215)
  • HAVING Without GROUP BY (p. 216)
  • Summary (p. 216)
  • 9 Subqueries and Query Expressions (p. 217)
  • Using Subqueries (p. 218)
  • What Is a Subquery? (p. 219)
  • Subqueries in the WHERE Clause (p. 221)
  • Outer References (p. 222)
  • Subquery Search Conditions (p. 223)
  • Subquery Comparison Test (=, [], [, [=, ], ]=) (p. 224)
  • Set Membership Test (IN) (p. 226)
  • Existence Test (EXISTS) (p. 228)
  • Quantified Tests (ANY and ALL)* (p. 231)
  • Subqueries and Joins (p. 237)
  • Nested Subqueries (p. 239)
  • Correlated Subqueries* (p. 240)
  • Subqueries in the HAVING Clause* (p. 243)
  • Subquery Summary (p. 245)
  • Advanced Queries in SQL2* (p. 246)
  • Scalar-Valued Expressions (SQL2) (p. 248)
  • Row Value Expressions (SQL2) (p. 254)
  • Table Value Expressions (SQL2) (p. 258)
  • Query Expressions (SQL2) (p. 261)
  • SQL Queries--A Final Summary (p. 267)
  • Part III Updating Data
  • 10 Database Updates (p. 271)
  • Adding Data to the Database (p. 272)
  • The Single-Row INSERT Statement (p. 273)
  • The Multi-Row INSERT Statement (p. 277)
  • Bulk Load Utilities (p. 280)
  • Deleting Data from the Database (p. 280)
  • The DELETE Statement (p. 280)
  • Deleting All Rows (p. 282)
  • DELETE with Subquery* (p. 283)
  • Modifying Data in the Database (p. 285)
  • The UPDATE Statement (p. 286)
  • Updating All Rows (p. 288)
  • UPDATE with Subquery* (p. 289)
  • Summary (p. 290)
  • 11 Data Integrity (p. 291)
  • What Is Data Integrity? (p. 292)
  • Required Data (p. 294)
  • Simple Validity Checking (p. 294)
  • Column Check Constraints (SQL2) (p. 295)
  • Domains (SQL2) (p. 296)
  • Entity Integrity (p. 297)
  • Other Uniqueness Constraints (p. 298)
  • Uniqueness and NULL Values (p. 298)
  • Referential Integrity (p. 299)
  • Referential Integrity Problems (p. 300)
  • Delete and Update Rules* (p. 302)
  • Cascaded Deletes and Updates* (p. 305)
  • Referential Cycles* (p. 308)
  • Foreign Keys and NULL Values* (p. 312)
  • Advanced Constraint Capabilities (SQL2) (p. 313)
  • Assertions (p. 314)
  • SQL2 Constraint Types (p. 315)
  • Deferred Constraint Checking (p. 316)
  • Business Rules (p. 319)
  • What Is a Trigger? (p. 320)
  • Triggers and Referential Integrity (p. 323)
  • Trigger Advantages and Disadvantages (p. 324)
  • Triggers and the SQL Standard (p. 324)
  • Summary (p. 325)
  • 12 Transaction Processing (p. 327)
  • What Is a Transaction? (p. 328)
  • COMMIT and ROLLBACK (p. 329)
  • The ANSI/ISO Transaction Model (p. 332)
  • Other Transaction Models (p. 334)
  • Transactions: Behind the Scenes* (p. 336)
  • Transactions and Multi-User Processing (p. 338)
  • The Lost Update Problem (p. 338)
  • The Uncommitted Data Problem (p. 339)
  • The Inconsistent Data Problem (p. 341)
  • The Phantom Insert Problem (p. 342)
  • Concurrent Transactions (p. 342)
  • Locking* (p. 345)
  • Locking Levels (p. 345)
  • Shared and Exclusive Locks (p. 347)
  • Deadlocks* (p. 348)
  • Advanced Locking Techniques* (p. 351)
  • Summary (p. 357)
  • Part IV Database Structure
  • 13 Creating a Database (p. 361)
  • The Data Definition Language (p. 362)
  • Creating a Database (p. 364)
  • Table Definitions (p. 365)
  • Creating a Table (CREATE TABLE) (p. 365)
  • Removing a Table (DROP TABLE) (p. 376)
  • Changing a Table Definition (ALTER TABLE) (p. 377)
  • Constraint Definitions (p. 381)
  • Assertions (p. 382)
  • Domains (p. 382)
  • Aliases and Synonyms (CREATE/DROP ALIAS) (p. 383)
  • Indexes (CREATE/DROP INDEX) (p. 385)
  • Managing Other Database Objects (p. 388)
  • Database Structure (p. 392)
  • Single-Database Architecture (p. 393)
  • Multi-Database Architecture (p. 394)
  • Multi-Location Architecture (p. 396)
  • Database Structure and the ANSI/ISO Standard (p. 398)
  • SQL2 Catalogs (p. 401)
  • SQL2 Schemas (p. 402)
  • Summary (p. 406)
  • 14 Views (p. 407)
  • What Is a View? (p. 408)
  • How the DBMS Handles Views (p. 410)
  • Advantages of Views (p. 410)
  • Disadvantages of Views (p. 411)
  • Creating a View (CREATE VIEW) (p. 411)
  • Horizontal Views (p. 412)
  • Vertical Views (p. 414)
  • Row/Column Subset Views (p. 416)
  • Grouped Views (p. 416)
  • Joined Views (p. 419)
  • Updating a View (p. 421)
  • View Updates and the ANSI/ISO Standard (p. 422)
  • View Updates in Commercial SQL Products (p. 423)
  • Checking View Updates (CHECK OPTION) (p. 424)
  • Dropping a View (DROP VIEW) (p. 426)
  • Summary (p. 428)
  • 15 SQL Security (p. 429)
  • SQL Security Concepts (p. 430)
  • User-Ids (p. 432)
  • Security Objects (p. 436)
  • Privileges (p. 436)
  • Views and SQL Security (p. 439)
  • Granting Privileges (GRANT) (p. 442)
  • Column Privileges (p. 444)
  • Passing Privileges (GRANT OPTION) (p. 445)
  • Revoking Privileges (REVOKE) (p. 447)
  • REVOKE and the GRANT OPTION (p. 450)
  • REVOKE and the ANSI/ISO Standard (p. 452)
  • Summary (p. 454)
  • 16 The System Catalog (p. 455)
  • What Is the System Catalog? (p. 456)
  • The Catalog and Query Tools (p. 457)
  • The Catalog and the ANSI/ISO Standard (p. 457)
  • Catalog Contents (p. 458)
  • Table Information (p. 459)
  • Column Information (p. 464)
  • View Information (p. 466)
  • Remarks (p. 470)
  • Relationship Information (p. 470)
  • User Information (p. 474)
  • Privileges Information (p. 476)
  • The SQL2 Information Schema (p. 477)
  • Other Catalog Information (p. 483)
  • Summary (p. 483)
  • Part V Programming with SQL
  • 17 Embedded SQL (p. 487)
  • Programmatic SQL Techniques (p. 488)
  • DBMS Statement Processing (p. 490)
  • Embedded SQL Concepts (p. 491)
  • Developing an Embedded SQL Program (p. 492)
  • Running an Embedded SQL Program (p. 492)
  • Simple Embedded SQL Statements (p. 498)
  • Declaring Tables (p. 501)
  • Error Handling (p. 502)
  • Using Host Variables (p. 511)
  • Data Retrieval in Embedded SQL (p. 520)
  • Single-Row Queries (p. 520)
  • Multi-Row Queries (p. 527)
  • Cursor-Based Deletes and Updates (p. 535)
  • Cursors and Transaction Processing (p. 540)
  • Summary (p. 541)
  • 18 Dynamic SQL* (p. 543)
  • Limitations of Static SQL (p. 544)
  • Dynamic SQL Concepts (p. 546)
  • Dynamic Statement Execution (EXECUTE IMMEDIATE) (p. 547)
  • Two-Step Dynamic Execution (p. 550)
  • The PREPARE Statement (p. 554)
  • The EXECUTE Statement (p. 555)
  • Dynamic Queries (p. 564)
  • The DESCRIBE Statement (p. 569)
  • The DECLARE CURSOR Statement (p. 572)
  • The Dynamic OPEN Statement (p. 572)
  • The Dynamic FETCH Statement (p. 575)
  • The Dynamic CLOSE Statement (p. 576)
  • Dynamic SQL Dialects (p. 576)
  • Dynamic SQL in SQL/DS (p. 577)
  • Dynamic SQL in Oracle* (p. 580)
  • Dynamic SQL and the SQL2 Standard (p. 584)
  • Basic Dynamic SQL2 Statements (p. 585)
  • SQL2 and the SQLDA (p. 587)
  • SQL2 and Dynamic SQL Queries (p. 594)
  • Summary (p. 598)
  • 19 SQL APIs (p. 601)
  • API Concepts (p. 602)
  • The dblib API (SQL Server) (p. 604)
  • Basic SQL Server Techniques (p. 606)
  • SQL Server Queries (p. 613)
  • Positioned Updates (p. 619)
  • Dynamic Queries (p. 620)
  • ODBC and the SQL/CLI Standard (p. 625)
  • Call-Level Interface Standardization (p. 625)
  • CLI Structures (p. 631)
  • CLI Statement Processing (p. 635)
  • CLI Errors and Diagnostic Information (p. 654)
  • CLI Attributes (p. 656)
  • CLI Information Calls (p. 658)
  • The ODBC API (p. 659)
  • The Structure of ODBC (p. 659)
  • ODBC and DBMS Independence (p. 661)
  • ODBC Catalog Functions (p. 661)
  • Extended ODBC Capabilities (p. 663)
  • The Oracle Call Interface (OCI) (p. 667)
  • Legacy OCI (p. 667)
  • OCI and Oracle8 (p. 670)
  • Summary (p. 677)
  • Part VI SQL Today and Tomorrow
  • 20 Database Processing and Stored Procedures (p. 681)
  • Stored Procedure Concepts (p. 682)
  • A Basic Example (p. 683)
  • Using Stored Procedures (p. 684)
  • Creating a Stored Procedure (p. 686)
  • Calling a Stored Procedure (p. 689)
  • Stored Procedure Variables (p. 690)
  • Statement Blocks (p. 692)
  • Returning a Value (p. 695)
  • Returning Values via Parameters (p. 697)
  • Conditional Execution (p. 701)
  • Repeated Execution (p. 703)
  • Other Flow-of-Control Constructs (p. 705)
  • Cursor-Based Repetition (p. 706)
  • Handling Error Conditions (p. 710)
  • Advantages of Stored Procedures (p. 713)
  • Stored Procedure Performance (p. 713)
  • System-Defined Stored Procedures (p. 714)
  • External Stored Procedures (p. 715)
  • Triggers (p. 716)
  • Advantages and Disadvantages of Triggers (p. 716)
  • Triggers in Transact-SQL (p. 717)
  • Triggers in Informix SPL (p. 719)
  • Triggers in Oracle PL/SQL (p. 722)
  • Other Trigger Considerations (p. 723)
  • Stored Procedures and the SQL Standard (p. 724)
  • Core Capabilities (p. 724)
  • Creating a SQL Routine (p. 725)
  • Flow-of-Control Statements (p. 725)
  • Cursor Operations (p. 726)
  • Block Structure (p. 727)
  • Error Handling (p. 730)
  • Routine Name Overloading (p. 731)
  • Other Stored Procedure Considerations (p. 732)
  • Summary (p. 733)
  • 21 SQL and Data Warehousing (p. 735)
  • Data Warehousing Concepts (p. 736)
  • Components of a Data Warehouse (p. 738)
  • The Evolution of Data Warehousing (p. 739)
  • Database Architecture for Warehousing (p. 740)
  • Fact Cubes (p. 740)
  • Star Schemas (p. 742)
  • Multi-Level Dimensions (p. 745)
  • SQL Extensions for Data Warehousing (p. 746)
  • Warehouse Performance (p. 747)
  • Load Performance (p. 747)
  • Query Performance (p. 749)
  • Summary (p. 750)
  • 22 SQL Networking and Distributed Databases (p. 751)
  • The Challenge of Distributed Data Management (p. 752)
  • Distributing Data--Practical Approaches (p. 758)
  • Remote Database Access (p. 758)
  • Remote Data Transparency (p. 762)
  • Table Extracts (p. 764)
  • Table Replication (p. 766)
  • Updateable Replicas (p. 769)
  • Replication Tradeoffs (p. 770)
  • Typical Replication Architectures (p. 771)
  • Distributed Database Access (p. 776)
  • Remote Requests (p. 777)
  • Remote Transactions (p. 778)
  • Distributed Transactions (p. 779)
  • Distributed Requests (p. 780)
  • The Two-Phase Commit Protocol* (p. 782)
  • Network Applications and Database Architecture (p. 785)
  • Client/Server Applications and Database Architecture (p. 786)
  • Client/Server Applications with Stored Procedures (p. 787)
  • Enterprise Applications and Data Caching (p. 789)
  • High-Volume Internet Data Management (p. 790)
  • Summary (p. 792)
  • 23 SQL and Objects (p. 793)
  • Object-Oriented Databases (p. 794)
  • Object-Oriented Database Characteristics (p. 794)
  • Pros and Cons of Object-Oriented Databases (p. 796)
  • Objects and the Database Market (p. 797)
  • Object-Relational Databases (p. 798)
  • Large Object Support (p. 799)
  • BLOBs in the Relational Model (p. 799)
  • Specialized BLOB Processing (p. 801)
  • Abstract (Structured) Data Types (p. 803)
  • Defining Abstract Data Types (p. 805)
  • Manipulating Abstract Data Types (p. 808)
  • Inheritance (p. 809)
  • Table Inheritance--Implementing Object Classes (p. 812)
  • Sets, Arrays, and Collections (p. 815)
  • Defining Collections (p. 817)
  • Querying Collection Data (p. 820)
  • Manipulating Collection Data (p. 822)
  • Collections and Stored Procedures (p. 823)
  • User-Defined Data Types (p. 825)
  • Methods and Stored Procedures (p. 826)
  • Summary (p. 830)
  • 24 The Future of SQL (p. 831)
  • Database Market Trends (p. 832)
  • Enterprise Database Market Maturity (p. 833)
  • Market Diversity and Segmentation (p. 834)
  • Packaged Enterprise Applications (p. 834)
  • Hardware Performance Gains (p. 835)
  • Benchmark Wars (p. 837)
  • SQL Standardization (p. 839)
  • SQL in the Next Decade (p. 840)
  • Distributed Databases (p. 841)
  • Massive Data Warehousing (p. 841)
  • Ultra-High-Performance Databases (p. 842)
  • Internet and Network Services Integration (p. 843)
  • Embedded Databases (p. 843)
  • Object Integration (p. 844)
  • Part VII Appendices
  • A The Sample Database (p. 849)
  • B Database Vendor Profiles (p. 857)
  • A2i, Inc. (www.a2i.com) (p. 859)
  • Angara Database Systems (www.angara.com) (p. 859)
  • Arbor Software (www.hyperion.com) (p. 859)
  • Ardent Software (www.ardentsoftware.com) (p. 860)
  • Centura Software (www.centurasoft.com) (p. 860)
  • Cloudscape, Inc. (www.cloudscape.com) (p. 861)
  • Computer Associates (www.cai.com) (p. 861)
  • Computer Corporation of America (www.cca-int.com) (p. 862)
  • Empress Software (www.empress.com) (p. 863)
  • IBM Corporation (www.ibm.com) (p. 863)
  • Informix Software (www.informix.com) (p. 864)
  • Microsoft Corporation (www.microsoft.com) (p. 865)
  • Object Design (www.odi.com) (p. 866)
  • Objectivity (www.objectivity.com) (p. 867)
  • Oracle Corporation (www.oracle.com) (p. 867)
  • Persistence Software (www.persistence.com) (p. 868)
  • Pervasive Software (www.pervasive.com) (p. 869)
  • Quadbase Systems (www.quadbase.com) (p. 869)
  • Raima Corporation (www.raima.com) (p. 870)
  • Red Brick Systems (www.redbrick.com) (p. 870)
  • Rogue Wave Software (www.roguewave.com) (p. 871)
  • Sybase, Inc. (www.sybase.com) (p. 871)
  • Tache Group (www.tachegroup.com) (p. 873)
  • Tandem Computers (www.tandem.com) (p. 873)
  • TimesTen Performance Software (www.timesten.com) (p. 874)
  • Versant Corporation (www.versant.com) (p. 874)
  • C Company and Product List (p. 877)
  • D SQL Syntax Reference (p. 885)
  • Data Definition Statements (p. 886)
  • Basic Data Manipulation Statements (p. 888)
  • Transaction Processing Statements (p. 889)
  • Cursor-Based Statements (p. 889)
  • Query Expressions (p. 890)
  • Search Conditions (p. 892)
  • Expressions (p. 892)
  • Statement Elements (p. 893)
  • Simple Elements (p. 893)
  • E SQL Call Level Interface (p. 895)
  • CLI Return Values (p. 898)
  • General Handle Management Routines (p. 898)
  • SQL Environment Management Routines (p. 898)
  • SQL Connection Management Routines (p. 899)
  • SQL Statement Management Routines (p. 901)
  • SQL Statement Execution Routines (p. 902)
  • Query Results Processing Routines (p. 902)
  • Query Results Description Routines (p. 904)
  • Query Results Descriptor Management Routines (p. 904)
  • Deferred Dynamic Parameter Processing Routines (p. 906)
  • Error, Status, and Diagnostic Routines (p. 906)
  • CLI Implementation Information Routines (p. 907)
  • CLI Parameter Value Codes (p. 908)
  • F SQL Information Schema Standard (p. 915)
  • SCHEMATA View (p. 917)
  • TABLES View (p. 918)
  • COLUMNS View (p. 919)
  • VIEWS View (p. 920)
  • VIEW_TABLE_USAGE View (p. 921)
  • VIEW_COLUMN_USAGE View (p. 922)
  • TABLE_CONSTRAINTS View (p. 922)
  • REFERENTIAL_CONSTRAINTS View (p. 923)
  • CHECK_CONSTRAINTS View (p. 924)
  • KEY_COLUMN_USAGE View (p. 925)
  • ASSERTIONS View (p. 925)
  • CONSTRAINT_TABLE_USAGE View (p. 926)
  • CONSTRAINT_COLUMN_USAGE View (p. 926)
  • TABLE_PRIVILEGES View (p. 927)
  • COLUMN_PRIVILEGES View (p. 928)
  • USAGE_PRIVILEGES View (p. 929)
  • DOMAINS View (p. 930)
  • DOMAIN_CONSTRAINTS View (p. 931)
  • DOMAIN_COLUMN_USAGE View (p. 932)
  • CHARACTER_SETS View (p. 932)
  • COLLATIONS View (p. 933)
  • TRANSLATIONS View (p. 934)
  • SQL_LANGUAGES View (p. 935)
  • G CD-ROM Installation Guide (p. 937)
  • Installing the SQL DBMS Software (p. 939)
  • Microsoft SQL Server 7 (p. 939)
  • Hardware and Software Requirements (p. 940)
  • SQL Server Services User Accounts (p. 940)
  • SQL Server 7.0 Installation (p. 941)
  • Starting SQL Server 7.0 (p. 942)
  • Stopping SQL Server 7.0 (p. 943)
  • Uninstalling SQL Server 7.0 (p. 943)
  • Oracle8 (p. 944)
  • Products Included on the CD (p. 944)
  • Hardware and Software Requirements (p. 946)
  • Products Available for Installation (p. 947)
  • Oracle8 Personal Edition Installation (p. 948)
  • Starting Oracle8 Personal Edition (p. 950)
  • Stopping Oracle8 Personal Edition (p. 950)
  • Uninstalling Oracle8 Personal Edition (p. 950)
  • Informix (p. 951)
  • Hardware and Software Requirements (p. 952)
  • Informix User Accounts (p. 952)
  • Informix Personal Edition Installation (p. 952)
  • Starting Informix Personal Edition (p. 954)
  • Stopping Informix Personal Edition (p. 954)
  • Troubleshooting Installation Problems (p. 955)
  • Uninstalling Informix Personal Edition (p. 955)
  • Sybase (p. 956)
  • Hardware and Software Requirements (p. 956)
  • Sybase Adaptive Server Anywhere Installation (p. 957)
  • Starting Sybase Adaptive Server Anywhere (p. 958)
  • Stopping Sybase Adaptive Server Anywhere (p. 958)
  • Uninstalling Sybase Adaptive Server Anywhere (p. 958)
  • IBM DB2 (p. 959)
  • Hardware and Software Requirements (p. 959)
  • DB2 User Accounts (p. 960)
  • DB2 Personal Edition Installation (p. 961)
  • Starting DB2 Personal Edition (p. 962)
  • Stopping DB2 Personal Edition (p. 962)
  • Verifying the Installation (p. 963)
  • Troubleshooting Installation Problems (p. 963)
  • Uninstalling DB2 Personal Edition (p. 963)
  • Index (p. 965)

Author notes provided by Syndetics

James R. Groff and Paul N. Weinberg were the cofounders of Network Innovations Corporation, an early developer of SQL-based networking software that linked personal computers to corporate databases. Groff is currently CEO of TimesTen Performance Software, developer of an ultra-high-performance main-memory SQL database for communications and Internet applications. Weinberg is Vice President of A2i, Inc., developer of a database-driven, cross-media catalog publishing system that supports printed and electronic output from a single data source.