Monthly Subscription Starting at AED 99 + VAT

JSON and Natural Language Processing in PostgreSQL
  • Level Professional
  • Duration 16 hours
  • Course by University of Michigan
  • Offered by

About

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.

Modules

Lectures

    • 7 Videos
    • 2 Readings
Show info about module content

7 Videos

  • Welcome to the Course!
  • Allocating Rows to Blocks in PostgreSQL
  • Index Implementation Details
  • Building an Inverted Index with SQL
  • Demonstration: SQL Inverse Index
  • Building a Natural Language Index with SQL
  • Demonstration: SQL Natural Language Index

2 Readings

  • Help Us Learn More About You
  • Syllabus

Assignments

    • 3 Readings
    • 4 ExternalTool
Show info about module content

4 External Tool

  • Initial Database Setup
  • Making our First Tables
  • Building an Inverted Index using SQL
  • Building an Inverted Index with stop words using SQL

3 Readings

  • Each Course Uses a Different Database
  • How Assignments Work
  • Connecting to Your Database Server

Bonus

    • 2 Videos
Show info about module content

2 Videos

  • Bonus: Office Hours - Seoul, South Korea
  • Bonus: Office Hours - Portland, Oregon, USA

Lectures

    • 5 Videos
Show info about module content

5 Videos

  • A GIN-based Inverted Index with PostgreSQL
  • Demonstration: GIN-based inverted index
  • Building a Natural Language Index in PostgreSQL
  • Demonstration: Fulltext tsquery and tsvector Functions
  • Demonstration: Building a GIN / tsvector Index

Assignments

    • 1 Readings
    • 2 ExternalTool
    • 1 Assignment
Show info about module content

1 Assignment

  • Text In Databases

2 External Tool

  • Building a string array-based GIN index
  • Building a tsvector-based full text GIN index

1 Readings

  • Assessment Philosophy

Bonus

    • 2 Videos
Show info about module content

2 Videos

  • Office Hours - Washington, DC, USA
  • Office Hours, Amsterdam, Netherlands

Lectures

    • 8 Videos
Show info about module content

8 Videos

  • Lecture: PostgreSQL and Python
  • Demonstration Python and PostgreSQL simple.py
  • Demonstration loadbook.py
  • Lecture: Mail Archive
  • Demonstration: Mail Archive 1/3
  • Demonstration: Mail Archive 2/3
  • Lecture: Ranking Search Results with PostgreSQL
  • Demonstration: Mail Archive 3/3

Assignments

    • 2 Readings
    • 2 ExternalTool
Show info about module content

2 External Tool

  • Running simple.py
  • A Sequence of Numbers

2 Readings

  • How Python Assignments Work
  • Python and PostgreSQL on PythonAnywhere

Bonus

    • 2 Videos
Show info about module content

2 Videos

  • Office Hours: Zagreb, Croatia
  • Office Hours, Orlando, Florida, USA

Lectures

    • 8 Videos
    • 1 Readings
Show info about module content

8 Videos

  • Lecture: JavaScript Object Notation
  • Interview: Douglas Crockford - JSON
  • Lecture: Python and JSON
  • Lecture: PostgreSQL and JSON
  • Demonstration: Music Tracks and JSON
  • Lecture: Using a JSON API
  • Demonstration: Star Wars API 1/2
  • Demonstration: Star Wars API 2/2

1 Readings

  • Douglas Crockford and JSON

Assignments

    • 1 ExternalTool
    • 1 Assignment
Show info about module content

1 Assignment

  • JSON and PostgreSQL

1 External Tool

  • Interacting with the PokéAPI

Wrap Up

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Course Wrap Up

1 Readings

  • Post-Course Survey

Bonus

    • 2 Videos
Show info about module content

2 Videos

  • Office Hours, London, England
  • Office Hours - Montreal, Quebec, Canada (at PyCon)

Auto Summary

Discover how to harness PostgreSQL for JSON and natural language processing in this professional course by Coursera. Learn to create and use inverted indexes, access online APIs, and manage data in JSON columns. Ideal for IT and Computer Science enthusiasts, this 960-minute course offers hands-on experience with full-text indexing and PostgreSQL capabilities. Available with a Starter subscription, it's perfect for advancing your database skills.

Charles Russell Severance
Instructor

Charles Russell Severance