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: Database Theory
Status: Relational Databases
IntermediateCourse14 hours

Featured reviews

WW

4.0Reviewed Nov 29, 2022

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

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...

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.

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!

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!

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.

KA

5.0Reviewed Aug 24, 2023

The best course that I had for databases, the knowledge and examples are awesome to grasp the potential of SQL and PostgreSQL

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.

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.

VH

5.0Reviewed Apr 8, 2022

E​xcelent! I'd say the best introductory course on SQL in general. It has those important SQL basics that you really don't find elsewhere.

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
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