返回到 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.

状态:Database Theory
状态:Relational Databases
中级课程小时

精选评论

WW

4.0评论日期:Nov 29, 2022

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

TA

4.0评论日期: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.0评论日期: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.0评论日期: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.0评论日期: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.0评论日期: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.0评论日期: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.0评论日期: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.0评论日期: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.0评论日期: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.0评论日期: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.0评论日期: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.

所有审阅

显示:20/248

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