University of Michigan
PostgreSQL for Everybody Specialization

Heat up your career with 40% off top courses from Google, Adobe, and more. Save today.

University of Michigan

PostgreSQL for Everybody Specialization

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

Charles Russell Severance

Instructor: Charles Russell Severance

36,038 already enrolled

Included with Coursera Plus

Learn more
Get in-depth knowledge of a subject
4.7

(1,226 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,226 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

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English

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

Learn more about Coursera for Business
logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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

Specialization - 4 course series

Database Design and Basic SQL in PostgreSQL

Database Design and Basic SQL in PostgreSQL

Course 113 hours

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: SQL
Category: PostgreSQL
Category: Database Design
Category: Relational Databases
Category: Database Management
Category: Data Integrity
Category: Data Modeling
Category: Database Theory
Category: Databases
Intermediate PostgreSQL

Intermediate PostgreSQL

Course 216 hours

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: PostgreSQL
Category: SQL
Category: Stored Procedure
Category: Database Design
Category: Query Languages
Category: Text Mining
Category: Transaction Processing
Category: Data Import/Export
Category: Data Manipulation
Category: Database Management
Category: Data Integrity
Category: Relational Databases
JSON and Natural Language Processing in PostgreSQL

JSON and Natural Language Processing in PostgreSQL

Course 316 hours

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: PostgreSQL
Category: SQL
Category: Natural Language Processing
Category: JSON
Category: Python Programming
Category: Application Programming Interface (API)
Category: Data Storage
Category: Databases
Category: Database Management
Category: Text Mining
Category: Data Processing
Database Architecture, Scale, and NoSQL with Elasticsearch

Database Architecture, Scale, and NoSQL with Elasticsearch

Course 410 hours

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: NoSQL
Category: Database Architecture and Administration
Category: Relational Databases
Category: Scalability
Category: Cloud Applications
Category: Database Design
Category: Database Management Systems
Category: JSON
Category: Databases
Category: SQL
Category: PostgreSQL

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

Charles Russell Severance
University of Michigan
60 Courses4,601,443 learners

Offered by

University of Michigan

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

Open new doors with Coursera Plus

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

Learn more

Advance your career with an online degree

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

Explore degrees

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

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

More questions

Financial aid available,