EdX

JSON and Natural Language Processing in PostgreSQL (edX)

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

JSON and Natural Language Processing in PostgreSQL (Coursera) Coursera
University of Michigan

JSON and Natural Language Processing in PostgreSQL (Coursera)

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.

Jun 22nd 2026
4 Weeks
Intermediate PostgreSQL (edX) EdX
University of Michigan,MichiganX

Intermediate PostgreSQL (edX)

This second course in PostgreSQL for Everybody explores a wide range of SQL techniques to aggregate and transact data in PostgreSQL.This course also explores handling, reading, and parsing data with PostgreSQL and working with text in databases with regular expressions. This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database.

Self Paced
Self-Paced
Text Analytics 2: Visualizing Natural Language Processing (edX) EdX
University of Canterbury,UCx

Text Analytics 2: Visualizing Natural Language Processing (edX)

Extend your knowledge of the core techniques of text analytics by looking at how to make sense of the output of models. Visualizing Text Analytics with Python is the second course in the Text Analytics with Python professional certificate. Natural language processing (NLP) is only useful when its results are meaningful to humans. This second course continues by looking at how to make sense of our results using real-world visualizations.

Self Paced
Self-Paced
Cloud Application Developer Capstone (edX) EdX
IBM

Cloud Application Developer Capstone (edX)

In this project you will sharpen your new full stack cloud application development skills. You will use modern tools and technologies to create a working cloud ecosystem. You will design and develop a comprehensive solution that reflects your mastery of key cloud native computing concepts and capabilities. The project provides you with a real-life challenge that requires you to flex and firm your cloud native application development muscle. You will start with a problem situation.

Self Paced
Self-Paced
Text Analytics 1: Introduction to Natural Language Processing (edX) EdX
University of Canterbury,UCx

Text Analytics 1: Introduction to Natural Language Processing (edX)

Learn the core techniques of text analytics alongside the cognitive science that makes it all possible. Introduction to Text Analytics with Python is part one of the Text Analytics with Python professional certificate. This first course introduces the core techniques of natural language processing (NLP). But we introduce these techniques from data science alongside the cognitive science that makes them possible.

Self Paced
Self-Paced
Computer Applications of Artificial Intelligence and e-Construction (edX) EdX
Purdue University,PurdueX

Computer Applications of Artificial Intelligence and e-Construction (edX)

Learn the fundamentals of artificial intelligence, machine learning, natural language processing and their applications in e-Construction. This course is the third in a sequence of interrelated courses of the current computer applications in the construction industry. The emphasis of this course is the advanced computational tools including artificial intelligence, machine learning, and natural language processing, and their applications in e-Construction.

Mar 28th 2022
5-12 Weeks
Building Interactive Web Pages Using Modern JavaScript (Coursera) Coursera
NIIT StackRoute

Building Interactive Web Pages Using Modern JavaScript (Coursera)

Most businesses with a strong online presence wish to provide its consumers a rich interactive user experience. HTML5 and CSS3 frameworks help you build a static web page, that displays content and works on any device. However, to make a page interactive you need a programming language that can be understood by the browsers. JavaScript is one of the core technologies of the World Wide Web.

Jun 22nd 2026
5-12 Weeks
Applied Text Mining in Python (Coursera) Coursera
University of Michigan

Applied Text Mining in Python (Coursera)

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).

Jun 22nd 2026
4 Weeks