The Fictioning Horror Sale
 
 

Recently Viewed clear list


Original Essays | September 4, 2014

Edward E. Baptist: IMG The Two Bodies of The Half Has Never Been Told: Slavery and the Making of American Capitalism



My new book, The Half Has Never Been Told: Slavery and the Making of American Capitalism, is the story of two bodies. The first body was the new... Continue »
  1. $24.50 Sale Hardcover add to wish list

spacer
Qualifying orders ship free.
$29.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Computer Languages- SQL

Other titles in the Sybex Instant Reference series:

SQL Instant Reference (Sybex Instant Reference)

by

SQL Instant Reference (Sybex Instant Reference) Cover

 

Synopses & Reviews

Publisher Comments:

SQL stands for Structured Query Language and is a specialized programming language for sending queries to databases. It is the only universal language for relational databases and has wide acceptance. First standardized in 1986, it was updated in 1989 and 1992, and a new standard is expected in 1999. The new version, SQL 3, will add support for object-oriented design, a hot topic in the database community. There is a great deal of interest in SQL now because of its continuing importance for corporate database and enterprise application programmers and its applicability to all major databases, including SQL Server, Oracle, Sybex, and IBM DB/2.

Synopsis:

This edition offers programmers or administrators with a quick-reference guide that deals with SQL code.

Synopsis:

Find the Explanation You Need--Quickly, Easily, Every Time

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.

Synopsis:

Find the Explanation You Need—Quickly, Easily, Every Time

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.

About the Author

Martin Gruber is a recognized SQL expert and is also the author of Understanding SQL and the soon-to-be-published Mastering SQL. He is a freelance writer, teacher, and consultant based in the San Francisco Bay Area.

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.

The Structure of the Standard andConformance Levels.

New Types of Data.

Extensions to SQL Statements.

Programmatic Extensions to SQL.

A Quick Overview of Object-OrientedConcepts.

Integrating Objects into the RelationalWorld.

Summary.

Chapter 2: Core SQL99.

What Is Core?

Distinct User-Defined Datatypes (UDTs).

Summary.

Appendix A: Mapping SQL to Other Lanuages.

Ada.

C/C++.

COBOL.

Fortran.

MUMPS.

Pascal.

PL/I.

Appendix B: Specification of the Module Language.

Overview.

Syntax.

Appendix C:Specification of Dynamic SQL.

Appendix D: SQL Linguistic Definitions and Conventions.

Identifiers.

SQL Keywords.

Appendix E: Upgrade Path from SQL92 to Core SQL99.

Core SQL99 Features.

Appendix F: Error Codes.

SQLCODE.

SQLSTATE.

Appendix G: Glossary.

Index.

Product Details

ISBN:
9780782125399
Author:
Gruber, Martin
Publisher:
Sybex
Author:
Gruber
Location:
San Francisco, Calif. :
Subject:
Programming Languages - SQL
Subject:
Database Management - General
Subject:
Database management
Subject:
Relational databases
Subject:
Sql (computer program language)
Subject:
SQL
Subject:
Computer Languages-SQL
Subject:
Programming - Software Development
Copyright:
Edition Number:
2
Series:
Sybex Instant Reference Series
Series Volume:
3562
Publication Date:
20000330
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
388
Dimensions:
7.96x4.77x.88 in. .80 lbs.

Other books you might like

  1. VB Developer's Guide to ADO Used Trade Paper $5.95
  2. Study Power Used Trade Paper $9.95
  3. When in the Course of Human Events Used Hardcover $11.50
  4. The World of Athens (Joint... Used Trade Paper $9.95
  5. Murder in the Sentier Used Trade Paper $7.95

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management
Health and Self-Help » Health and Medicine » Medical Specialties
Health and Self-Help » Health and Medicine » Pharmacology

SQL Instant Reference (Sybex Instant Reference) New Trade Paper
0 stars - 0 reviews
$29.99 In Stock
Product details 388 pages Sybex Inc - English 9780782125399 Reviews:
"Synopsis" by , This edition offers programmers or administrators with a quick-reference guide that deals with SQL code.
"Synopsis" by , Find the Explanation You Need--Quickly, Easily, Every Time

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.

"Synopsis" by , Find the Explanation You Need—Quickly, Easily, Every Time

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.

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.