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

4.6 avg rating
( 5 ratings by Goodreads )
 
9780134578897: Effective SQL: 61 Specific Ways to Write Better SQL (Effective Software Development Series)
View all copies of this ISBN edition:
 
 

“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

"synopsis" may belong to another edition of this title.

From the Author:

We assembled a truly international team of leading database consultants to collect 61 tips to help you write better SQL no matter what system you're using.  John is originally from Texas, but makes his home in Paris, France.  Doug is a true Canadian, and Ben is from Texas.  Where possible, all the examples give you solutions in IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle Database and PostgreSQL.

From the Back Cover:

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 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 dat 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

"About this title" may belong to another edition of this title.

Buy New View Book
List Price: US$ 44.99
US$ 29.81

Convert currency

Shipping: FREE
From United Kingdom to U.S.A.

Destination, rates & speeds

Add to Basket

Other Popular Editions of the Same Title

9789352865086: Effective Sql: 61 Specific Ways To Write Better Sql

Featured Edition

ISBN 10:  9352865081 ISBN 13:  9789352865086
Publisher: PEARSON INDIA, 2017
Softcover

Top Search Results from the AbeBooks Marketplace

1.

John L. Viescas, Douglas Steele, Ben Clothier,
Published by Pearson Education (US), United States (2016)
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Paperback Quantity Available: 1
Seller:
Book Depository International
(London, United Kingdom)

Book Description Pearson Education (US), United States, 2016. Paperback. Condition: New. Language: English. Brand new Book. "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 CorporationEffective 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 modelsImplement indexes that improve query performanceHandle external data from sources you don't controlExtract and aggregate the information you need, as efficiently as possibleWrite more flexible subqueriesAnalyze and retrieve metadata using your database platform of choiceUse Cartesian Products and Tally Tables to solve problems you can't address with conventional JOINsModel hierarchical data: managing SQL's tradeoffs and shortcomings. Seller Inventory # AAK9780134578897

More information about this seller | Contact this seller

Buy New
US$ 29.81
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

2.

John L. Viescas, Douglas Steele, Ben Clothier,
Published by Pearson Education (US), United States (2016)
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Paperback Quantity Available: 1
Seller:
The Book Depository
(London, United Kingdom)

Book Description Pearson Education (US), United States, 2016. Paperback. Condition: New. Language: English. Brand new Book. "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 CorporationEffective 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 modelsImplement indexes that improve query performanceHandle external data from sources you don't controlExtract and aggregate the information you need, as efficiently as possibleWrite more flexible subqueriesAnalyze and retrieve metadata using your database platform of choiceUse Cartesian Products and Tally Tables to solve problems you can't address with conventional JOINsModel hierarchical data: managing SQL's tradeoffs and shortcomings. Seller Inventory # AAK9780134578897

More information about this seller | Contact this seller

Buy New
US$ 30.39
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

3.

Steele, Douglas J.; Viescas, John L. ; Clothier, Ben G.
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Quantity Available: 5
Seller:
GreatBookPrices
(Columbia, MD, U.S.A.)

Book Description Condition: New. Seller Inventory # 26073555-n

More information about this seller | Contact this seller

Buy New
US$ 29.72
Convert currency

Add to Basket

Shipping: US$ 2.64
Within U.S.A.
Destination, rates & speeds

4.

Viescas, John L.
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Quantity Available: 2
Seller:
Paperbackshop-US
(Wood Dale, IL, U.S.A.)

Book Description 2016. PAP. Condition: New. New Book. Shipped from UK within 10 to 14 business days. Established seller since 2000. Seller Inventory # PB-9780134578897

More information about this seller | Contact this seller

Buy New
US$ 28.38
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

5.

John L Viescas (author), Douglas Steele (author), Ben Clothier (author), Tom Wickerath (author)
Published by Pearson Education Heg USA 2016-12-20, Boston (2016)
ISBN 10: 0134578899 ISBN 13: 9780134578897
New paperback Quantity Available: 5
Seller:
Blackwell's
(Oxford, OX, United Kingdom)

Book Description Pearson Education Heg USA 2016-12-20, Boston, 2016. paperback. Condition: New. Seller Inventory # 9780134578897

More information about this seller | Contact this seller

Buy New
US$ 32.26
Convert currency

Add to Basket

Shipping: US$ 6.23
From United Kingdom to U.S.A.
Destination, rates & speeds

6.

Viescas, John^Steele, Douglas^Clothier, Ben^Wickerath, Tom
Published by Prentice Hall
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Quantity Available: 5
Seller:
INDOO
(Avenel, NJ, U.S.A.)

Book Description Prentice Hall. Condition: New. Brand New. Seller Inventory # 0134578899

More information about this seller | Contact this seller

Buy New
US$ 34.94
Convert currency

Add to Basket

Shipping: US$ 3.60
Within U.S.A.
Destination, rates & speeds

7.

Viescas, John L.
Published by Pearson Education (US) (2016)
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Quantity Available: 2
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)

Book Description Pearson Education (US), 2016. PAP. Condition: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Seller Inventory # PB-9780134578897

More information about this seller | Contact this seller

Buy New
US$ 28.61
Convert currency

Add to Basket

Shipping: US$ 11.45
From United Kingdom to U.S.A.
Destination, rates & speeds

8.

John L. Viescas; Douglas J. Steele; Ben G. Clothier
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Quantity Available: 1
Seller:
Speedy Hen LLC
(Sunrise, FL, U.S.A.)

Book Description Condition: New. Bookseller Inventory # ST0134578899. Seller Inventory # ST0134578899

More information about this seller | Contact this seller

Buy New
US$ 40.85
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

9.

John L. Viescas
Published by Pearson Education (US)
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Paperback / softback Quantity Available: 15
Seller:
THE SAINT BOOKSTORE
(Southport, United Kingdom)

Book Description Pearson Education (US). Paperback / softback. Condition: New. New copy - Usually dispatched within 2 working days. Seller Inventory # B9780134578897

More information about this seller | Contact this seller

Buy New
US$ 32.73
Convert currency

Add to Basket

Shipping: US$ 8.83
From United Kingdom to U.S.A.
Destination, rates & speeds

10.

Viescas, John L., Steele, Douglas J., Clothier, Ben G.
Published by Addison-Wesley Professional (2016)
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Softcover First Edition Quantity Available: 15

Book Description Addison-Wesley Professional, 2016. Condition: New. Num Pages: 352 pages. BIC Classification: UMT. Category: (P) Professional & Vocational. Dimension: 179 x 230 x 17. Weight in Grams: 454. . 2016. 1st Edition. Paperback. . . . . . Seller Inventory # V9780134578897

More information about this seller | Contact this seller

Buy New
US$ 44.00
Convert currency

Add to Basket

Shipping: FREE
From Ireland to U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book