Book 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 data
Publisher resources
Table of contents
- I. Pre Ramble
-
Preface
- What Problems Are We Trying to Solve?
- What Will We Cover?
- Who Is This Book For?
- Why SQL?
- Warning! Opinions Ahead!
- Typographical Conventions Used In This Book
- Additional Information on the Book’s Conventions
- Glossary
- The Data “Model”
- Using Code Examples
- O’Reilly Online Learning
- How to Contact Us
- Acknowledgements
- II. Review
- 1. A SELECT Review
- 2. Function Junction
- III. Various Data Problems
- 3. Names, Names, Names
- 4. Location, Location, Location
- 5. Dates, Dates, Dates
- 6. Email
- 7. Phone Numbers
- 8. Bad Characters
- 9. Orthogonal Data
- IV. Bringing It Together
- 10. The Big Score
- 11. Data Quality, Or GIGO
- 12. Tying It All Together
- 13. Code Is Data, Too!
- V. Appendixes
- A. The Data “Model”
- About the Author
Product information
- Title: Fuzzy Data Matching with SQL
- Author(s):
- Release date: October 2023
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781098152277
You might also like
book
Learning JavaScript Design Patterns, 2nd Edition
Do you want to write beautiful, structured, and maintainable JavaScript by applying modern design patterns to …
book
Hypermodern Python Tooling
Keeping up with the Python ecosystem can be daunting. Its developer tooling doesn't provide the out-of-the-box …
book
Cost-Effective Data Pipelines
The low cost of getting started with cloud services can easily evolve into a significant expense …
book
Software Architecture for Busy Developers
A quick start guide to learning essential software architecture tools, frameworks, design patterns, and best practices …