Introduction to SQL / Rick F. van der Lans, translated by Andrea Gray.
By: Lans, Rick F. van der
.
Material type: ![materialTypeLabel](/opac-tmpl/lib/famfamfam/BK.png)
![](/opac-tmpl/bootstrap/images/filefind.png)
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 |
Browsing MTU Bishopstown Library shelves, Shelving location: Lending Close shelf browser (Hides shelf browser)
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