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.