JSON and Natural Language Processing in PostgreSQL (Coursera)

What You Will Learn

- Compare Python, PostgreSQL, and JSON.

- Index and retrieve natural language text and JSON data; access API data and store it in a database.

- Create a GIN-based text[] reverse index and ts_vector index; build a search engine in PostgreSQL.

Course 3 of 4 in the PostgreSQL for Everybody Specialization.

Syllabus

WEEK 1

Natural Language

In this first week, we introduce you to the course and its main focus: text and JSON.

WEEK 2

Inverted Indexes with PostgreSQL

In this week, we'll look at GIN-based inverted indexes and ts_vector() and ts_query() functions.

WEEK 3

Python and PostgreSQL

This week is all about connecting and comparing Python and PostgreSQL.

WEEK 4

JSON and PostgreSQL

In this final week, we'll focus primarily on JSON and its functions.