SQL cookbook / Anthony Molinaro.

Format:

Book

Author/Creator:

Molinaro, Anthony.

Language:

English

Subjects (All):

Database management.

SQL (Computer program language).

Physical Description:

1 online resource (804 p.)

Edition:

1st edition

Place of Publication:

Sebastopol, California : O'Reilly, 2006.

Language Note:

English

System Details:

text file

Summary:

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level. Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienc

Contents:

Retrieving records

Sorting query results

Working with multiple tables

Inserting, updating, deleting

Metadata queries

Working with strings

Working with numbers

Date arithmetic

Date manipulation

Working with ranges

Advanced searching

Reporting and warehousing

Hierarchical queries

Odds 'n' ends.

Notes:

"Covers SQL Server, PostgreSQL, Oracle, MySQL, and DB2"--Cover.

Includes index.

Description based on print version record.

ISBN:

9780596519094

0596519095

9780596555016

0596555016

OCLC:

609841324