What you will 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.
- Design and implement data models using both one-to-many and many-to-many relationships within PostgreSQL.
- Learn about data indexes and query optimization for large scale data.
- Understand various SQL and NoSQL database architectures and how high-performance databases work in production environments.
Program Overview
Expert instruction
4 skill-building courses
Self-paced
Progress at your own speed
4 months
2 - 4 hours per week
Discounted price: $212.40
Pre-discounted price: $236USD
For the full program experience
Courses in this program
MichiganX's PostgreSQL for Everybody Professional Certificate
- Database Design and Basic SQL in PostgreSQL
- Intermediate PostgreSQL
- JSON and Natural Language Processing in PostgreSQL
- Database Architecture, Scale, and NoSQL with Elasticsearch
- Job Outlook
Meet your instructor from The University of Michigan (MichiganX)
Experts from MichiganX committed to teaching online learning
Enrolling Now
Discounted price: $212.40
Pre-discounted price: $236USD
4 courses in 4 months
Get started in computer science
Browse other computer science coursesWhether you are looking to accelerate your career, earn a degree, or learn something for personal reasons, edX has the courses for you.
Propelling
Drive your career forward with university-backed credit programs and verified certificatesConvenient
Study and demonstrate knowledge on your scheduleFlexible
Try a course before you paySupportive
Learn with university partners and peers from around the world