This course is part of the PostgreSQL for Everybody Specialization

4.6
stars
103 ratings

Charles Russell Severance

5,445 already enrolled

Offered By

PostgreSQL for Everybody SpecializationUniversity of Michigan

About this Course

15,901 recent views

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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 4 in the

PostgreSQL for Everybody Specialization

Intermediate Level

Completion of the first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python

Approx. 16 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

What you will 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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 4 in the

PostgreSQL for Everybody Specialization

Intermediate Level

Completion of the first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python

Approx. 16 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

3.93/5 (16 Ratings)

Charles Russell Severance

Clinical Professor

School of Information

3,775,986 Learners

56 Courses

Offered by

University of Michigan

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week1

Week 1

6 hours to complete

Natural Language

6 hours to complete

9 videos (Total 84 min), 5 readings, 4 quizzes

9 videos

Welcome to the Course!2mAllocating Rows to Blocks in PostgreSQL9mIndex Implementation Details15mBuilding an Inverted Index with SQL6mDemonstration: SQL Inverse Index10mBuilding a Natural Language Index with SQL6mDemonstration: SQL Natural Language Index17mBonus: Office Hours - Seoul, South Korea9mBonus: Office Hours - Portland, Oregon, USA5m

5 readings

Help Us Learn More About You5mSyllabus10mEach Course Uses a Different Database10mHow Assignments Work10mConnecting to Your Database Server10m

Week2

Week 2

3 hours to complete

Inverted Indexes with PostgreSQL

3 hours to complete

7 videos (Total 45 min), 1 reading, 3 quizzes

Week3

Week 3

4 hours to complete

Python and PostgreSQL

4 hours to complete

10 videos (Total 82 min), 2 readings, 2 quizzes

10 videos

Lecture: PostgreSQL and Python5mDemonstration Python and PostgreSQL simple.py16mDemonstration loadbook.py12mLecture: Mail Archive4mDemonstration: Mail Archive 1/316mDemonstration: Mail Archive 2/310mLecture: Ranking Search Results with PostgreSQL4mDemonstration: Mail Archive 3/37mOffice Hours: Zagreb, Croatia3mOffice Hours, Orlando, Florida, USA1m

2 readings

How Python Assignments Work10mPython and PostgreSQL on PythonAnywhere10m

Week4

Week 4

3 hours to complete

JSON and PostgreSQL

3 hours to complete

11 videos (Total 100 min), 2 readings, 2 quizzes

11 videos

Lecture: JavaScript Object Notation10mInterview: Douglas Crockford - JSON7mLecture: Python and JSON6mLecture: PostgreSQL and JSON11mDemonstration: Music Tracks and JSON26mLecture: Using a JSON API2mDemonstration: Star Wars API 1/216mDemonstration: Star Wars API 2/215mCourse Wrap Up56sOffice Hours, London, England1mOffice Hours - Montreal, Quebec, Canada (at PyCon)39s

2 readings

Douglas Crockford and JSON10mPost-Course Survey5m

1 practice exercise

JSON and PostgreSQL30m

Reviews

4.6

23 reviews

5 stars
77.66%
4 stars
10.67%
3 stars
6.79%
2 stars
0.97%
1 star
3.88%

TOP REVIEWS FROM JSON AND NATURAL LANGUAGE PROCESSING IN POSTGRESQL

by DDMay 12, 2022

Could use some more examples on WHY we need JSON in a SQL setup

by KKJan 9, 2022

Week 4 was a titbit challenging, but I figure it out. On to the next one. Lol

by GLJan 28, 2022

Week 3 and week 4 instructions can be a bit ambiguous, however the discussion form posts helped a lot.

by GGMay 21, 2021

This course teaches some niche applications. Not sure if i'll ever have to use them, but good to know what to look for in case it ever comes up at work :)

View all reviews

About the PostgreSQL for Everybody Specialization

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

JSON and Natural Language Processing in PostgreSQL

About this Course

What you will learn