Booktopia has been placed into Voluntary Administration. Orders have been temporarily suspended, whilst the process for the recapitalisation of Booktopia and/or sale of its business is completed, following which services may be re-established. All enquiries from creditors, including customers with outstanding gift cards and orders and placed prior to 3 July 2024, please visit https://www.mcgrathnicol.com/creditors/booktopia-group/
Add free shipping to your order with these great books
Fuzzy Data Matching with SQL : Enhancing Data Quality and Query Performance - Jim Lehmer

Fuzzy Data Matching with SQL

Enhancing Data Quality and Query Performance

By: Jim Lehmer

Paperback | 13 October 2023

At a Glance

Paperback


RRP $114.00

$46.80

59%OFF

or 4 interest-free payments of $11.70 with

In Stock and Aims to ship next day

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
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.

More in Database Programming

Learning SQL : Generate, Manipulate, and Retrieve Data - Alan Beaulieu
SQL For Dummies : 9th edition - Allen G. Taylor

RRP $57.95

$36.50

37%
OFF
SQL Tuning : O'Reilly Ser. - Dan Tow

RRP $75.95

$32.25

58%
OFF
Understanding MySQL Internals : O'Reilly Ser. - Sasha Pachev

RRP $95.00

$40.25

58%
OFF
MySQL Pocket Reference 2e : Pocket Reference (O'Reilly) - George Reese
Head First SQL : Head First - Lynn Beighley

RRP $114.00

$46.75

59%
OFF
Oracle PL/SQL Best Practices : O'Reilly Ser. - Steven Feuerstein

RRP $57.00

$28.75

50%
OFF
SQL in a Nutshell : A Desktop Quick Reference - Kevin Kline

RRP $123.99

$51.50

58%
OFF
PHP & MySQL : The Missing Manual - Brett Mclaughlin

RRP $76.00

$32.25

58%
OFF
Learning Oracle PL/SQL : Learning Ser. - Bill Pribyl

RRP $95.00

$49.50

48%
OFF
Transact-SQL Cookbook : Cookbooks Ser. - Ales Spetic

RRP $76.00

$32.75

57%
OFF
Mastering Oracle SQL 2e : O'Reilly Ser. - Sanjay Mishra

RRP $95.00

$41.75

56%
OFF
The Art of SQL : O'Reilly Ser. - Stephane Faroult

RRP $104.50

$50.25

52%
OFF
MySQL in a Nutshell : In a Nutshell (O'Reilly) - Russell Dyer

RRP $66.50

$28.50

57%
OFF
LINQ Pocket Reference : Pocket Reference (O'Reilly) - Joseph Albahari
Head First PHP & MySQL : Head First - Lynn Beighley

RRP $104.50

$40.90

61%
OFF