Fuzzy Data Matching with SQL: Enhancing Data Quality and Query Performance by Ji

Description: Fuzzy Data Matching with SQL by Jim Lehmer 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. Full of real-world techniques, the examples in the book contain working code. FORMAT Paperback CONDITION Brand New Publisher Description 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. Youll learn how to: Identity and remove duplicates in two different datasets using SQL Regularize data and achieve data quality using SQL Extract data from XML and JSON Generate SQL using SQL to increase your productivity Prepare datasets for import, merging, and better analysis using SQL Report results using SQL Apply data quality and ETL approaches to finding similarities and differences between various expressions of the same data" Author Biography James Lehmer has been "in computers" for over three decades in various software development roles - programmer, systems programmer, software engineer, team lead, and software architect. He has worked on a variety of operating systems with a number of programming languages. James currently works in a Windows shop coding primarily in C#, but with his background in cross-platform development, he often gets tapped to deal with any *IX boxes that enter his environment. Details ISBN1098152271 Author Jim Lehmer Pages 250 Publisher OReilly Media Year 2023 ISBN-13 9781098152277 Format Paperback Imprint OReilly Media Subtitle Enhancing Data Quality and Query Performance Place of Publication Sebastopol Country of Publication United States ISBN-10 1098152271 UK Release Date 2023-10-31 Publication Date 2023-10-13 US Release Date 2023-10-13 We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:151494687;

Price: 106.62 AUD

Location: Melbourne

End Time: 2024-11-17T09:02:31.000Z

Shipping Cost: 0 AUD