We may earn an affiliate commission when you visit our partners.

PostgreSQL for Everybody

Across these four courses, you’ll learn how to use the PostgreSQL database and explore topics ranging from database design to database architecture and deployment. You’ll also compare and contrast SQL and NoSQL approaches to database design. The skills in this course will be useful to learners doing data mining or application development.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

Help others find Specialization from Coursera by sharing it with your friends and followers:

Facebook

Copy Link

What's inside

Four courses

Database Design and Basic SQL in PostgreSQL

In this course, you will explore database design and SQL in PostgreSQL. You will learn about data modeling, creating tables, inserting data, and designing relational structures. By the end of the course, you will be able to insert and query relational data in tables.

View more details for this course

Intermediate PostgreSQL

This course covers advanced SQL techniques in PostgreSQL, including aggregation, transactions, CSV handling, and text indexing. Students will alter table schemas, create stored procedures, construct advanced queries, and explore sorting, grouping, and text manipulation using regular expressions.

View more details for this course

JSON and Natural Language Processing in PostgreSQL

Within this course, you’ll learn about how PostgreSQL creates and uses inverted indexes for JSON and natural language content. We will use various sources of data for our databases, including access to an online API and spidering its data and storing the data in a JSON column in PostgreSQL.

View more details for this course

Database Architecture, Scale, and NoSQL with Elasticsearch

In this concluding course, you will explore database architecture, PostgreSQL, and various scalable deployment configurations. You will learn to use Elasticsearch NoSQL, a common NoSQL database that supplements relational databases for high-speed search and indexing.

View more details for this course

Learning objectives

How to use the postgresql database effectively
Explore database design principles

Dive into database architecture and deployment strategies
Compare and contrast sql and nosql database design approaches and acquire skills applicable to data mining and application development

How to use the postgresql database effectively
Explore database design principles
Dive into database architecture and deployment strategies
Compare and contrast sql and nosql database design approaches and acquire skills applicable to data mining and application development

Save this collection

Save PostgreSQL for Everybody to your list so you can find it easily later:

Save

Time

0 hours

Level

Intermediate

Via

Coursera

Institution

University of Michigan

Instructor

Charles Russell Severance

Level

Intermediate

Share Specialization from Coursera

Facebook

Link

Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.