- Shopping Bag ( 0 items )
From Barnes & Noble
The Barnes & Noble ReviewJoe Celko’s SQL for Smarties turns experienced SQL programmers into great SQL programmers. Now he’s updated this classic to reflect today’s state-of-the-art in SQL coding. That means new examples, many drawn from SQL-99 features that were still on the drawing board last time. It also means more advanced query techniques, plus a whole new discussion of schema design. What hasn’t changed, though, is just as important: Celko’s relentlessly informed and practical approach, and the breadth of his coverage.
Do you want to design or normalize databases more effectively? Make better use of data types, tables, CASE expressions, predicates, SELECT, VIEW, partitioning data, grouping operations, aggregate functions? Handle gaps, sequences, series? OLAP, transactions, currency control, optimization? Celko offers advanced techniques for all that, and plenty more. Get this book, and get a stack of Post-it Notes: you’ll use ’em. Bill Camarda, from the November 2005 Read Only
Overview
"...provides useful tips and tricks for advanced SQL programming to help users work around system deficiencies... addresses real and common programming problems and offers new and creative solutions."
...