Read Anywhere and on Any Device!

Subscribe to Read | $0.00

Join today and start reading your favorite books for Free!

Create Free Account

SQL Performance Explained

Markus Winand

4.42/5 (309 ratings)

Read Now Download Now

SQL Performance Explained helps developers to improve database performance. The focus is on SQL-it covers all major SQL databases without getting lost in the details of any one specific product. Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate. Topics covered include: Using multi-column indexes; Correctly applying SQL functions; Efficient use of LIKE queries; Optimizing join operations; Clustering data to improve performance; Pipelined execution of ORDER BY and GROUP BY; Getting the best performance for pagination queries; Understanding the scalability of databases. Its systematic structure makes SQL Performance Explained both a textbook and a reference manual that should be on every developer's bookshelf.

Format:: Paperback

Pages:: 204 pages

Publication:: 2012

Publisher:: Markus Winand (2012)

Edition:

Language:: eng

ISBN10:: 3950307826

ISBN13:: 9783950307825

kindle Asin:: B0CLK69384

SQL Performance Explained

Markus Winand

4.42/5 (309 ratings)

Read Download

SQL Performance Explained helps developers to improve database performance. The focus is on SQL-it covers all major SQL databases without getting lost in the details of any one specific product. Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate. Topics covered include: Using multi-column indexes; Correctly applying SQL functions; Efficient use of LIKE queries; Optimizing join operations; Clustering data to improve performance; Pipelined execution of ORDER BY and GROUP BY; Getting the best performance for pagination queries; Understanding the scalability of databases. Its systematic structure makes SQL Performance Explained both a textbook and a reference manual that should be on every developer's bookshelf.

Format:: Paperback

Pages:: 204 pages

Publication:: 2012

Publisher:: Markus Winand (2012)

Edition:

Language:: eng

ISBN10:: 3950307826

ISBN13:: 9783950307825

kindle Asin:: B0CLK69384

More Books

Operating Systems: Three Easy Pieces

Remzi H. Arpaci-Dusseau

Clean Code: A Handbook of Agile Software Craftsmanship

Robert C. Martin

Designing Data-Intensive Applications

Martin Kleppmann

Fundamentals of Software Architecture: An Engineering Approach

Mark Richards

The Pragmatic Programmer: From Journeyman to Master

Dave Thomas

Spark: The Definitive Guide: Big Data Processing Made Simple

Bill Chambers

Refactoring UI

Adam Wathan

Practical Object Oriented Design in Ruby

Sandi Metz

Tidy First?: A Personal Exercise in Empirical Software Design

Kent Beck

Learning Spark: Lightning-Fast Data Analytics

Jules S. Damji

Building Microservices: Designing Fine-Grained Systems

Sam Newman

The Phoenix Project: A Novel About IT, DevOps, and Helping Your Business Win

Gene Kim