When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Database Design and Basic SQL in PostgreSQL

Database Design and Basic SQL in PostgreSQL

This course is part of PostgreSQL for Everybody Specialization

Instructor: Charles Russell Severance

65,911 already enrolled

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

1,120 reviews

Intermediate level

Recommended experience

Flexible schedule

1 week at 10 hours a week

Learn at your own pace

94%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

1,120 reviews

Intermediate level

Recommended experience

Flexible schedule

1 week at 10 hours a week

Learn at your own pace

94%

Most learners liked this course

What you'll learn

Utilize psql and SQL commands to implement CRUD (Create, Read, Update, and Delete) operations for tables in a PostgreSQL database.
Identify and utilize the functions of primary, logical, and foreign keys within a database.
Build and differentiate between one-to-many and many-to-many relationships within PostgreSQL.
Recall key people, organizations, and innovations that were instrumental to building the SQL standard

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 assignments

Taught in English

91%

of learners achieved a positive career outcome

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the PostgreSQL for Everybody Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 4 modules in this 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.

Module details

In this first week, you will hear more about the goals of this course. You'll learn about the people and organizations instrumental to building the SQL standard, learn to differentiate between relational databases and flat files, and utilize psql and SQL commands to create, read, update, and delete tables in a PostgreSQL database.

What's included

8 videos6 readings1 assignment5 app items

8 videosTotal 66 minutes

Welcome to PostgreSQL!8 minutes
History of Relational Databases20 minutes
Bonus Video: Elizabeth Fong and SQL Standards8 minutes
SQL Architecture13 minutes
Using PythonAnywhere to Run SQL10 minutes
Using the DBeaver Client to Run SQL Commands7 minutes
Dr. Chuck Goes Racing - Joliet, Illinois, USA1 minute
Office Hours - London (Very close to PythonAnywhere)1 minute

6 readingsTotal 50 minutes

Help Us Learn More About You5 minutes
Syllabus10 minutes
Elizabeth Fong and SQL Standards10 minutes
Assessment Philosophy5 minutes
How Assignments Work10 minutes
Connecting to Your Database Server10 minutes

1 assignmentTotal 10 minutes

Introductory SQL10 minutes

5 app itemsTotal 255 minutes

Initial Database Setup30 minutes
Making Our First Tables45 minutes
Inserting Some Data into a Table60 minutes
A Class Photo Gallery60 minutes
A Map of Student Locations60 minutes

This week, you'll learn to recall and utilize common psql commands, create a database using command line prompts, and utilize common SQL commands, including INSERT INTO, WHERE, and ORDER BY.

What's included

6 videos1 assignment2 app items

6 videosTotal 51 minutes

Working with Tables and PostgreSQL13 minutes
Data Types in PostgreSQL9 minutes
Database Keys and Indexes in PostgreSQL12 minutes
Musical Track Database (CSV)7 minutes
Dr. Chuck Sings the Blues in Geneva, Switzerland (Near CERN)6 minutes
Office Hours - Kyoto, Japan4 minutes

1 assignmentTotal 15 minutes

Single Table SQL15 minutes

2 app itemsTotal 120 minutes

SERIAL fields / Auto Increment60 minutes
Musical Track Database (CSV)60 minutes

This week focuses on relational database design and one-to-many data models. You'll also learn the functions of primary, logical, and foreign keys within a database, and how to reconnect rows with corresponding data in a table.

What's included

9 videos1 assignment1 app item

9 videosTotal 65 minutes

Relational Database Design Part 18 minutes
Relational Database Design Part 27 minutes
Keys7 minutes
Database Normalization6 minutes
Building Tables7 minutes
Inserting Data4 minutes
Using JOIN Across Tables12 minutes
Office Hours at Bletchley Park, Milton Keynes, England9 minutes
Office Hours, Philadelphia, Pennsylvania, USA4 minutes

1 assignmentTotal 10 minutes

One to Many Data Models10 minutes

1 app itemTotal 60 minutes

Entering Many-to-One Data - Automobiles60 minutes

The final week in this course focuses on many-to-many data models. You'll soon be able to differentiate between one-to-many and many-to-many relationships, and as well as normalize and insert data items into a connected set of many-to-many tables.

What's included

5 videos1 reading1 assignment1 app item

5 videosTotal 38 minutes

Many-to-Many Relationships15 minutes
Demonstration: Database Design and Many to Many15 minutes
Up Next - Beyond CRUD (Create, Read, Update, Delete) and JOIN2 minutes
Office Hours - Capetown, South Africa3 minutes
Office Hours - Raleigh, North Carolina, USA3 minutes

1 readingTotal 5 minutes

Post-Course Survey5 minutes

1 assignmentTotal 10 minutes

Many-to-Many Data Models10 minutes

1 app itemTotal 60 minutes

Building a Many-to-Many Roster60 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(292 ratings)

Charles Russell Severance

University of Michigan

60 Courses4,884,291 learners

Offered by

University of Michigan

Learner reviews

5 stars
85.80%
4 stars
10.53%
3 stars
1.69%
2 stars
0.80%
1 star
1.16%

Showing 3 of 1120

Reviewed on 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!

Reviewed on Feb 19, 2023

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

Reviewed on Nov 29, 2022

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

View more reviews