Fuzzy Data Matching with SQL by Jim Lehmer (Paperback Book)

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 Jim Lehmer provides best practices, techniques, and tricks to help you import, clean, match, score, and think about heterogeneous data using SQL. DBAs, programmers, business analysts, and data scientists will learn how to identify and remove duplicates, parse strings, extract data from XML and JSON, generate SQL using SQL, regularize data and prepare datasets, and apply data quality and ETL approaches for finding the similarities and differences between various expressions of the same data. Full of real-world techniques, the examples in the book contain working code. You\'ll learn how to:Identity Fuzzy Data Matching with SQL Enhancing Data Quality and Query Performance Free UK delivery on this item.

This brand new item is available with free UK delivery using Royal Mail tracked services.

Please note: the price advertised is as low as we can go — we do not accept or respond to offers. We\'re also unable to accommodate special requests added in your order notes at checkout. If you have a specific request or requirement, please contact us before ordering so we can check if it\'s something we can help with.

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 Jim Lehmer provides best practices, techniques, and tricks to help you import, clean, match, score, and think about heterogeneous data using SQL. DBAs, programmers, business analysts, and data scientists will learn how to identify and remove duplicates, parse strings, extract data from XML and JSON, generate SQL using SQL, regularize data and prepare datasets, and apply data quality and ETL approaches for finding the similarities and differences between various expressions of the same data. Full of real-world techniques, the examples in the book contain working code. You\'ll learn how to:Identity and remove duplicates in two different datasets using SQLRegularize data and achieve data quality using SQLExtract data from XML and JSONGenerate SQL using SQL to increase your productivityPrepare datasets for import, merging, and better analysis using SQLReport results using SQLApply data quality and ETL approaches to finding similarities and differences between various expressions of the same data

Product Details ISBN 9781098152277 Format Paperback Author Jim Lehmer Publisher O\'Reilly Media Number of Pages 250 Length 17.800 cm Width 23.600 cm Depth 1.900 cm Weight 0.5020 kg