Pre-Owned Effective Software Development: Effective SQL: 61 Specific Ways to Write Better SQL (Paperback)

Pre-Owned Effective Software Development: Effective SQL: 61 Specific Ways to Write Better SQL (Paperback)

(No ratings yet)
Condition
Pre-Owned: Good
Seller Rating
5 out of 5 stars

Key item features

Effective Software Development: Effective SQL: 61 Specific Ways to Write Better SQL (Paperback)

Specs

Publication date, December, 2016Author, John Viescas; Douglas Steele; Ben ClothierBook format, PaperbackGenre, Computing & InternetPages, 352Age group, Adult

About this item

Product details

"Given the authors' reputations, I expected to be impressed. I was blown away! . . . Most SQL books sit on my shelf. This one will live on my desk."
-Roger Carlson, Microsoft Access MVP (2006-2015)
"Rather than stumble around reinventing wheels or catching glimpses of the proper approaches, do yourself a favor: Buy this book."
--Dave Stokes, MySQL Community Manager, Oracle Corporation
Effective SQL brings together practical solutions and insights so you can solve complex problems with SQL and design databases that simplify data management in the future. It's the only modern book that brings together advanced best practices and realistic example code for all of these versions of SQL: IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL.
Drawing on their immense experience as world-class database consultants and instructors, the authors identify 61 proven approaches to writing better SQL. Wherever SQL versions vary, the authors illuminate the key nuances, so you can get the most out of whatever version you prefer. This full-color guide provides clear, practical explanations; expert tips; and plenty of usable code. Going far beyond mere syntax, it addresses issues ranging from optimizing database designs to managing hierarchies and metadata. If you already know SQL's basics, this guide will help you become a world-class SQL problem-solver.
  • Craft better logical data models, and fix flawed models
  • Implement indexes that improve query performance
  • Handle external data from sources you don't control
  • Extract and aggregate the information you need, as efficiently as possible
  • Write more flexible subqueries
  • Analyze and retrieve metadata using your database platform of choice
  • Use Cartesian Products and Tally Tables to solve problems you can't address with conventional JOINs
  • Model hierarchical data: managing SQL's tradeoffs and shortcomings
Effective Software Development: Effective SQL: 61 Specific Ways to Write Better SQL (Paperback)
info:
We aim to show you accurate product information. Manufacturers, suppliers and others provide what you see here, and we have not verified it.  

Specifications

Publication date

December, 2016

Author

John Viescas; Douglas Steele; Ben Clothier

Book format

Paperback

Genre

Computing & Internet

Warranty

Warranty information

Please be aware that the warranty terms on items offered for sale by third party Marketplace sellers may differ from those displayed in this section (if any). To confirm warranty terms on an item offered for sale by a third party Marketplace seller, please use the 'Contact seller' feature on the third party Marketplace seller's information page and request the item's warranty terms prior to purchase.

Customer ratings & reviews

 

Resold at Walmart

0 out of 5 stars
0 ratings|0 reviews
This item does not have any reviews yet
Current price is $36.94
Price when purchased online
  • Free shipping
  • Free Holiday returns until Jan 31
Out of stock
$36.94

How do you want your item?

How do you want your item?
Ships to
Arrives between Nov 30 - Dec 4
|
Sold and shipped by HPB Red
5 out of 5 stars
5 stars out of 5, based on 3 seller reviews(5.0)
Extended holiday returns
Free Holiday returns until Jan 31