University of Michigan
PostgreSQL for Everybody Specialization
University of Michigan

PostgreSQL for Everybody Specialization

SQL: From Basic to Advanced. Learn SQL skills you can use in an actual, real-world environment

31,433 already enrolled

Included with Coursera Plus

Get in-depth knowledge of a subject
4.7

(1,111 reviews)

Intermediate level

Recommended experience

1 month
at 10 hours a week
Flexible schedule
Learn at your own pace
Get in-depth knowledge of a subject
4.7

(1,111 reviews)

Intermediate level

Recommended experience

1 month
at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • 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

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English

See how employees at top companies are mastering in-demand skills

Placeholder

Advance your subject-matter expertise

  • Learn in-demand skills from university and industry experts
  • Master a subject or tool with hands-on projects
  • Develop a deep understanding of key concepts
  • Earn a career certificate from University of Michigan
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

Specialization - 4 course series

Database Design and Basic SQL in PostgreSQL

Course 113 hours4.8 (964 ratings)

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

Category: Database (DB) Design
Category: SQL
Category: Database (DBSM)

Intermediate PostgreSQL

Course 216 hours4.7 (299 ratings)

What you'll learn

  • Utilize SQL commands for editing tables in a PostgreSQL database and produce properly normalized tables from CSV files.

  • Appropriately handle text and dates in databases and create stored procedures.

  • Identify hashtag algorithm and their attributes.

  • Construct regular expressions to select rows that match a pattern.

Skills you'll gain

Category: SQL
Category: Database (DBSM)

JSON and Natural Language Processing in PostgreSQL

Course 316 hours4.6 (126 ratings)

What you'll learn

  • Compare Python, PostgreSQL, and JSON.

  • Index and retrieve natural language text and JSON data; access API data and store it in a database.

  • Create a GIN-based text[] reverse index and ts_vector index; build a search engine in PostgreSQL.

Skills you'll gain

Category: Json
Category: SQL
Category: Natural Language Processing
Category: Database (DBSM)

Database Architecture, Scale, and NoSQL with Elasticsearch

Course 410 hours4.3 (129 ratings)

What you'll learn

  • Understand PostgreSQL architecture; analyze and compare SQL and NoSQL

  • Compare and contrast ACID and BASE style architectures and databases

  • Create and utilize an Elasticsearch index in different contexts

Skills you'll gain

Category: Database Architecture
Category: SQL
Category: Database (DBSM)

Instructor

Charles Russell Severance
University of Michigan
60 Courses4,388,504 learners

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."

New to Mobile and Web Development? Start here.

Placeholder

Open new doors with Coursera Plus

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

Advance your career with an online degree

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

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

Upskill your employees to excel in the digital economy

Frequently asked questions