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.