
SQL in a Nutshell
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
New editions

Additional editions

Content
- Intro
- Table of Contents
- 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 Hunt's Acknowledgments
- Daniel Kline's Acknowledgments
- Kevin E. Kline's Acknowledgments
- SQL History and Implementations
- The Relational Model and ANSI SQL
- Codd's Rules for Relational Database Systems
- Data structures (rules 1, 2, and 8)
- NULLS (rule 3)
- Metadata (rules 4 and 10)
- The language (rules 5 and 11)
- Views (rule 6)
- Set operations (rules 7 and 12)
- Codd's Rules in Action: Simple SELECT Examples
- History of the SQL Standard
- What's New in SQL2003
- Levels of Conformance
- Supplemental Features Packages in the SQL2003 Standard
- SQL2003 Statement Classes
- SQL Dialects
- Foundational Concepts
- Database Platforms Described in This Book
- Categories of Syntax
- Identifiers
- Naming conventions
- Identifier rules
- Literals
- Operators
- Arithmetic operators
- Assignment operators
- Bitwise operators
- Comparison operators
- Logical operators
- Unary operators
- Operator precedence
- System delimiters and operators
- Keywords and Reserved Words
- SQL2003 and Platform-Specific Datatypes
- DB2 Datatypes
- MySQL Datatypes
- Oracle Datatypes
- PostgreSQL Datatypes
- SQL Server Datatypes
- Constraints
- Scope
- Syntax
- PRIMARY KEY Constraints
- FOREIGN KEY Constraints
- UNIQUE Constraints
- CHECK Constraints
- SQL Statement Command Reference
- How to Use This Chapter
- SQL Platform Support
- 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
- SQL Functions
- Types of Functions
- Deterministic and Nondeterministic Functions
- Aggregate and Scalar Functions
- Window Functions
- 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
- ANSI SQL Window Functions
- SQL2003's Window Syntax
- Oracle's Window Syntax
- DB2's Window Syntax
- Partitioning
- Ordering
- Grouping or Windowing
- List of Window Functions
- CUME_DIST( )
- DENSE_RANK( )
- RANK( )
- PERCENT_RANK
- ROW_NUMBER
- ANSI SQL Scalar Functions
- Built-in Scalar Functions
- CASE and CAST Functions
- CASE
- CAST
- Numeric Scalar Functions
- ABS
- BIT_LENGTH, CHAR_LENGTH, and OCTET_LENGTH
- CEIL
- EXP
- EXTRACT
- FLOOR
- LN
- MOD
- POSITION
- POWER
- SQRT
- WIDTH_BUCKET
- String Functions and Operators
- Concatenation Operator
- CONVERT and TRANSLATE
- LOWER and UPPER
- OVERLAY
- SUBSTRING
- TRIM
- Platform-Specific Extensions
- DB2-Supported Extensions
- MySQL-Supported Functions
- Oracle-Supported Functions
- PostgreSQL-Supported Functions
- SQL Server-Supported Functions
- Database Programming
- Database Programming Overview
- Opening a Database Connection
- Opening an ADO.NET Database Connection
- Opening a JDBC Database Connection
- DB2
- MySQL
- PostgreSQL
- Oracle
- SQL Server
- Closing a Database Connection
- Closing an ADO.NET Database Connection
- Closing a JDBC Database Connection
- Managing Transactions
- Beginning a Transaction
- Beginning an ADO.NET transaction
- Beginning a JDBC transaction
- Committing a Transaction
- Committing an ADO.NET transaction
- Committing a JDBC transaction
- Rolling Back a Transaction
- Rolling back an ADO.NET transaction
- Rolling back a JDBC transaction
- Executing Statements
- Executing an ADO.NET Statement
- Executing a JDBC Statement
- Retrieving Data
- Retrieving Data Using ADO.NET
- Retrieving Data Using JDBC
- Use the following steps to execute query statements in JDBC:
- Bound Parameters
- ADO.NET Bound Parameters
- Use the following steps to execute statements with bound parameters in ADONET:
- Binding Parameters with JDBC
- Use the following steps to execute statements with bound parameters in JDBC:
- Error Handling
- Error Handling in ADO.NET
- Error Handling in JDBC
- Examples
- ADO.NET Example
- JDBC Example
- Sybase Adaptive Server
- Sybase Adaptive Server Datatypes
- Sybase Adaptive Server SQL Statements
- Sybase Adaptive Server SQL Functions
- Sybase Adaptive Server Keywords
- Shared and Platform-Specific Keywords
- Index
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.