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
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: $34.39 | Publisher: Microsoft Press | Release: 2022
CockroachDB: The Definitive Guide
by Guy Harrison, Jesse Seldess, Ben Darnell
Get the lowdown on CockroachDB, the distributed SQL database built to handle the demands of today's data-driven cloud applications. In this hands-on guide, software developers, architects, and DevOps/SRE teams will learn how to use CockroachDB to create applications that scale elastically and provide seamless delivery for end users while remaining indestructible. Teams will also learn how to migrate ex...
Price: $51.06 | Publisher: O'Reilly Media | Release: 2022
Snowflake: The Definitive Guide
by Joyce Kay Avila
Snowflake's ability to eliminate data silos and run workloads from a single platform creates opportunities to democratize data analytics, allowing users at all levels within an organization to make data-driven decisions. Whether you're an IT professional working in data warehousing or data science, a business analyst or technical manager, or an aspiring data professional wanting to get more hands-...
Price: $58.90 | Publisher: O'Reilly Media | Release: 2022
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: $24.00 | Publisher: Wiley | Release: 2022
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
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