Querying Databricks with Spark SQL: Leverage SQL to query and analyze Big Data for insights by Adam AspinRequirements: .ePUB reader, 37.4 MBOverview: A practical guide to using Spark SQL to perform complex queries on your Databricks data. Databricks stands out as a widely embraced platform dedicated to the creation of data lakes. Within its framework, […]
Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL by Baji Shaik, Dinesh Kumar ChemuduruRequirements: .ePUB, .PDF, .MOBI/.AZW reader, 10 MBOverview: Learn the fundamentals of PL/PGSQL, the programming language of PostgreSQL which is most robust Open Source Relational Database. This book provides practical insights into developing database code objects such as functions and […]
Fuzzy Data Matching with SQL: Enhancing Data Quality and Query Performance by Jim LehmerRequirements: .ePUB reader, 7 MBOverview: If you were handed two different but related sets of data, what tools would you use to find the matches? What if all you had was SQL SELECT access to a database? In this practical book, author […]
Learning Snowflake SQL and Scripting: Generate, Retrieve, and Automate Snowflake Data by Alan BeaulieuRequirements: .ePUB reader, 5.71 MBOverview: To help you on the path to becoming a Snowflake pro, this concise yet comprehensive guide reviews fundamentals and best practices for Snowflake’s SQL and Scripting languages. Developers and data professionals will learn how to generate, modify, […]
SQL Server Analytical Toolkit: Using Windowing, Analytical, Ranking, and Aggregate Functions for Data and Statistical Analysis by Angelo BobakRequirements: .PDF reader, 95 mbOverview: Learn window function foundational concepts through a cookbook-style approach, beginning with an introduction to the OVER() clause, its various configurations in terms of how partitions and window frames are created, and how […]