Understanding Sql

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. PartIV: 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.  Appendix A: Mapping SQL to Other Lanuages. 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.