Résumé
If you use SQL to program, administer, or query databases, SQL Instant Reference is an essential desktop resource. Inside, you'll find complete, alphabetical coverage of all SQL statements, plus detailed explanations of common statement elements. You also get a special section covering SQL99 and a glossary of relevant terms. No other SQL reference packs so much useful information into such a handy format.
Features:
- Check the Syntax and Function of Any SQL
Statement—In an Instant
- Includes an Entire Section Devoted to SQL99
- Newly Expanded and Updated
Table of contents
- Introduction
- Part I: Introduction to SQL
- SQL: An Overview
- The Fundamentals of SQL and Relational Databases
- A Relational Database Primer
- Joining Tables
- Basics of the SQL Language
- Overview of the SQL Standards
- Notable Features of Standard SQL
- Part II: SQL Statement Reference
- ALLOCATE CURSOR
- ALLOCATE DESCRIPTOR
- ALTER DOMAIN
- ALTER TABLE
- CLOSE
- COMMIT WORK
- CONNECT
- CREATE ASSERTION
- CREATE CHARACTER SET
- CREATE COLLATION
- CREATE DOMAIN
- CREATE SCHEMA
- CREATE TABLE
- CREATE TRANSLATION
- CREATE VIEW
- DEALLOCATE DESCRIPTOR
- DEALLOCATE PREPARE
- DECLARE CURSOR
- DECLARE LOCAL TEMPORARY TABLE
- DELETE
- DESCRIBE
- DISCONNECT
- DROP ASSERTION
- DROP CHARACTER SET
- DROP COLLATION
- DROP DOMAIN
- DROP SCHEMA
- DROP TABLE
- DROP TRANSLATION
- DROP VIEW
- EXECUTE
- EXECUTE IMMEDIATE
- FETCH
- GET DESCRIPTOR
- GET DIAGNOSTICS
- GRANT
- INSERT
- OPEN
- PREPARE
- REVOKE
- ROLLBACK
- SELECT
- SET CATALOG
- SET CONNECTION
- SET CONSTRAINTS MODE
- SET DESCRIPTOR
- SET NAMES
- SET SCHEMA
- SET SESSION AUTHORIZATION
- SET TIME ZONE
- SET TRANSACTION
- UPDATE
- Part III: Common Elements
- Aggregate Functions
- Authorization IDs
- CASE Expressions
- CAST Expressions
- Collations
- Constraints
- Datatypes
- Datetime Value Functions
- Descriptor Areas
- Numeric Value Functions
- Predicates
- Row and Table Value Constructors
- String Value Functions
- Subqueries
- Value Expressions
- Part IV:
- Chapter 1: SQL99: An Overview
- Chapter 2: Core SQL99
- Appendix A: Mapping SQL to Other Lanuages
- Appendix B: Specification of the Module Language
- Appendix C:Specification of Dynamic SQL
- Appendix D: SQL Linguistic Definitions and
Conventions
- Appendix E: Upgrade Path from SQL92 to Core SQL99
- Appendix G: Glossary
- Index
L'auteur - Martin Gruber
is a programmer and writer who specializes in database programming and design. He has also taught database courses at the university level and is the author of best-selling Understanding SQL and SQL Instant Reference, both from Sybex.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Sybex |
Auteur(s) | Martin Gruber |
Parution | 20/02/2000 |
Édition | 2eme édition |
Nb. de pages | 368 |
Format | 12 x 20,1 |
Poids | 334g |
EAN13 | 9780782125399 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse