Back to Database Design and Basic SQL in PostgreSQL
University of Michigan

Database Design and Basic SQL in PostgreSQL

In this course you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON DELETE CASCADE, etc) will enable you to create tables, column types and define the schema of your data in PostgreSQL. You will learn about data modeling and how to represent one-to-many and many-to-many relationships in PostgreSQL. Students will do hands-on assignments creating tables, inserting data, designing data models, creating relational structures and inserting and querying relational data in tables.

Status: Relational Databases
Status: Database Theory
IntermediateCourse14 hours

Featured reviews

TA

4.0Reviewed Dec 14, 2022

Very good course but some information is just too abstract. It need a little bit more detail and depth in order to understand concepts. The practicality of the exercises is just amazing. Great job!

VD

5.0Reviewed Feb 19, 2023

Good course Very good course, easy to assimilate for a beginner, at the first "contact" with databases and things like that...

WW

4.0Reviewed Nov 29, 2022

Overall good course. I had to locate some GitHub and W3schools SQL references to assist programming assignments.

CF

5.0Reviewed Oct 24, 2021

This course is for beginners from a very thorough perspective. Even though I've seen most of the material in college, it was great to catch up on it, and have a distinct perspective of the subject.

MH

5.0Reviewed Sep 17, 2022

This course was a fantastic introduction to SQL and PostgreSQL that turned all the difficult, tiresome tasks into enjoyable games.

ML

4.0Reviewed Jun 13, 2022

Dr. Charles is passionate about what he teaches, and it has made me become personally invested more into data science.

MF

5.0Reviewed Aug 10, 2024

Exceptional course and instructor! Teaches valuable knowledge and was easy to follow for someone with a background in programming, but not in SQL.

PT

5.0Reviewed Dec 26, 2021

A really helpful and great course on DB design and basic SQL. I would recommend reading the basics of SQL before signing up. Overall, I would highly recommend it!

TP

4.0Reviewed Nov 6, 2025

Excellent Teacher, thanks sir, you definitely giving a vibe of a actual class rather than just a "knowledge transfer" course.

AA

4.0Reviewed Nov 1, 2021

Lectures are decently produced and informative. However, since this is a basic course, most people need way more extensive SQL practice than the trivial assignments provided by this course.

KT

5.0Reviewed Aug 11, 2021

D​r. Chuck delivers once again. To me there couldn't be any better explanation for SQL than this. I used to suck at SQL during university as well but after this course, I love SQL!

S

5.0Reviewed Aug 1, 2021

Unfortunately I don't have much time to learn and I am enrolled in other courses. I will work to finish this as soon as I finish the rest of the other courses

All reviews

Showing: 20 of 248

Cleydyr Albuquerque
5.0
Reviewed Apr 12, 2021
Ami Osherov
2.0
Reviewed Feb 13, 2022
Olexander Tverdohleb
5.0
Reviewed Jun 1, 2021
RajGaurav Maurya
5.0
Reviewed May 21, 2021
Sagar
5.0
Reviewed Aug 19, 2021
Glenn F
4.0
Reviewed May 8, 2021
Carmela Pham
5.0
Reviewed Jul 17, 2024
Yogeshwar Bala
5.0
Reviewed Feb 25, 2022
Panagiotis Timotheatos
5.0
Reviewed Dec 27, 2021
Shashwat Dev
5.0
Reviewed Jul 6, 2021
Dimitris Tolias
4.0
Reviewed Oct 16, 2023
Ramu Mohan Srinivasan RadhaKrishnan
5.0
Reviewed Jan 6, 2026
Jonathan Lehman
5.0
Reviewed May 31, 2021
Miriam Kosik
5.0
Reviewed Nov 8, 2021
Michael Mangano
5.0
Reviewed Aug 12, 2022
Pedro Luz Alencar Leite de Matos Peixoto
5.0
Reviewed Jan 25, 2023
Mahdee Mushfique Kamal (Dhrubo)
5.0
Reviewed May 19, 2021
Orfeo Fernández Ochoa
5.0
Reviewed Jun 27, 2022
Mário Canudo
5.0
Reviewed Apr 10, 2022
Daniel Duedu
5.0
Reviewed Apr 24, 2023