EdX

JSON and Natural Language Processing in PostgreSQL (edX)

Offered by University of Michigan, MichiganX,
JSON and Natural Language Processing in PostgreSQL (edX)

In this third course in PostgreSQL for Everybody, learners will learn how PostgreSQL creates and uses JSON and natural language content. Learners will explore using multiple sources of data and how text is structured within PostgreSQL.

Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.

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.
This course is part of the PostgreSQL for Everybody Professional Certificate.

What you'll 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.
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Natural Language Processing and Language Understanding in Educational Research (edX) EdX
University of Texas at Arlington,UTArlingtonX

Natural Language Processing and Language Understanding in Educational Research (edX)

Education Statistics & Data Analysis

An introduction to analysis of language data for educational researchers. This course offers an overview of natural language processing (NLP) and natural language understanding (NLU) for educational practitioners, leaders, and researchers. This class introduces analysis of and analytical tools for research work with unstructured data such as student writing, responses to learner surveys, interview data, or transcripts from an educational setting.

No sessions available
3 Weeks
Education NLP Natural Language
Details
Natural Language Processing with Sequence Models (Coursera) Coursera
DeepLearning.AI

Natural Language Processing with Sequence Models (Coursera)

Data Science

In Course 3 of the Natural Language Processing Specialization, offered by deeplearning.ai, you will: a) Train a neural network with GLoVe word embeddings to perform sentiment analysis of tweets, b) Generate synthetic Shakespeare text using a Gated Recurrent Unit (GRU) language model, c) Train a recurrent neural network to perform named entity recognition (NER) using LSTMs with linear layers, and d) Use so-called ‘Siamese’ LSTM models to compare questions in a corpus and identify those that are worded differently but have the same meaning.

Nov 2nd 2026
4 Weeks
Neural Networks Natural Language Natural Language Processing
Details
Natural Language Processing with Classification and Vector Spaces (Coursera) Coursera
DeepLearning.AI

Natural Language Processing with Classification and Vector Spaces (Coursera)

Data Science

In Course 1 of the Natural Language Processing Specialization, offered by deeplearning.ai, you will: a) Perform sentiment analysis of tweets using logistic regression and then naïve Bayes, b) Use vector space models to discover relationships between words and use PCA to reduce the dimensionality of the vector space and visualize those relationships, and c) Write a simple English to French translation algorithm using pre-computed word embeddings and locality sensitive hashing to relate words via approximate k-nearest neighbor search.

Nov 2nd 2026
4 Weeks
Machine Learning Classification Logistic Regression
Details
Database Architecture, Scale, and NoSQL with Elasticsearch (edX) EdX
University of Michigan,MichiganX

Database Architecture, Scale, and NoSQL with Elasticsearch (edX)

Computer Science

In this fourth and final course in PostgreSQL for Everybody, learners will explore databses architectures, CRUD operations and how ACID requirements are implemented in PostgreSQL. Within this course, you will explore database architecture, PostgreSQL, and various scalable deployment configurations. You will see how PostgreSQL implements basic CRUD operations and indexes, and review how transactions and the ACID (Atomicity, Consistency, Isolation, Durability) requirements are implemented.

Self Paced
Self-Paced
Databases NoSQL CRUD
Details
Applied Text Mining in Python (Coursera) Coursera
University of Michigan

Applied Text Mining in Python (Coursera)

Statistics & Data Analysis Data Science

This course will introduce the learner to text mining and text manipulation basics. The course begins with an understanding of how text is handled by python, the structure of text both to the machine and to humans, and an overview of the nltk framework for manipulating text. The second week focuses on common manipulation needs, including regular expressions (searching for text), cleaning text, and preparing text for use by machine learning processes. The third week will apply basic natural language processing methods to text, and demonstrate how text classification is accomplished. The final week will explore more advanced methods for detecting the topics in documents and grouping them by similarity (topic modelling).

Nov 9th 2026
4 Weeks
Programming Python Machine Learning
Details