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

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
Computational Social Science Capstone Project (Coursera) Coursera
University of California, Davis

Computational Social Science Capstone Project (Coursera)

CONGRATULATIONS! Not only did you accomplish to finish our intellectual tour de force, but, by now, you also already have all required skills to execute a comprehensive multi-method workflow of computational social science. We will put these skills to work in this final integrative lab, where we are bringing it all together. We scrape data from a social media site (drawing on the skills obtained in the 1st course of this specialization). We then analyze the collected data by visualizing the resulting networks (building on the skills obtained in the 3rd course). We analyze some key aspects of it in depth, using machine learning powered natural language processing (putting to work the insights obtained during the 2nd course).

Aug 3rd 2026
4 Weeks
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)

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

Aug 3rd 2026
4 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).

Aug 17th 2026
4 Weeks
Introducción al desarrollo de aplicaciones web (edX) EdX
Universidad Autonoma de Madrid

Introducción al desarrollo de aplicaciones web (edX)

Aprende a desarrollar una aplicación web desde cero con diferentes tecnologías como HTML, CSS, Python, JSON, JavaScript y Ajax. Hoy en día utilizamos la web para todo tipo de tareas: buscar un vuelo, comprar entradas, ver el pronóstico meteorológico, leer noticias, etc. Todo esto es posible gracias a las aplicaciones web creadas para darnos estos servicios.

Self Paced
Self-Paced
SQL for Security Specialist (Coursera) Coursera
Codio

SQL for Security Specialist (Coursera)

This course is designed specifically for SQL Security Specialists with a focus on PostgreSQL. It assumes a solid foundation in SQL and guides learners through advanced topics specific to PostgreSQL. You'll explore crucial concepts, such as complex queries, performance optimization, and database administration tasks unique to PostgreSQL.

Aug 17th 2026
3 Weeks