Book description
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 (includingthe free Oracle Database 10g Express Edition (XE))
- Microsoft SQL Server 2005
- MySQL 5
- IBM DB2 8.2
- PostreSQL 8.1 database
Publisher resources
Table of contents
- SQL Pocket Guide, 2nd Edition
- A Note Regarding Supplemental Files
- Praise for SQL Pocket Guide
-
1. SQL Pocket Guide
- 1.1. Introduction
- 1.2. Analytic Functions
- 1.3. CASE Expressions
- 1.4. Datatypes
-
1.5. Dataype Conversion
- 1.5.1. Standard CAST Function
- 1.5.2. Standard EXTRACT Function
- 1.5.3. Datetime Conversions (Oracle)
- 1.5.4. Numeric Conversions (Oracle)
- 1.5.5. Datetime Conversions (DB2)
- 1.5.6. Numeric Conversions (DB2)
- 1.5.7. Datetime Conversions (SQL Server)
- 1.5.8. Numeric Conversions (SQL Server)
- 1.5.9. Datetime Conversions (MySQL)
- 1.5.10. Numeric Conversions (MySQL)
- 1.5.11. Datetime Conversions (PostgreSQL)
- 1.5.12. Numeric Conversions (PostgreSQL)
- 1.6. Deleting Data
-
1.7. Functions
- 1.7.1. Datetime Functions (Oracle)
- 1.7.2. Datetime Functions (DB2)
- 1.7.3. Datetime Functions (SQL Server)
- 1.7.4. Datetime Functions (MySQL)
- 1.7.5. Datetime Functions (PostgreSQL)
- 1.7.6. Numeric and Math Functions (All Platforms)
- 1.7.7. Trigonometric Functions (All Platforms)
- 1.7.8. String Functions
- 1.7.9. GREATEST and LEAST (Oracle, PostgreSQL)
- 1.8. Grouping and Summarizing
-
1.9. Hierarchical Queries
- 1.9.1. Recursive WITH (SQL Server, DB2)
-
1.9.2. CONNECT BY (Oracle)
- 1.9.2.1. CONNECT BY, START WITH, and PRIOR (Oracle)
- 1.9.2.2. Creative CONNECT BY (Oracle)
- 1.9.2.3. WHERE clauses with CONNECT BY (Oracle)
- 1.9.2.4. Joins with CONNECT BY (Oracle)
- 1.9.2.5. Sorting CONNECT BY results (Oracle)
- 1.9.2.6. Loops in hierarchical data (Oracle)
- 1.9.2.7. CONNECT BY functions and operators (Oracle)
- 1.10. Indexes, Creating
- 1.11. Indexes, Removing
- 1.12. Inserting Data
- 1.13. Joining Tables
- 1.14. Literals
- 1.15. Merging Data (Oracle, DB2)
- 1.16. Nulls
- 1.17. OLAP Functions
- 1.18. Predicates
- 1.19. Recursive Queries
- 1.20. Regular Expressions
- 1.21. Selecting Data
- 1.22. Subqueries
- 1.23. Tables, Creating
- 1.24. Tables, Modifying
- 1.25. Tables, Removing
- 1.26. Transaction Management
- 1.27. Union Queries
- 1.28. Updating Data
-
1.29. Window Functions
- 1.29.1. Defining a Summary Window (Oracle, DB2, SQL Server)
- 1.29.2. Ordering and Ranking Within a Window (Oracle, DB2, SQL Server)
- 1.29.3. Comparing Values Across Rows (Oracle)
- 1.29.4. Summarizing over a Moving Window (Oracle, DB2)
- 1.29.5. Window Function Syntax (Oracle)
- 1.29.6. Window Function Syntax (DB2)
- 1.29.7. Window Function Evaluation and Placement
- About the Author
- Copyright
Product information
- Title: SQL Pocket Guide, 2nd Edition
- Author(s):
- Release date: April 2006
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596526887
You might also like
book
SQL Pocket Guide, 3rd Edition
If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular …
book
SQL Pocket Guide, 4th Edition
If you use SQL in your day-to-day work as a data analyst, data scientist, or data …
book
SQL Cookbook, 2nd Edition
You may know SQL basics, but are you taking advantage of its expressive power? This second …
book
SQL in a Nutshell, 4th Edition
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL …