Poetry Madness
 
 

Recently Viewed clear list


Original Essays | April 11, 2014

Paul Laudiero: IMG Shit Rough Draft



I was sitting in a British and Irish romantic drama class my last semester in college when the idea for Shit Rough Drafts hit me. I was working... Continue »
  1. $9.07 Sale Trade Paper add to wish list

spacer
Qualifying orders ship free.
$29.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Computer Languages- SQL

SQL Hacks

by

SQL Hacks Cover

 

Synopses & Reviews

Publisher Comments:

Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks — unique tips and tools — that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to:

  • Wrangle data in the most efficient way possible
  • Aggregate and organize your data for meaningful and accurate reporting
  • Make the most of subqueries, joins, and unions
  • Stay on top of the performance of your queries and the server that runs them
  • Avoid common SQL security pitfalls, including the dreaded SQL injection attack

Let SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you.

Book News Annotation:

Two teachers at Napier University in Scotland provide 100 tips for handling text and numbers in SQL databases, organizing data, improving query performance, minimizing delays, and processing report data. Most of the code examples use the MySQL command line utility and note variations for SQL Server, Oracle, PostgreSQL, and Access. Annotation ©2007 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

This new book in the critically acclaimed "Hacks" series provides 100 unique tips and tools that push the limits of traditional SQL, from fun things like solving crosswords with SQL to complex data manipulation.

Synopsis:

SQL is the cornerstone of database programming and this book provides 100 hacks that push the limits of traditional SQL, from fun stuff like solving crosswords with SQL to hardcore data wrangling. Written by the author of A Gentle Introduction to SQL (sqlzoo.net), it covers the most popular databases: Access, SQL Server, Oracle, MySQL, and PostgreSQL.

About the Author

Andrew Cumming is the Zoo Keeper at http://sqlzoo.net . He keeps a collection of tame SQL engines and presents these to the public. He cares for these beasts, protecting them from the abuse inflicted by SQL learners, and protecting SQL learners from the injuries that the wild engines can inflict. But mostly he shovels manure out the cages and hoses them down every now and then. Andrew also teaches at Napier University in Edinburgh, Scotland.

Dr. Gordon Russell is a Computing lecturer in Napier University, Scotland. He teaches databases, Linux, and networking. He also builds educational websites, concentrating on technology-driven online learning environments. These include db.grussell.org, whose claim-to-fame is its automatic checking of SQL assessments, and http://linuxzoo.net, which offers online users root free access to Linux servers. But without database technology to support these sites, even he would be lost.

Table of Contents

CreditsPrefaceChapter 1: SQL FundamentalsChapter 2: Joins, Unions, and ViewsChapter 3: Text HandlingChapter 4: Date HandlingChapter 5: Number CrunchingChapter 6: Online ApplicationsChapter 7: Organizing DataChapter 8: Storing Small Amounts of DataChapter 9: Locking and PerformanceChapter 10: ReportingChapter 11: Users and AdministrationChapter 12: Wider AccessColophon

Product Details

ISBN:
9780596527990
Author:
Cumming, Andrew
Publisher:
O'Reilly Media
Author:
Russell, Gordon
Subject:
Programming Languages - SQL
Subject:
Programming languages (electronic computers)
Subject:
Sql (computer program language)
Subject:
Database Management - Database Mining
Subject:
Database Management - Data Warehousing
Subject:
Computer Languages-SQL
Subject:
MySQL;Oracle;PostgreSQL;SQL;SQL Server
Edition Description:
Trade Paper
Publication Date:
20061131
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
412
Dimensions:
9 x 6 x 1 in 1.2 lb

Other books you might like

  1. Forbidden Lego: Build the Models... Used Trade Paper $17.50
  2. Your Brain: The Missing Manual Used Trade Paper $13.00
  3. Head First Software Development Used Trade Paper $25.00
  4. UML 2.0 Pocket Reference (Pocket... Used Trade Paper $6.00
  5. C++ Pocket Reference Used Trade Paper $6.00
  6. Perl Pocket Reference 4TH Edition Used Trade Paper $5.50

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

SQL Hacks New Trade Paper
0 stars - 0 reviews
$29.99 In Stock
Product details 412 pages O'Reilly Media - English 9780596527990 Reviews:
"Synopsis" by ,
This new book in the critically acclaimed "Hacks" series provides 100 unique tips and tools that push the limits of traditional SQL, from fun things like solving crosswords with SQL to complex data manipulation.
"Synopsis" by , SQL is the cornerstone of database programming and this book provides 100 hacks that push the limits of traditional SQL, from fun stuff like solving crosswords with SQL to hardcore data wrangling. Written by the author of A Gentle Introduction to SQL (sqlzoo.net), it covers the most popular databases: Access, SQL Server, Oracle, MySQL, and PostgreSQL.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.