MTU Library Catalogue

Syndetics cover image
Image from Syndetics

Introduction to SQL / Rick F. van der Lans, translated by Andrea Gray.

By: Lans, Rick F. van der.
Material type: materialTypeLabelBookPublisher: Wokingham, England : Addison-Wesley Pub. Co, c1988Description: x, 348 p. ; 24 cm.ISBN: 0201175215 ; 9780201175219.Subject(s): SQL (Computer program language) | Database programmingDDC classification: 005.756 | 005.756 LAN
Contents:
Introduction -- SQL in a Nutshell -- Creating Databases and Tables -- Querying Tables: The SELECT Statement -- More on the SELECT Statement -- Writing Reports -- Updating tables -- Optimizing Statements -- Views -- User and Data Security -- Catalog Tables -- Application Development with SQL -- Database Design -- An Overview of Thirteen Implementations of SQL -- Expected Extensions to SQL and an Afterword.
Summary: This book provides a technical introduction to the features of SQL.
Holdings
Item type Current library Call number Copy number Status Barcode
General lending MTU Bishopstown Library Lending 005.756 (Browse shelf(Opens below)) 1 Available 00020590
General lending MTU Kerry North Campus Library Ground Floor Main 005.756 LAN (Browse shelf(Opens below)) 1 Available 38888000252845
Total holds: 0

Enhanced descriptions from Syndetics:

This book provides a technical introduction to the features of SQL.

Bibliography: (pages 339-342) and index.

Introduction -- SQL in a Nutshell -- Creating Databases and Tables -- Querying Tables: The SELECT Statement -- More on the SELECT Statement -- Writing Reports -- Updating tables -- Optimizing Statements -- Views -- User and Data Security -- Catalog Tables -- Application Development with SQL -- Database Design -- An Overview of Thirteen Implementations of SQL -- Expected Extensions to SQL and an Afterword.

This book provides a technical introduction to the features of SQL.

Translation of: Het SQL leerboek.

Table of contents provided by Syndetics

  • Querying data (joins, functions and subqueries)
  • Updating data
  • Creating tables and views
  • Specifying primary and foreign keys and other constraints
  • Using indexes
  • Data security
  • Developing stored procedures and triggers
  • Application development with embedded SQL and ODBC
  • Transactions
  • Optimization of statements
  • Dealing with object relational concepts, such as subtables, references, sets and user-defined data types in the catalog