{"product_id":"fuzzy-data-matching-with-sql-enhancing-data-quality-and-query-performance-paperback","title":"Fuzzy Data Matching with SQL: Enhancing Data Quality and Query Performance - Paperback","description":"\u003cp\u003eby \u003cb\u003eJim Lehmer\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eIf 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. \u003c\/p\u003e\u003cp\u003e 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. \u003c\/p\u003e\u003cp\u003e Full of real-world techniques, the examples in the book contain working code. You'll learn how to: \u003c\/p\u003e\u003cul\u003e \u003cli\u003eIdentity and remove duplicates in two different datasets using SQL \u003c\/li\u003e\n\u003cli\u003eRegularize data and achieve data quality using SQL \u003c\/li\u003e\n\u003cli\u003eExtract data from XML and JSON \u003c\/li\u003e\n\u003cli\u003eGenerate SQL using SQL to increase your productivity \u003c\/li\u003e\n\u003cli\u003ePrepare datasets for import, merging, and better analysis using SQL \u003c\/li\u003e\n\u003cli\u003eReport results using SQL \u003c\/li\u003e\n\u003cli\u003eApply data quality and ETL approaches to finding similarities and differences between various expressions of the same data \u003c\/li\u003e\n\u003c\/ul\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 282\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.7 x 9.2 x 7 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e November 07, 2023\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42691569614911,"sku":"9781098152277","price":59.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0105\/8226\/1823\/files\/c02589384505c9378668eb2a43e060b3.webp?v=1764992511","url":"https:\/\/dhl-adrianne.myshopify.com\/products\/fuzzy-data-matching-with-sql-enhancing-data-quality-and-query-performance-paperback","provider":"BBB","version":"1.0","type":"link"}