Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

University of Michigan

JSON and Natural Language Processing in PostgreSQL

University of Michigan via Coursera

Overview

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.

Syllabus

  • Natural Language
    • In this first week, we introduce you to the course and its main focus: text and JSON.
  • Inverted Indexes with PostgreSQL
    • In this week, we'll look at GIN-based inverted indexes and ts_vector() and ts_query() functions.
  • Python and PostgreSQL
    • This week is all about connecting and comparing Python and PostgreSQL.
  • JSON and PostgreSQL
    • In this final week, we'll focus primarily on JSON and its functions.

Taught by

Charles Russell Severance

Related Courses

Reviews

Start your review of JSON and Natural Language Processing in PostgreSQL

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free