Database Design and Basic SQL in PostgreSQL

Seize the savings! Get 40% off 3 months of Coursera Plus and full access to thousands of courses.

Database Design and Basic SQL in PostgreSQL

This course is part of PostgreSQL for Everybody Specialization

Instructor: Charles Russell Severance

63,726 already enrolled

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

1,111 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,111 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

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.

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 videos Total 66 minutes

Welcome to PostgreSQL! 8 minutes
History of Relational Databases 20 minutes
Bonus Video: Elizabeth Fong and SQL Standards 8 minutes
SQL Architecture 13 minutes
Using PythonAnywhere to Run SQL 10 minutes
Using the DBeaver Client to Run SQL Commands 7 minutes
Dr. Chuck Goes Racing - Joliet, Illinois, USA 1 minute
Office Hours - London (Very close to PythonAnywhere) 1 minute

6 readings Total 50 minutes

Help Us Learn More About You 5 minutes
Syllabus 10 minutes
Elizabeth Fong and SQL Standards 10 minutes
Assessment Philosophy 5 minutes
How Assignments Work 10 minutes
Connecting to Your Database Server 10 minutes

1 assignment Total 10 minutes

Introductory SQL 10 minutes

5 app items Total 255 minutes

Initial Database Setup 30 minutes
Making Our First Tables 45 minutes
Inserting Some Data into a Table 60 minutes
A Class Photo Gallery 60 minutes
A Map of Student Locations 60 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 videos Total 51 minutes

Working with Tables and PostgreSQL 13 minutes
Data Types in PostgreSQL 9 minutes
Database Keys and Indexes in PostgreSQL 12 minutes
Musical Track Database (CSV) 7 minutes
Dr. Chuck Sings the Blues in Geneva, Switzerland (Near CERN) 6 minutes
Office Hours - Kyoto, Japan 4 minutes

1 assignment Total 15 minutes

Single Table SQL 15 minutes

2 app items Total 120 minutes

SERIAL fields / Auto Increment 60 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 videos Total 65 minutes

Relational Database Design Part 1 8 minutes
Relational Database Design Part 2 7 minutes
Keys 7 minutes
Database Normalization 6 minutes
Building Tables 7 minutes
Inserting Data 4 minutes
Using JOIN Across Tables 12 minutes
Office Hours at Bletchley Park, Milton Keynes, England 9 minutes
Office Hours, Philadelphia, Pennsylvania, USA 4 minutes

1 assignment Total 10 minutes

One to Many Data Models 10 minutes

1 app item Total 60 minutes

Entering Many-to-One Data - Automobiles 60 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 videos Total 38 minutes

Many-to-Many Relationships 15 minutes
Demonstration: Database Design and Many to Many 15 minutes
Up Next - Beyond CRUD (Create, Read, Update, Delete) and JOIN 2 minutes
Office Hours - Capetown, South Africa 3 minutes
Office Hours - Raleigh, North Carolina, USA 3 minutes

1 reading Total 5 minutes

Post-Course Survey 5 minutes

1 assignment Total 10 minutes

Many-to-Many Data Models 10 minutes

1 app item Total 60 minutes

Building a Many-to-Many Roster 60 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

(291 ratings)

Charles Russell Severance

University of Michigan

60 Courses 4,820,701 learners

Offered by

University of Michigan

Explore more from Software Development

Status: Free Trial
EDUCBA
Master PostgreSQL Database Design and SQL Fundamentals
Course
Status: Free Trial
EDUCBA
Apply PostgreSQL Fundamentals for Data Management
Course
Status: Free Trial
University of Michigan
Intermediate PostgreSQL
Course
Status: Free Trial
EDUCBA
Apply PostgreSQL for Data Analysis and Database Design
Specialization

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
85.95%
4 stars
10.44%
3 stars
1.71%
2 stars
0.72%
1 star
1.17%

Showing 3 of 1111

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

View more reviews

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

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.

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.

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.