by Andres Sacco
Use the popular Spring Data project for data access and persistence using various Java-based APIs such as JDBC, JPA, MongoDB, and more. This book shows how to easily incorporate data persistence and accessibility into your microservices, cloud-native applications, and monolithic enterprise applications. It also teaches you how to perform unit and performance testing of a component that accesses a database. ...
Price: $34.37 | Publisher: Apress | Release: 2023
SQL Server Advanced Troubleshooting and Performance Tuning
by Dmitri Korotkevitch
This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible.Author Dmitri Korotkevi...
Price: $56.95 | Publisher: O'Reilly Media | Release: 2022
Trino: The Definitive Guide, 2nd Edition
by Matt Fuller, Manfred Moser, Martin Traverso
Perform fast interactive analytics against different data sources using the Trino high-performance distributed SQL query engine. In the second edition of this practical guide, you'll learn how to conduct analytics on data where it lives, whether it's a data lake using Hive, a modern lakehouse with Iceberg or Delta Lake, a different system like Cassandra, Kafka, or SingleStore, or a relational data...
Price: $52.99 | Publisher: O'Reilly Media | Release: 2022
by Tayo Koleoso
Learn to use the jOOQ library to manage SQL database operations in Java and JVM applications. This book walks you through what JOOQ is, how to install and get started with it, and then gets you working with it.Practical examples and case studies demonstrate how jOOQ offers a more efficient and versatile alternative to Object-Relational Mapping frameworks like Hibernate and JPA, while providing a natural, na...
Price: $39.69 | Publisher: Apress | Release: 2022
Analytics Optimization with Columnstore Indexes in Microsoft SQL Server
by Edward Pollack
Meet the challenge of storing and accessing analytic data in SQL Server in a fast and performant manner. This book illustrates how columnstore indexes can provide an ideal solution for storing analytic data that leads to faster performing analytic queries and the ability to ask and answer business intelligence questions with alacrity. The book provides a complete walk through of columnstore indexing that en...
Price: $40.69 | Publisher: Apress | Release: 2022
SQL Server 2022 Query Performance Tuning, 6th Edition
by Grant Fritchey
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan corr...
Price: $44.99 | Publisher: Apress | Release: 2022
SQL in a Nutshell, 4th Edition
by Kevin Kline, Regina O. Obe, Leo S. Hsu
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and...
Price: $52.95 | Publisher: O'Reilly Media | Release: 2022
Learn dbatools in a Month of Lunches
by Chrissy LeMaire, Rob Sewell, Jess Pomfret, Claudio Silva
Written by a group of expert authors including dbatools creator Chrissy LeMaire, Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective - and efficient - than you ever thought possible. In twenty-eight lunchbreak lessons, you'll learn the most important use cases of dbatools and the favorite functions of its core developers. Stabilize and standardize your SQL serv...
Price: $49.99 | Publisher: Manning | Release: 2022
by Bill Karwin
SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend on antipatterns - -solutions that look right but become increasingly painful to work with as you uncover their hidden costs. Learn to identify and avoid many of these c...
Price: $47.95 | Publisher: The Pragmatic Programmers | Release: 2022
by Anthony DeBarros
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use the open-source database PostgreSQL and its companion pgAdmin interface, and the con...
Price: $30.94 | Publisher: No Starch Press | Release: 2022