Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

University of Michigan

JSON and Natural Language Processing in PostgreSQL

University of Michigan via Coursera

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
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.

Syllabus

  • Natural Language
    • In this first week, we introduce you to the course and its main focus: text and JSON.
  • Inverted Indexes with PostgreSQL
    • In this week, we'll look at GIN-based inverted indexes and ts_vector() and ts_query() functions.
  • Python and PostgreSQL
    • This week is all about connecting and comparing Python and PostgreSQL.
  • JSON and PostgreSQL
    • In this final week, we'll focus primarily on JSON and its functions.

Taught by

Charles Russell Severance

Reviews

5.0 rating, based on 1 Class Central review

4.6 rating at Coursera based on 117 ratings

Start your review of JSON and Natural Language Processing in PostgreSQL

  • الدورة جيدة جدا يجب أيضا مراعات قراءة أي مقالة او كتاب وتحديد الهدف من ذلك حتى لو كان منهج دراسي معين فلذلك هناك فرق في الأشخاص المتدربين او الأشخاص المدربين ومراعات الدرجة التثقيفية أي ثقافة كل شخص موجود ضمن الدورة حتى يتسنى للمدرب توصيل أي معلومة بصورة سلسة ومضمونة في نجاح المتدرب

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.