Back to JSON and Natural Language Processing in PostgreSQL
University of Michigan

JSON and Natural Language Processing in PostgreSQL

Within this course, you’ll learn about how PostgreSQL creates and uses inverted indexes for JSON and natural language content. We will use various sources of data for our databases, including access to an online API and spidering its data and storing the data in a JSON column in PostgreSQL. Students will explore how full-text inverted indexes are structured. Students will build their own inverted indexes and then make use of PostgreSQL built-in capabilities to support full-text indexes.

Status: Natural Language Processing
Status: Database Management
IntermediateCourse16 hours

Featured reviews

DD

Reviewed May 12, 2022

C​ould use some more examples on WHY we need JSON in a SQL setup

NB

Reviewed Apr 2, 2023

great way to introduce general sql skills while focusing on text search and exploitation

SB

Reviewed Dec 30, 2024

Excellent course and instructor - I would highly recommend to anyone interested in exploring the 'new-ish' json/jsonb/inverted index support in PostgreSQL.

JF

Reviewed Jun 15, 2021

Its awesome I can use it in my software development

IG

Reviewed Jun 7, 2022

E​xcellent course. Lots of useful code demonstration.

KK

Reviewed Jan 9, 2022

W​eek 4 was a titbit challenging, but I figure it out. On to the next one. Lol

AV

Reviewed Sep 2, 2024

Excellent teaching, with great examples that explain how the system works.

All reviews

Showing: 20 of 30

Lily
Reviewed Jul 5, 2021
Yardley
Reviewed Feb 15, 2022
Billy
Reviewed Apr 18, 2022
Pranav
Reviewed Oct 7, 2022
Glenn
Reviewed May 22, 2021
Chaoren
Reviewed May 19, 2021
Dhruv
Reviewed May 13, 2022
Justin
Reviewed Oct 30, 2022
Connor
Reviewed Jan 6, 2023
Fabio
Reviewed Sep 2, 2021
Nevil
Reviewed Mar 22, 2022
Steve
Reviewed Dec 30, 2024
Keslo
Reviewed Jan 10, 2022
Wai
Reviewed Sep 2, 2021
Andrew
Reviewed Sep 3, 2024
Iván
Reviewed Jun 8, 2022
John
Reviewed Jun 16, 2021
Eduardo
Reviewed Nov 25, 2021
Benjamin
Reviewed Dec 29, 2021
Olexander
Reviewed Aug 5, 2021