Back to Intermediate PostgreSQL
University of Michigan

Intermediate PostgreSQL

This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database. You’ll also take a look at how PostgreSQL handles and indexes text data. Specifically, students will do assignments that alter table schemas, create stored procedures, construct advanced queries, explore sorting and grouping query data, and techniques for working with text in databases including regular expressions.

Status: Data Manipulation
Status: Stored Procedure
IntermediateCourse16 hours

Featured reviews

AM

5.0Reviewed Jul 16, 2023

The instructor Dr. Chuck and the materials covered in this program are great.

JV

4.0Reviewed Sep 20, 2021

L​earned a lot, and it was fun. I would give 5 stars if it was a bit more challenging.

FS

5.0Reviewed Jan 21, 2022

This course was very helpful. Before taking this course, I only knew simple CRUD operations, but there is more information there. I got new knowledge. Thank you. Hope will take more Chuck courses.

SR

5.0Reviewed Sep 26, 2025

I feel very happy and satisfied to do this postgresql course. Thankyou for giving time to complete the assignment.Thank you to give me such a certificate means a lot Thank you once again

JH

5.0Reviewed Oct 11, 2022

D​r Chuck is the best. He makes learning enjoyable. Way to go.

JH

5.0Reviewed May 1, 2022

Very down to earth and practical course on postgres. I especially liked the interactive graded assignments as well as friendly and informal attitude of mr. Severance.

KB

5.0Reviewed Nov 12, 2021

Great lecture material, the assignments seem overwhelming at first but are actually quite easy if you pay attention to the lectures.

LW

5.0Reviewed Jul 6, 2022

interesting courses contain lots of information that are very useful. recommended !

AD

5.0Reviewed Jun 3, 2021

Learning deeper uses and applications for PostgreSQL, which can be useful.

SD

5.0Reviewed Jul 23, 2021

Another Amazing course By Dr Chuck. A must do course for anyone who wants to learn SQL.

JB

5.0Reviewed Jun 20, 2021

Excellent course with lots of non basic SQL and Postgres material. I especially liked the chapter on Regex in Postgres. Regex in SQL ... so so cool!

LP

5.0Reviewed Nov 15, 2021

This course was super useful for me and I've learned incredible topics and materials from this course, Thanks a lot.

All reviews

Showing: 19 of 81

Jean-Claude Brantschen
5.0
Reviewed Jun 21, 2021
Fabio Barcello S. R. Muller
5.0
Reviewed Jul 29, 2021
John B
3.0
Reviewed Feb 26, 2022
Juan Pablo Rodríguez Sánchez
3.0
Reviewed Nov 16, 2023
ERNANI GOMES
5.0
Reviewed Dec 30, 2022
Shreya Kumar
5.0
Reviewed Apr 14, 2022
Daniel Uzcátegui
5.0
Reviewed Jul 26, 2021
Lai Chun Yin
5.0
Reviewed Mar 29, 2024
Farhodbek Shamsiyev
5.0
Reviewed Jan 22, 2022
Shyamala R
5.0
Reviewed Sep 27, 2025
Orfeo Fernández Ochoa
5.0
Reviewed Aug 2, 2022
Jan Hrček
5.0
Reviewed May 2, 2022
Keenan Britt
5.0
Reviewed Nov 13, 2021
Lego Papurida
5.0
Reviewed Nov 16, 2021
Daniel Fugisawa
5.0
Reviewed Sep 8, 2021
Ricardo Daniel González Gómez
5.0
Reviewed Jul 31, 2023
Cristian David Lavacude Galvis
5.0
Reviewed Oct 9, 2021
Pascal Uriel ELINGUI
5.0
Reviewed May 23, 2022
Iván Gómez
5.0
Reviewed Jun 1, 2022