Fuzzy Data Matching in SQL
Have you received two different but related datasets? What to do? What tools to use to find matches? And if all you have is access to a database via a SQL SELECT query? Jim Lemmer will introduce you to best... practices, techniques, and clever tricks that will help you import, clean, match, evaluate, and make sense of heterogeneous data using SQL.Database administrators, developers, business analysts, and data science specialists will learn how to identify and remove duplicates, parse strings, extract data from XML and JSON, order data, and improve data quality while performing ETL operations to find similarities and differences between different representations of the same data.Examples in the book include real cases and working code.
Author: Джим Лемер
Printhouse: piter
Series: O'Reilly Bestsellers
Age restrictions: 16+
Year of publication: 2024
ISBN: 9786010840379
Number of pages: 288
Size: 233х165х17 mm
Cover type: soft
Weight: 288 g
ID: 1679746
from € 38.94
