Share
Create bookmark
SQL Pocket Guide
Notes
Please login to add notes
- Contents
-
+
SQL Pocket Guide
- + Introduction
- Analytic Functions
- + CASE Expressions
- + Datatypes
-
+
Dataype Conversion
- Standard CAST Function
- Standard EXTRACT Function
- Datetime Conversions (Oracle)
- Numeric Conversions (Oracle)
- Datetime Conversions (DB2)
- Numeric Conversions (DB2)
- + Datetime Conversions (SQL Server)
- Numeric Conversions (SQL Server)
- + Datetime Conversions (MySQL)
- Numeric Conversions (MySQL)
- Datetime Conversions (PostgreSQL)
- Numeric Conversions (PostgreSQL)
- + Deleting Data
- + Functions
-
+
Grouping and Summarizing
-
+
Hierarchical Queries
- Indexes, Creating
- Indexes, Removing
-
+
Inserting Data
-
+
Joining Tables
- + Literals
- Merging Data (Oracle, DB2)
- + Nulls
- OLAP Functions
- + Predicates
- Recursive Queries
- + Regular Expressions
-
+
Selecting Data
- + Subqueries
- + Tables, Creating
- + Tables, Modifying
- Tables, Removing
-
+
Transaction Management
-
+
Union Queries
- + Updating Data
-
+
Window Functions
- Defining a Summary Window (Oracle, DB2, SQL Server)
- Ordering and Ranking Within a Window (Oracle, DB2, SQL Server)
- Comparing Values Across Rows (Oracle)
- Summarizing over a Moving Window (Oracle, DB2)
- Window Function Syntax (Oracle)
- Window Function Syntax (DB2)
- Window Function Evaluation and Placement
- Index
SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.
Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:
Oracle Database 10g, Release 2 (including the free Oracle Database 10g Express Edition (XE))
Microsoft SQL Server 2005
MySQL 5
IBM DB2 8.2
PostreSQL 8.1 database
Test the closed alpha on paperc.com
Book Details
Authors
Categories
Computers > Programming Languages > SQL
Publishers
Publication year : 2008
License: All rights reserved ©
Times read: 631
