Skip to main content
  • Book
  • © 1990

Understanding SQL

Palgrave Macmillan

Authors:

Part of the book series: Computer Science Series (COMPSS)

Buy it now

Buying options

eBook USD 19.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 29.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (13 chapters)

  1. Front Matter

    Pages i-xvii
  2. Introduction to SQL

    • Elizabeth Lynch
    Pages 1-8
  3. SQL basic terms

    • Elizabeth Lynch
    Pages 9-15
  4. An example of setting up an SQL system

    • Elizabeth Lynch
    Pages 16-25
  5. Creating Databases and Tables Inputting Data

    • Elizabeth Lynch
    Pages 26-38
  6. Querying the database

    • Elizabeth Lynch
    Pages 39-64
  7. More about SELECT

    • Elizabeth Lynch
    Pages 65-82
  8. Updating the Database

    • Elizabeth Lynch
    Pages 83-96
  9. Creating and using views

    • Elizabeth Lynch
    Pages 97-113
  10. Optimising performance

    • Elizabeth Lynch
    Pages 114-124
  11. Database security and integrity

    • Elizabeth Lynch
    Pages 125-134
  12. Embedded SQL

    • Elizabeth Lynch
    Pages 135-142
  13. Non-standard SQL

    • Elizabeth Lynch
    Pages 143-154
  14. The relational database model

    • Elizabeth Lynch
    Pages 155-165
  15. Back Matter

    Pages 166-174

About this book

This introduction to the SQL database manipulation language, based around the 1986 ANSI standard, uses DB2, dBASE IV SQL, Informix and Oracle as representatives of the range of over 50 SQL implementations.

Bibliographic Information

  • Book Title: Understanding SQL

  • Authors: Elizabeth Lynch

  • Series Title: Computer Science Series

  • DOI: https://doi.org/10.1007/978-1-349-11552-5

  • Publisher: Palgrave Macmillan London

  • eBook Packages: Computer Science, Computer Science (R0)

  • Copyright Information: Elizabeth Lynch 1990

  • Softcover ISBN: 978-0-333-52433-6Published: 18 June 1990

  • eBook ISBN: 978-1-349-11552-5Published: 18 June 1990

  • Series ISSN: 2946-8973

  • Series E-ISSN: 2946-8981

  • Edition Number: 1

  • Number of Pages: XVII, 174

  • Topics: Programming Languages, Compilers, Interpreters

Buy it now

Buying options

eBook USD 19.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 29.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access