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

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

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.

€ 30.79

In stock