SQL cookbook

SQL cookbook

by Molinaro, Anthony,, database developer

Type Book
Rate 0.0 /5

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…

Read More ↓
Details
Files
Reviews
Download

Title Statements

  • Full title :SQL cookbook / Anthony Molinaro.

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, experienced SQL developer Anthony Moli.

Read More ↓

Edition Statements

  • Publication Date:2005, ©2006.
  • Edition:1st ed

Publication Statements

  • Publisher(s):O'Reilly
  • Place of Publication:Beijing
  • Language:eng
  • Publication Date:2005, ©2006.

Notes

"Covers SQL Server, PostgreSQL, Oracle, MySQL, and DB2; Query solutions and techniques for database developers"--Cover

Includes index.

The Physical Object

  • Description:1 online resource (xxix, 595 pages) : : illustrations

Edition Identifiers

  • ISBN:9780596519094, 0596519095, 9780596555016, 0596555016
  • oclc:ocn772458692
  • LC Classification:QA76.73.S67
  • Dewey Decimal:005.133

Table of 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.

Read More ↓

Subjects

Bases de données -- Gestion COMPUTERS -- Programming Languages Database management Langages d'interrogation Query languages (Computer science) SQL (Computer program language) SQL (Langage de programmation)

Writers

Molinaro, Anthony,, database developer

Rate & Review

0.0/5
(0 people Voted)

No reviews yet. Be the first to rate this work.

Files & Downloads

No downloadable files are registered for this work yet.