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

RG

5.0Reviewed Aug 14, 2022

I loved it! Have taken already 3 SQL basic courses with Dr. Chuch so all examples are the same LOL but loved learning the variations in postgreSQL.

RM

5.0Reviewed May 20, 2021

An awesome and great introductory course to SQL and PostgreSQL, this course had made all the complex and tedious task into fun and gamification thing.

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.

PN

5.0Reviewed Jun 15, 2021

This is amazing course. In my opinion, the content of course is very concise and I can remember the important things easily

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.

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!

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.

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.

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.

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.

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