University of Michigan - JSON and Natural Language Processing in PostgreSQL
- Offered byCoursera
JSON and Natural Language Processing in PostgreSQL at Coursera Overview
Duration | 16 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
JSON and Natural Language Processing in PostgreSQL at Coursera Highlights
- 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
- Flexible deadlines Reset deadlines in accordance to your schedule.
- 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 Subtitles: English
JSON and Natural Language Processing in PostgreSQL at Coursera Course details
- 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.
JSON and Natural Language Processing in PostgreSQL at Coursera Curriculum
Natural Language
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
Bonus: Office Hours - Seoul, South Korea
Bonus: Office Hours - Portland, Oregon, USA
Help Us Learn More About You
Each Course Uses a Different Database
How Assignments Work
Connecting to Your Database Server
Inverted Indexes with PostgreSQL
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
Office Hours - Washington, DC, USA
Office Hours, Amsterdam, Netherlands
Assessment Philosophy
Text In Databases
Python and PostgreSQL
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
Office Hours: Zagreb, Croatia
Office Hours, Orlando, Florida, USA
How Python Assignments Work
Python and PostgreSQL on PythonAnywhere
JSON and PostgreSQL
Lecture: JavaScript Object Notation
Interview: Douglas Crockford - JSON
Lecture: Python and JSON
Lecture: PostgreSQL and JSON
Demonstration: Music Tracks and JSONB
Lecture: Using a JSON API
Demonstration: Star Wars API 1/2
Demonstration: Star Wars API 2/2
Course Wrap Up
Office Hours, London, England
Office Hours - Montreal, Quebec, Canada (at PyCon)
Douglas Crockford and JSON
Post-Course Survey
JSON and PostgreSQL
JSON and Natural Language Processing in PostgreSQL at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?