SQL Books



Bookstore > Books > SQL

Geospatial Analysis with SQL

Geospatial Analysis with SQL

by Bonny P McClain

Geospatial analysis is industry agnostic and a powerful tool for answering location questions. Combined with the power of SQL, developers and analysts worldwide rely on database integration to solve real-world spatial problems. This book introduces skills to help you detect and quantify patterns in datasets through data exploration, visualization, data engineering, and the application of analysis and spatia...

Price:  $44.99  |  Publisher:  Packt Publishing  |  Release:  2023

Resilient Oracle PL/SQL

Resilient Oracle PL/SQL

by Stephen B. Morris

As legacy and other critical systems continue to migrate online, the need for continuous operation is imperative. Code has to handle data issues as well as hard external problems today, including outages of networks, storage systems, power, and ancillary systems. This practical guide provides system administrators, DevSecOps engineers, and cloud architects with a concise yet comprehensive overview on how to...

Price:  $79.99  |  Publisher:  O'Reilly Media  |  Release:  2023

Expert Performance Indexing in Azure SQL and SQL Server 2022, 4th Edition

Expert Performance Indexing in Azure SQL and SQL Server 2022, 4th Edition

by Edward Pollack, Jason Strate

Take a deep dive into perhaps the single most important facet of query performance - indexes - and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other updates to help you optimize query execut...

Price:  $54.54  |  Publisher:  Apress  |  Release:  2023

Spring 6 Recipes, 5th Edition

Spring 6 Recipes, 5th Edition

by Marten Deinum, Daniel Rubio, Josh Long

This in-depth Spring-based Java developer code reference has been updated and now solves many of your Spring Framework 6 problems using reusable, complete and real-world working code examples. Spring 6 Recipes (5th Edition) now includes Spring Native which speeds up your Java-based Spring Framework built enterprise, native cloud, web applications and microservices. It also has been updated to now include Sp...

Price:  $35.84  |  Publisher:  Apress  |  Release:  2023

Beginning Spring Data

Beginning Spring Data

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:  $33.99  |  Publisher:  Apress  |  Release:  2023

SQL Server Advanced Troubleshooting and Performance Tuning

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

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

Beginning jOOQ

Beginning jOOQ

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

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

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

Pages: 1, 2, 3 ... 43 | Next→

Subscribe to Newsletter

Be the first to know about new IT books, upcoming releases, exclusive offers and more.