SQL Books



Bookstore > Books > SQL

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

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 in a Nutshell, 4th Edition

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

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

Practical SQL, 2nd Edition

Practical SQL, 2nd Edition

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

Microsoft Excel VBA and Macros

Microsoft Excel VBA and Macros

by Bill Jelen, Tracy Syrstad

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you wont find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere;...

Price:  $43.95  |  Publisher:  Microsoft Press  |  Release:  2022

Practical Go

Practical Go

by Amit Saha

Google announced the Go programming language to the public in 2009, with the version 1.0 release announced in 2012. Since its announcement to the community, and the compatibility promise of the 1.0 release, the Go language has been used to write scalable and high-impact software programs ranging from command-line applications and critical infrastructure tools to large-scale distributed systems. It's sp...

Price:  $26.49  |  Publisher:  Wiley  |  Release:  2022

Modern Data Engineering with Apache Spark

Modern Data Engineering with Apache Spark

by Scott Haines

Leverage Apache Spark within a modern data engineering ecosystem. This hands-on guide will teach you how to write fully functional applications, follow industry best practices, and learn the rationale behind these decisions. With Apache Spark as the foundation, you will follow a step-by-step journey beginning with the basics of data ingestion, processing, and transformation, and ending up with an entire loc...

Price:  $46.38  |  Publisher:  Apress  |  Release:  2022

Introducing Blockchain with Java

Introducing Blockchain with Java

by Spiro Buzharovski

Create your own crypto currency by implementing blockchain technology using Java. This step-by-step guide will teach you how to create a user interface using Java FX and implement SQLite DB using JDBC Driver for the blockchain.Introducing Blockchain with Java includes numerous exercises and test questions to help you solidify what you have learned as you progress through the book, and provides ideas on expa...

Price:  $27.50  |  Publisher:  Apress  |  Release:  2022

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

Subscribe to Newsletter

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