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: SQL
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

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