Fuzzy Data Matching with SQL

Fuzzy Data Matching with SQL

Default Title
Sale price  Rs. 1,530.00 Regular price  Rs. 1,700.00
Skip to product information
Fuzzy Data Matching with SQL

Fuzzy Data Matching with SQL

By: Jim Lehmer |  Publisher: Shroff/O'Reilly |  Year: 2023

ISBN: 9789355428301

MRP: Rs. 1,700.00

You Pay: Rs. 1,530.00

You save: Rs. 170.00 ( 10% )

MRP: Rs. 1,700.00

You Pay: Rs. 1,530.00

You save: Rs. 170.00 ( 10% )

Usually ships in 7-15 days

Reward points: 15 points

⚠️ Ships only in Bangladesh, Bhutan, India, Maldives, Nepal, Sri Lanka, and the United Republic of Tanzania.

🌍 Available Worldwide

The E-Book is delivered digitally worldwide within 24 hours.

🌍 Ships Worldwide

The Combo includes the US imported edition, delivered worldwide.

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.

You'll 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 dataIf 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 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

About the Author

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.

Book Details
Author Jim Lehmer
Publisher Shroff/O'Reilly
ISBN-13 9789355428301
Year 2023
Pages 284
Binding Paperback
Edition First
Country of Origin India

You may also like