• University of Michigan logo

JSON and Natural Language Processing in PostgreSQL

Learn to build PostgreSQL search engines using JSON and natural language processing (NLP), and level up your programming career.

Blue and black coloured pipes across a wall. On the right side of the image is an excerpt of SQL typed on white paper.
  • Get access to 1,000s of courses
  • Learn at your own pace
  • Tests included when available
  • Digital certificate when eligible
  • Long term access to this course
  • Learn at your own pace
  • Tests included when available
  • Printed and digital certificates when eligible - great for career learners
  • Course access expires 17 Sep 2022
  • Limited learning time
  • Excludes certificates and tests

Find out more about how to join this course

Create strong indexes and PostgreSQL search engines with ease

If you have a background in basic Python programming language structures, this four-week course on JSON and NLP in PostgreSQL is for you.

Presented by the University of Michigan as part of their series on PostgreSQL and Python, the material will explain how full-text inverted indexes are structured and how PostgreSQL creates and uses these indexes for JSON and natural language content.

By the end, you’ll be able to build and support your own PostgreSQL database management system.

Explore JSON, Python, and PostgreSQL principles

The course starts with a comparison of Python programming language, PostgreSQL, and JSON. You’ll see how they relate to each other, and how they are all important in successful NLP.

You’ll also learn how to index and retrieve natural language text and JSON data, and how to access API data and store it in a database.

Use PostgreSQL to build your own index

After gaining a solid theoretical foundation in how NLP works, you’ll have the chance to apply the principles that you’ve learnt.

Using various data sources including an online API, you’ll create a GIN-based text reverse index and ts_vector index, build a search engine in PostgreSQL, and then use built-in PostgreSQL capabilities to support your indexes.

Learn programming from a world-renowned institution

The University of Michigan has a record of more than two centuries of academic excellence, and will support you on every step of this well-designed course.

The engaging and practical training material equips you to create different indexes, build search engines, and take your programming career to the next level.

Syllabus

  • Week 1

    Natural Language

    • Welcome

      Welcome to the course!

    • Lectures

      Getting started with working with text and JSON data.

    • Assignments

      Assignment content for week 1.

    • Week Wrap-up

      Wrapping up the week.

  • Week 2

    Inverted Indexes with PostgreSQL

    • Lectures

      Getting started with inverted indexes in PostgreSQL.

    • Assignments

      Assignment content for week 2.

    • Week Wrap-up

      Wrapping up the week.

  • Week 3

    Python and PostgreSQL

    • Lectures

      Learning about connecting and using Python and PostgreSQL together.

    • Assignments

      Assignment content for week 3.

    • Week Wrap-up

      Wrapping up the week.

  • Week 4

    JSON and PostgreSQL

    • Lectures

      This week introduces working with JSON and PostgreSQL and how JSON's functions interact.

    • Assignments

      Assignment content for week 4.

    • Week Wrap-up

      Wrapping up the week.

    • Wrap Up

      Wrapping up this course

When would you like to start?

Start straight away and join a global classroom of learners. If the course hasn’t started yet you’ll see the future date listed below.

  • Available now

Learning on this course

On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.

What will you achieve?

By the end of the course, you‘ll be able to...

  • Compare Python, PostgreSQL, and JSON
  • Classify and retrieve natural language text and JSON data, and access API data and store it in a database
  • Create a GIN-based text[] reverse index and ts_vector index, and build a search engine in PostgreSQL

Who is the course for?

This course is designed for programmers with a background in basic Python, who would like to develop their PostgreSQL skills.

Who will you learn with?

Charles is a Clinical Professor and teaches in the School of Information at the University of Michigan. He is the Chair of the Sakai Project Management Committee (PMC).

Who developed the course?

University of Michigan

As the #1 public research university in the United States, U-M has been a leader in research, learning, and teaching for more than 200 years, with 102 Grad programs in the top 10 — U.S. News & World Report (2019).

  • Established

    1817
  • Location

    Ann Arbor, Michigan, USA
  • World ranking

    Top 30Source: Times Higher Education World University Rankings 2020
Recommended

Ways to learn

Buy this course

Subscribe to Unlimited

Join with limited access

Choose the best way to learn for you!

$54

One-off payment

$27.99/month

Automatically renews

Free

Unlock your expertiseAccess thousands of coursesTry this course - with limits
Access to this courseticktickLimited to 4 weeks
Access to ALL eligible coursescrosstickcross
Learn at your own paceticktickcross
Discuss your learning in commentstickticktick
Tests to check your learningticktickcross
Certificate when you're eligiblePrinted and digitalDigital onlycross
Buy this course

Ways to learn

Subscribe to Unlimited to access this course and thousands of other short courses or buy just this course for extra benefits. Or, join with limited access.

Subscribe to Unlimited

$27.99/month

Automatically renews

Access thousands of courses

  • Access to this course
  • Access to ALL eligible short courses
  • Learn at your own pace
  • Discuss your learning in comments
  • Tests to boost your learning
  • Digital certificate when you're eligible

Buy this course

$54

One-off payment

Unlock your expertise

  • Access to this course
  • Learn at your own pace
  • Discuss your learning in comments
  • Tests to boost your learning
  • Printed and digital certificate when you’re eligible

Join with limited access

Free

Try before you buy

  • Limited access to course content for 4 weeks

Find out more about certificates, Unlimited or buying a course (Upgrades)

Learning on FutureLearn

Your learning, your rules

  • Courses are split into weeks, activities, and steps to help you keep track of your learning
  • Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
  • Stay motivated by using the Progress page to keep track of your step completion and assessment scores

Join a global classroom

  • Experience the power of social learning, and get inspired by an international network of learners
  • Share ideas with your peers and course educators on every step of the course
  • Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others

Map your progress

  • As you work through the course, use notifications and the Progress page to guide your learning
  • Whenever you’re ready, mark each step as complete, you’re in control
  • Complete 90% of course steps and all of the assessments to earn your certificate

Want to know more about learning on FutureLearn? Using FutureLearn

Do you know someone who'd love this course? Tell them about it...