MTU Cork 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 .Subject(s): SQL (Computer program language)DDC classification: 005.756
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.
Holdings
Item type Current library Call number Copy number Status Date due Barcode Item holds
General Lending MTU Bishopstown Library Lending 005.756 (Browse shelf(Opens below)) 1 Available 00020590
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.

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

Powered by Koha