Items related to Effective SQL: 61 Specific Ways to Write Better SQL...

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

  • 4.15 out of 5 stars
    27 ratings by Goodreads
 
9780134578897: Effective SQL: 61 Specific Ways to Write Better SQL (Effective Software Development Series)

Synopsis

“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.

  • PublisherAddison-Wesley Professional
  • Publication date2016
  • ISBN 10 0134578899
  • ISBN 13 9780134578897
  • BindingPaperback
  • LanguageEnglish
  • Edition number1
  • Number of pages352
  • Rating
    • 4.15 out of 5 stars
      27 ratings by Goodreads

Buy Used

Condition: Good
Connecting readers with great books...
View this item

US$ 3.75 shipping within U.S.A.

Destination, rates & speeds

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 Education, 2017
Softcover

Search results for Effective SQL: 61 Specific Ways to Write Better SQL...

Stock Image

Clothier, Ben,Steele, Douglas,Viescas, John
Published by Addison-Wesley Professional, 2016
ISBN 10: 0134578899 ISBN 13: 9780134578897
Used Paperback

Seller: HPB-Red, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_413519938

Contact seller

Buy Used

US$ 13.36
Convert currency
Shipping: US$ 3.75
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Viescas, John; Steele, Douglas; Clothier, Ben
Published by Addison-Wesley Professional, 2016
ISBN 10: 0134578899 ISBN 13: 9780134578897
Used Paperback

Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Good. No Jacket. Former library book; Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 1. Seller Inventory # G0134578899I3N10

Contact seller

Buy Used

US$ 17.35
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Viescas, John; Steele, Douglas; Clothier, Ben
Published by Addison-Wesley Professional, 2016
ISBN 10: 0134578899 ISBN 13: 9780134578897
Used Paperback

Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Very Good. No Jacket. Former library book; May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1. Seller Inventory # G0134578899I4N10

Contact seller

Buy Used

US$ 17.35
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Seller Image

Viescas, John; Steele, Douglas; Clothier, Ben
Published by Addison-Wesley Professional, 2016
ISBN 10: 0134578899 ISBN 13: 9780134578897
Used Softcover

Seller: Bay State Book Company, North Smithfield, RI, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: good. The book is in good condition with all pages and cover intact, including the dust jacket if originally issued. The spine may show light wear. Pages may contain some notes or highlighting, and there might be a "From the library of" label. Boxed set packaging, shrink wrap, or included media like CDs may be missing. Seller Inventory # BSM.JHS6

Contact seller

Buy Used

US$ 17.41
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Viescas, John L.
Published by Addison-Wesley Professional, 2016
ISBN 10: 0134578899 ISBN 13: 9780134578897
Used Softcover

Seller: SecondSale, Montgomery, IL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00084399651

Contact seller

Buy Used

US$ 17.46
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Viescas, John,Steele, Douglas,Clothier, Ben
Published by Addison-Wesley Professional, 2016
ISBN 10: 0134578899 ISBN 13: 9780134578897
Used paperback

Seller: PlumCircle, West Mifflin, PA, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

paperback. Condition: Very Good. Somehow I mis-spelled Biblio but I guess it works. Publisher overstock. May have remainder mark / minor shelfwear. 99% of orders arrive in 4-10 days. Discounted shipping on multiple books. Seller Inventory # mon0001304126

Contact seller

Buy Used

US$ 12.99
Convert currency
Shipping: US$ 4.49
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Steele, Douglas
Published by Addison-Wesley Professional, 2016
ISBN 10: 0134578899 ISBN 13: 9780134578897
Used Paperback

Seller: WorldofBooks, Goring-By-Sea, WS, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Seller Inventory # GOR013472019

Contact seller

Buy Used

US$ 39.66
Convert currency
Shipping: US$ 7.45
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Viescas, John
Published by Addison-Wesley Professional, 2016
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Paperback

Seller: Grumpys Fine Books, Tijeras, NM, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: new. Prompt service guaranteed. Seller Inventory # Clean0134578899

Contact seller

Buy New

US$ 61.88
Convert currency
Shipping: US$ 4.25
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Viescas, John; Steele, Douglas; Clothier, Ben
Published by Addison-Wesley Professional, 2016
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Softcover
Print on Demand

Seller: Majestic Books, Hounslow, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Print on Demand pp. 300. Seller Inventory # 371393298

Contact seller

Buy New

US$ 91.26
Convert currency
Shipping: US$ 8.65
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: 4 available

Add to basket

Stock Image

Viescas, John; Steele, Douglas; Clothier, Ben
Published by Addison-Wesley Professional, 2016
ISBN 10: 0134578899 ISBN 13: 9780134578897
New Softcover
Print on Demand

Seller: Biblios, Frankfurt am main, HESSE, Germany

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. PRINT ON DEMAND pp. 300. Seller Inventory # 18374652103

Contact seller

Buy New

US$ 98.43
Convert currency
Shipping: US$ 11.14
From Germany to U.S.A.
Destination, rates & speeds

Quantity: 4 available

Add to basket

There are 1 more copies of this book

View all search results for this book