Your Cart
Loading

SQL for Genealogy

Learn how to convert your family tree into a database.


Use SQL to analyze your family data.


16 Videos.

22 SQL scripts.

Two free lessons.

Online Course

Use SQL to uncover family connections.

Identify errors and research gaps. 

Create powerful reports to analyze

names, locations, dates, and relationships.

Powerful Queries

SQL scripts to download and run immediately on your own trees.

Watch how queries work on a real family tree with typical gaps, errors, and inconsistencies.

Produce beautiful maps revealing your family's migration patterns.

Track fascinating patterns like lifespan, family sizes, and unusual events.

Identify and fix inconsistencies in names, ages, and places.

Buy Now!

Course Price

$49

Course Curriculum

Check out the free previews in Module 1 and 2!

  • 1
    Module 1 - Installs and Setups
  • 2
    Module 2 - Person Reports
  • 3
    Module 3 - Name Frequency
    • 3.1 Name Frequency Queries
    • 3.2 Name Frequency Charts
  • 4
    Module 4 - Location Reports
    • 4.1 Location Analysis
    • 4.2 Parsing Addresses
    • 4.3 Charting Locations
  • 5
    Module 5 - At This Place
    • 5.1 At This Place
    • 5.2 Fix Inconsistent Data
  • 6
    Module 6 - Date Analysis
    • 6.1 Date Calculations
  • 7
    Module 7 - Identify Duplicates
    • 7.1 Identify Duplicate Issues
  • 8
    Module 8 - Identify Age Issues
    • 8.1 Identify Age Issues
  • 9
    Module 9 - Identify Large Families
    • 9.1 Identify Large Families
  • 10
    Module 10 - Gaps and Missing Details
    • 10.1 Gaps and Missing Records
  • 11
    Module 11 - Ancestral Lines
    • 11.1 Ancestral Lines