IBM Books

SQL Getting Started

This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties and any statements provided in this manual should not be interpreted as such.

Order publications through your IBM representative or the IBM branch office serving your locality or by calling 1-800-879-2755 in U.S. or 1-800-IBM-4YOU in Canada.

When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you.

© Copyright International Business Machines Corporation 1993, 1997. All rights reserved.
Note to U.S. government Users -- Documentation related to restricted rights -- Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp.

Table of Contents

Welcome

  • Related Documentation for This Book
  • Highlighting Conventions

    • Chapter 1. Relational Databases and SQL

    Chapter 2. Organizing Data

  • Tables
  • Views
  • Schemas
  • Data Types

    • Chapter 3. Creating Tables and Views

  • Creating Tables
  • Inserting Data
  • Changing Data
  • Deleting Data
  • Creating Views
  • Using Views to Manipulate Data

    • Chapter 4. Using SQL Statements to Access Data

  • Connecting to a Database
  • Investigating Errors
  • Selecting Columns
  • Selecting Rows
  • Sorting Rows
  • Removing Duplicate Rows
  • Order of Operations
  • Using Expressions to Calculate Values
  • Naming Expressions
  • Selecting Data from More Than One Table
  • Using a Subquery
  • Using Functions
  • Column Functions
  • Scalar Functions
  • Grouping
  • Using a WHERE Clause with a GROUP BY Clause
  • Using the HAVING Clause After the GROUP BY Clause

    • Chapter 5. Expressions and Subqueries

  • Scalar Fullselects
  • Casting Data Types
  • Case Expressions
  • Table Expressions
  • Nested Table Expressions
  • Common Table Expressions
  • Correlation Names
  • Correlated Subqueries
  • Implementing a Correlated Subquery

    • Chapter 6. Using Operators and Predicates in Queries

  • Combining Queries by Set Operators
  • UNION Operator
  • EXCEPT Operator
  • INTERSECT operator
  • Predicates
  • Using the IN Predicate
  • Using the BETWEEN Predicate
  • Using the LIKE Predicate
  • Using the EXISTS Predicate
  • Quantified Predicates

    • Chapter 7. Advanced SQL

  • Enforcing Business Rules with Constraints and Triggers
  • Keys
  • Unique Constraints
  • Referential Integrity Constraints
  • Table Check Constraints
  • Triggers
  • Joins
  • Complex Queries
  • ROLLUP and CUBE Queries
  • Recursive Queries

    • Chapter 8. Customizing and Enhancing Data Manipulation

  • User-Defined Types
  • User-Defined Functions
  • Large Objects (LOBs)
  • Manipulating Large Objects (LOBs)
  • Special Registers
  • Introduction to Catalog Views
  • Selecting Rows from System Catalogs

    • Appendix A. Sample Tables

  • The Sample Database
  • To Install the Sample Database
  • To Erase the Sample Database
  • CL_SCHED Table
  • DEPARTMENT Table
  • EMPLOYEE Table
  • EMP_ACT Table
  • EMP_PHOTO Table
  • EMP_RESUME Table
  • IN_TRAY Table
  • ORG Table
  • PROJECT Table
  • SALES Table
  • STAFF Table
  • STAFFG Table
  • Sample Files with BLOB and CLOB Data Type
  • Quintana Photo
  • Quintana Resume
  • Nicholls Photo
  • Nicholls Resume
  • Adamson Photo
  • Adamson Resume
  • Walker Photo
  • Walker Resume

    • Appendix B. How the DB2 Library Is Structured

  • SmartGuides
  • Online Help
  • DB2 Books
  • About the Information Center

    • Appendix C. Notices

  • Trademarks
  • Trademarks of Other Companies

    • Appendix D. Contacting IBM

    Index

    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

    [ DB2 List of Books | Search the DB2 Books ]