Chevron Left
Back to Database Design and Basic SQL in PostgreSQL

Learner Reviews & Feedback for Database Design and Basic SQL in PostgreSQL by University of Michigan

4.8
stars
955 ratings

About the Course

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

Top reviews

CF

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.

OT

May 31, 2021

Dr. Chuck is the best! I was waiting for this course quite a long, since 2015. To be honest, I was expecting Sqlite for everyone, but this one even better! Come with working hours to Dubai!

Filter by:

1 - 25 of 214 Reviews for Database Design and Basic SQL in PostgreSQL

By Cleydyr A

•

Apr 12, 2021

Chuck is a very experienced teacher and his explanations are clear and he seems to really be passionate about what he's doing. That passion is contagious and the learner is likely to be eager to learn as well. The video classes are very illustrative and the pace is perfect for me. The quizzes always have to do with material covered in the classes and the exercises are as hands-on as it can be with PostgreSQL. That should be a good benchmark to what a MOOC and an instructor can be. Congratulations to Chuck and the University of Michigan.

By Ami O

•

Feb 13, 2022

boring, slow and very light weight. most can be covered in 1 hour of reading

By Olexander T

•

Jun 1, 2021

Dr. Chuck is the best! I was waiting for this course quite a long, since 2015. To be honest, I was expecting Sqlite for everyone, but this one even better! Come with working hours to Dubai!

By Raj G M

•

May 21, 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.

By Sagar

•

Aug 19, 2021

it really starts from the very basic design i felt like it is more for data engineer than data analytics person

By Glenn

•

May 8, 2021

Great learning. I only gave 4 stars because I feel the queries could have been introduced more gently. I had no issues as I already have some experience with SQL, but I can see how someone who comes into this course with zero knowledge of how to write SQL queries could struggle.

By Yogeshwar B

•

Feb 25, 2022

Hats off to the entire team behind Tsugi, the PG4E learner management system: this is a masterclass on how to conduct a MOOC. This course is helping me right now at work, trying to do database design for multiple projects (with no CS background 😎). It helped me evaluate PostgreSQL's development approach, and I am sold on the framework! I'm definitely going to continue the courses in the PostgreSQL For Everybody specialization 🚀

By Panagiotis T

•

Dec 27, 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!

By Shashwat D

•

Jul 6, 2021

Excellent course by Chuck Severance Sir

By Dimitris T

•

Oct 16, 2023

The videos and explanations are of great quality, although the first chapter is more of a history lesson than anything. In my opinion, the time needed to complete this course should be adjusted down and more exercises/material should be added, including some read operations from globally shared tables, which will probably be the main objective of a person using SQL anyway. Many assignments had 1h estimated time yet could be completed in 5 or so minutes...

By Carmela P

•

Jul 17, 2024

I finished this course in 4-6 hours with many breaks. I don't say that to brag but to give you an idea if you already have experience in MS SQL like I do. It's a good refresher course but I still learned a lot. I particularly like the brief lecture on the history. I liked it enough to go through the second course of the specialization also and maybe, MAYBE ... I will also do the 3rd and 4th course. I definitely like the instructor. His explanations were clear, and he made the class very interesting.

By Jonathan L

•

May 31, 2021

Really great course in understanding SQL and Relational Databases in the abstract. Charles Severence goes into detail about the history of Relational Databases and why and how they are used, and provides lots of knowledge around using the tools and best practices for them. Highly recommend along with his course Python for Everybody - which also touches on SQL (using SQLite).

By Miriam K

•

Nov 8, 2021

Excellent introduction. A passionate instructor who can clearly explain the important concepts. Nice balance between explaining theory and showing practical use. The exercises are quite easy but you can use the provided materials to practically explore the subject on your own which is nice. I will definitely continue with the entire specialization. Awesome course, thanks!

By Michael M

•

Aug 12, 2022

Dr. Charles is one of the best instructors out there. He is funny, makes you understand, shows his mistakes in the video, and gives you susubtle hints in the video to make sure you understand the material better. This course will give you just the basics of SQL for postgres, which is what we all need.

By Pedro L A L d M P

•

Jan 25, 2023

Spot-on paced, clear explanations with resonable level of abstraction, and self-contained. Really above the average of MOOCs. Assignments could have been more callenging, but I suspect they're going to get more challenging on the next courses of the specialization. So, overall a five star course.

By Mahdee M K

•

May 19, 2021

If you have done the python for everybody specialization, this course would be very easy for you. One to many relations, many to many relations, CRUD concepts were already taught there. I felt like I am watching the same video. Assignments were easy, so recommending this course.

By Orfeo F O

•

Jun 27, 2022

An excellent course to start in the knowledge of relational databases. I liked that theoretical aspects were touched on along with the data model and CRUD operations. I am looking forward to taking the other specialization courses and instructor Dr. Chuck. Thank you very much.

By Mário C

•

Apr 10, 2022

The instructor is great and his passion for the topic is palpable. I would have prefered a more simple and direct practice/grading method than the one used, but after setting everything up and figuring out how it works it is more than manageable and something useful to learn

By Daniel D

•

Apr 24, 2023

Dr Chuck is an awesome educator, personally, I believe you need a little background in SQL before taking this course. Using PSQL on Linux rather than PgAdmin might intimidate first-timers who are used to a graphical user interface. Great resource!

By John C F

•

May 31, 2021

This course is diffidently a 5 star, Dr. Chuck will explain the concept behind it. From the Quiz and Autograded assignment will challenge you on what you learn in this course. The references will also be given from pdf files to sample code.

By Bruce B

•

Oct 16, 2022

Dr. Chuck is a hoot! Course and instructor work well together. Getting used to a Command Line Interface (CLI) was daunting at first. Have to say, I enjoyed the work. Looking forward to the next course in this specialization. Cheers!

By Pastor S

•

Aug 18, 2022

One of the best courses in the platform in general, and one of the best course to learn Postgresql and database design. This course allow going from zero and if you already know some stuff will close a lot of gaps that you might have.

By Gabriele N

•

Jun 5, 2021

A wonderful introduction to PostreSQL and, more in general, to the beauty of SQL! Thank you so much Dr Chuck for another great course: new technologies and learning challenges become easy and even funny having you as professor.

By Roya P

•

May 7, 2023

I liked the talks about database design. I found the answer to many of my long-lasting and itching questions.

Thanks to the cool instructor and his team :-)

And thanks to the pythonanywhere team for their incredible services.

By Cristina M K

•

Sep 22, 2024

Amazingly clear explanations, and Dr. Chuck is a brillian communicator. Shoul I need further learning in informatics, I would probably look first whether there's a Dr. Chuck's or Michigan University's course for it.