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 Design and Basic SQL in PostgreSQL
Ends in 5 days! Save 40% on your access to 10,000+ programs and make a real impact in your career. Save now.
Database Design and Basic SQL in PostgreSQL
This course is part of PostgreSQL for Everybody Specialization
Instructor: Charles Russell Severance
67,027 already enrolled
Included with Learn more
Gain insight into a topic and learn the fundamentals.
1,124 reviews
Intermediate level
Recommended experience
Flexible schedule
1 week at 10 hours a week
Learn at your own pace
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
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
4 assignments
Taught in English
94%
Most learners liked this course
See how employees at top companies are mastering in-demand skills
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
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)Offered by
Explore more from Software Development
Status: Free Trial
Status: Free Trial
Status: Free TrialUniversity of Michigan
Status: Free Trial
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.67%
- 4 stars
10.58%
- 3 stars
1.69%
- 2 stars
0.88%
- 1 star
1.15%
Showing 3 of 1124
EY
Reviewed on Jul 6, 2024
Python for Everybody usage is too useless. It makes the learning process more complicated, unnecessarily. Despite this, other things are perfect.
AA
Reviewed on 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
Reviewed on Nov 6, 2025
Excellent Teacher, thanks sir, you definitely giving a vibe of a actual class rather than just a "knowledge transfer" course.
