- Shopping Bag ( 0 items )
From Barnes & NobleThe Barnes & Noble Review
Joe 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