SQL in a Nutshell. A Desktop Quick Reference

Spis treści ebooka

• SQL in a Nutshell, 2nd Edition
• SPECIAL OFFER: Upgrade this ebook with OReilly
• Preface
  • Why This Book?
  • Who Should Read This Book?
  • How This Book Is Organized
  • Conventions Used in This Book
  • How to Use This Book
  • How to Contact Us
  • Safari Enabled
  • Resources
  • Changes in the Second Edition
  • Acknowledgments
    • Brand Hunts Acknowledgments
    • Daniel Kline's Acknowledgments
    • Kevin E. Kline's Acknowledgments
• 1. SQL History and Implementations
  • 1.1. The Relational Model and ANSI SQL
    • 1.1.1. Codd's Rules for Relational Database Systems
      • 1.1.1.1. Data structures (rules 1, 2, and 8)
      • 1.1.1.2. NULLS (rule 3)
      • 1.1.1.3. Metadata (rules 4 and 10)
      • 1.1.1.4. The language (rules 5 and 11)
      • 1.1.1.5. Views (rule 6)
      • 1.1.1.6. Set operations (rules 7 and 12)
    • 1.1.2. Codd's Rules in Action: Simple SELECT Examples
  • 1.2. History of the SQL Standard
    • 1.2.1. What's New in SQL2003
    • 1.2.2. Levels of Conformance
    • 1.2.3. Supplemental Features Packages in the SQL2003 Standard
    • 1.2.4. SQL2003 Statement Classes
  • 1.3. SQL Dialects
• 2. Foundational Concepts
  • 2.1. Database Platforms Described in This Book
  • 2.2. Categories of Syntax
    • 2.2.1. Identifiers
      • 2.2.1.1. Naming conventions
      • 2.2.1.2. Identifier rules
    • 2.2.2. Literals
    • 2.2.3. Operators
      • 2.2.3.1. Arithmetic operators
      • 2.2.3.2. Assignment operators
      • 2.2.3.3. Bitwise operators
      • 2.2.3.4. Comparison operators
      • 2.2.3.5. Logical operators
      • 2.2.3.6. Unary operators
      • 2.2.3.7. Operator precedence
      • 2.2.3.8. System delimiters and operators
    • 2.2.4. Keywords and Reserved Words
  • 2.3. SQL2003 and Platform-Specific Datatypes
    • 2.3.1. DB2 Datatypes
    • 2.3.2. MySQL Datatypes
    • 2.3.3. Oracle Datatypes
    • 2.3.4. PostgreSQL Datatypes
    • 2.3.5. SQL Server Datatypes
  • 2.4. Constraints
    • 2.4.1. Scope
    • 2.4.2. Syntax
    • 2.4.3. PRIMARY KEY Constraints
    • 2.4.4. FOREIGN KEY Constraints
    • 2.4.5. UNIQUE Constraints
    • 2.4.6. CHECK Constraints
• 3. SQL Statement Command Reference
  • 3.1. How to Use This Chapter
  • 3.2. SQL Platform Support
  • 3.3. SQL Command Reference
    • ALL/ANY/SOME Operators
    • BETWEEN Operator
    • CALL Statement
    • CLOSE CURSOR Statement
    • COMMIT Statement
    • CONNECT
    • CREATE/ALTER DATABASE Statement
    • CREATE/ALTER FUNCTION/PROCEDURE Statements
    • CREATE/ALTER INDEX Statement
    • CREATE/ALTER METHOD Statement
    • CREATE ROLE Statement
    • CREATE SCHEMA Statement
    • CREATE/ALTER TABLE Statement
    • CREATE/ALTER TRIGGER Statement
    • CREATE/ALTER TYPE Statement
    • CREATE/ALTER VIEW Statement
    • DECLARE CURSOR Command
    • DELETE Statement
    • DISCONNECT Statement
    • DROP Statements
    • EXCEPT Set Operator
    • EXISTS Operator
    • FETCH Statement
    • GRANT Statement
    • IN Operator
    • INSERT Statement
    • INTERSECT Set Operator
    • IS Operator
    • JOIN Subclause
    • LIKE Operator
    • MERGE Statement
    • OPEN Statement
    • ORDER BY Clause
    • RELEASE SAVEPOINT Statement
    • RETURN Statement
    • REVOKE Statement
    • ROLLBACK Statement
    • SAVEPOINT Statement
    • SELECT Statement
    • SET Statement
    • SET CONNECTION Statement
    • SET CONSTRAINT Statement
    • SET PATH Statement
    • SET ROLE Statement
    • SET SCHEMA Statement
    • SET SESSION AUTHORIZATION Statement
    • SET TIME ZONE Statement
    • SET TRANSACTION Statement
    • START TRANSACTION Statement
    • SUBQUERY Substatement
    • TRUNCATE TABLE Statement
    • UNION Set Operator
    • UPDATE Statement
    • WHERE Clause
• 4. SQL Functions
  • 4.1. Types of Functions
    • 4.1.1. Deterministic and Nondeterministic Functions
    • 4.1.2. Aggregate and Scalar Functions
    • 4.1.3. Window Functions
  • 4.2. ANSI SQL Aggregate Functions
    • AVG and SUM
    • CORR
    • COUNT
    • COVAR_POP
    • COVAR_SAMP
    • CUME_DIST
    • DENSE_RANK
    • MIN and MAX
    • PERCENT_RANK
    • PERCENTILE_CONT
    • PERCENTILE_DISC
    • RANK
    • The REGR Family of Functions
    • STDDEV_POP
    • STDDEV_SAMP
    • VAR_POP
    • VAR_SAMP
  • 4.3. ANSI SQL Window Functions
    • 4.3.1. SQL2003's Window Syntax
    • 4.3.2. Oracle's Window Syntax
    • 4.3.3. DB2's Window Syntax
    • 4.3.4. Partitioning
    • 4.3.5. Ordering
    • 4.3.6. Grouping or Windowing
    • 4.3.7. List of Window Functions
      • CUME_DIST( )
      • DENSE_RANK( )
      • RANK( )
      • PERCENT_RANK
      • ROW_NUMBER
  • 4.4. ANSI SQL Scalar Functions
    • 4.4.1. Built-in Scalar Functions
      • DB2
    • 4.4.2. CASE and CAST Functions
      • CASE
      • CAST
    • 4.4.3. Numeric Scalar Functions
      • ABS
      • BIT_LENGTH, CHAR_LENGTH, and OCTET_LENGTH
      • CEIL
      • EXP
      • EXTRACT
      • FLOOR
      • LN
      • MOD
      • POSITION
      • POWER
      • SQRT
      • WIDTH_BUCKET
    • 4.4.4. String Functions and Operators
    • Reference Section
      • Concatenation Operator
    • Reference Section
      • CONVERT and TRANSLATE
    • Reference Section
      • LOWER and UPPER
    • Reference Section
      • OVERLAY
    • Reference Section
      • SUBSTRING
    • Reference Section
      • TRIM
  • 4.5. Platform-Specific Extensions
    • 4.5.1. DB2-Supported Extensions
    • 4.5.2. MySQL-Supported Functions
    • 4.5.3. Oracle-Supported Functions
    • 4.5.4. PostgreSQL-Supported Functions
    • 4.5.5. SQL Server-Supported Functions
• 5. Database Programming
  • 5.1. Database Programming Overview
  • 5.2. Opening a Database Connection
    • 5.2.1. Opening an ADO.NET Database Connection
    • 5.2.2. Opening a JDBC Database Connection
      • 5.2.2.1. DB2
      • 5.2.2.2. MySQL
      • 5.2.2.3. PostgreSQL
      • 5.2.2.4. Oracle
      • 5.2.2.5. SQL Server
  • 5.3. Closing a Database Connection
    • 5.3.1. Closing an ADO.NET Database Connection
    • 5.3.2. Closing a JDBC Database Connection
  • 5.4. Managing Transactions
    • 5.4.1. Beginning a Transaction
      • 5.4.1.1. Beginning an ADO.NET transaction
      • 5.4.1.2. Beginning a JDBC transaction
    • 5.4.2. Committing a Transaction
      • 5.4.2.1. Committing an ADO.NET transaction
      • 5.4.2.2. Committing a JDBC transaction
    • 5.4.3. Rolling Back a Transaction
      • 5.4.3.1. Rolling back an ADO.NET transaction
      • 5.4.3.2. Rolling back a JDBC transaction
  • 5.5. Executing Statements
    • 5.5.1. Executing an ADO.NET Statement
    • 5.5.2. Executing a JDBC Statement
  • 5.6. Retrieving Data
    • 5.6.1. Retrieving Data Using ADO.NET
    • 5.6.2. Retrieving Data Using JDBC
      • 5.6.2.1. Use the following steps to execute query statements in JDBC:
  • 5.7. Bound Parameters
    • 5.7.1. ADO.NET Bound Parameters
      • 5.7.1.1. Use the following steps to execute statements with bound parameters in ADONET:
    • 5.7.2. Binding Parameters with JDBC
      • 5.7.2.1. Use the following steps to execute statements with bound parameters in JDBC:
  • 5.8. Error Handling
    • 5.8.1. Error Handling in ADO.NET
    • 5.8.2. Error Handling in JDBC
  • 5.9. Examples
    • 5.9.1. ADO.NET Example
    • 5.9.2. JDBC Example
• A. Sybase Adaptive Server
  • A.1. Sybase Adaptive Server Datatypes
  • A.2. Sybase Adaptive Server SQL Statements
  • A.3. Sybase Adaptive Server SQL Functions
  • A.4. Sybase Adaptive Server Keywords
• B. Shared and Platform-Specific Keywords
• About the Author
• Colophon
• SPECIAL OFFER: Upgrade this ebook with OReilly
• Copyright

pokaż cały spis treści

ukryj recenzje