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
Database Design and Basic SQL in PostgreSQL
This course is part of PostgreSQL for Everybody Specialization
Instructor: Charles Russell Severance
Access provided by Kiron Open Higher Education
63,666 already enrolled
Gain insight into a topic and learn the fundamentals.
1,110 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
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
(291 ratings)Offered by
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 1110
TA
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!
VD
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...
WW
Reviewed on Nov 29, 2022
Overall good course. I had to locate some GitHub and W3schools SQL references to assist programming assignments.
