• University of Michigan logo

Intermediate PostgreSQL

Learn to create and maintain strong databases using the PostgreSQL relational database management system (RDBMS).

Intermediate PostgreSQL
  • Duration

    4 weeks
  • Weekly study

    2 hours
  • 100% online

    Learn at your own paceHow it works
  • Unlimited

    $23.33/monthLearn more

Build on your basic PostgreSQL skills and take your programming career further

This four-week course from the University of Michigan forms part of the series on Python and PostgreSQL and directly follows the introductory course on database design and basic SQL.

You’ll learn intermediate PostgreSQL concepts, building on the foundational knowledge of the previous course.

By the end, you’ll be able to use the PostgreSQL RDBMS to create efficient, robust databases for all your Python programming projects.

Level up your PostgreSQL abilities

You’ll tap into the fundamentals that you already know about this RDBMS as you learn to utilise SQL commands to edit tables in PostgreSQL databases and to produce normalised tables from CSV files.

You’ll also be guided on inserting data into a database, creating stored procedures, identifying hashtag algorithms, and constructing regular expressions to select rows that match a pattern.

Get first-hand experience with SQL commands

Like the other courses in this series, you’ll be able to practice the concepts and skills that you’re learning with engaging assignments.

The combination of theory and hands-on training means you can understand and then apply the material, preparing you for whatever real-life work situation you find yourself in.

Trust the University of Michigan to develop your PostgreSQL skills

Besides Michigan University’s tradition of academic excellence and support, the course itself has been designed by seasoned PostgreSQL experts.

The result is a course that is as engaging as it is effective. You can rest assured that it will equip you with what you need to take your programming career further.


  • Week 1

    SQL Techniques

    • Welcome

      Welcome to the course!

    • Lectures

      Getting started with using SQL commands.

    • Assignments

      Assignment content for week 1.

    • Week Wrap-up

      Wrapping up the week.

  • Week 2

    Using SQL Techniques

    • Lectures

      This week, we'll expand upon using SQL techniques to interact with CSV files and adjusting schemas.

    • Assignments

      Assignment content for week 2.

    • Week Wrap-up

      Wrapping up the week.

  • Week 3

    Text in PostgreSQL

    • Lectures

      This week will introduce working with text in PostgreSQL.

    • Assignments

      Assignment content for week 3.

    • Week Wrap-up

      Wrapping up the week.

  • Week 4

    Regular Expressions

    • Lectures

      This week we'll introduce regular expressions and how they interact with SQL.

    • 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 learn at your own pace. If the course hasn’t started yet you’ll see the future date listed below.

  • Available now

Learning on this course

You can take this self-guided course and learn at your own pace. 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...

  • Apply SQL commands for editing tables in a PostgreSQL database and produce properly normalized tables from CSV files
  • Explore handling text and dates in databases, and create stored procedures
  • Identify hashtag algorithm and their attributes
  • Create regular expressions to select rows that match a pattern

Who is the course for?

This course is designed for programmers with a background in Python, who would like to take their PostgreSQL skills to the next level. Prior completion of the previous course on basic SQL will be very valuable.

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

  • Location

    Ann Arbor, Michigan, USA
  • World ranking

    Top 30Source: Times Higher Education World University Rankings 2020

Ways to learn

Upgrade this course


Basic access

Choose the best way to learn for you!



Billed at $279.99 for a year


Unlock your expertiseEndless possibilities!Try before you upgrade
Access to this courseticktickLimited to 4 weeks
Access to ALL eligible short courses with additional benefits, for a yearcrosstickcross
Discuss your learning in commentstickticktick
Tests to check your learningticktickcross
Certificate when you're eligiblePrinted and digitalDigital onlycross
Join and Upgrade

Ways to learn

Buy Unlimited to access this course and hundreds of other short courses for a year or Upgrade just this course for extra benefits. Or, join with basic access.



Billed at $279.99 for a year

Endless possibilities!

  • Access to this course
  • Access to ALL eligible short courses with additional benefits, for a year
  • Discuss your learning in comments
  • Tests to boost your learning
  • Digital certificate when you're eligible

Upgrade this course


Unlock your expertise

  • All of the above* for this course only, plus a printed certificate when you’re eligible

*Excludes access to all eligible short courses with additional benefits for a year

Basic access


Try before you buy

  • Limited access to course content for 4 weeks

Find out more about certificates, Upgrades or Unlimited.

Find out more about certificates, Upgrades or Unlimited.

Learning on FutureLearn

Your learning, your rules

  • Courses are split into weeks, activities, and steps, but you can complete them as quickly or slowly as you like
  • 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...