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.
PostgreSQL for Everybody Specialization
Discover new skills with 30% off courses from industry experts. Save now.
PostgreSQL for Everybody Specialization
SQL: From Basic to Advanced. Learn SQL skills you can use in an actual, real-world environment
Instructor: Charles Russell Severance
37,978 already enrolled
Included with 
Get in-depth knowledge of a subject
(1,248 reviews)
Intermediate level
Recommended experience
1 month at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers
Get in-depth knowledge of a subject
(1,248 reviews)
Intermediate level
Recommended experience
1 month at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers
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
Overview
Skills you'll gain
What’s included
Shareable certificate
Add to your LinkedIn profile
Taught in English
11 practice exercises
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
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: Relational Databases
Category: Database Design
Category: Database Management
Category: Data Integrity
Category: Databases
Category: Database Theory
Category: Data Modeling
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: Data Import/Export
Category: Data Manipulation
Category: Text Mining
Category: Query Languages
Category: Transaction Processing
Category: Relational Databases
Category: Database Management
Category: Data Integrity
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: Natural Language Processing
Category: SQL
Category: JSON
Category: Python Programming
Category: Data Storage
Category: Application Programming Interface (API)
Category: Data Processing
Category: Databases
Category: Database Management
Category: Text Mining
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: Scalability
Category: Cloud Applications
Category: Relational Databases
Category: Database Design
Category: Database Management Systems
Category: PostgreSQL
Category: SQL
Category: JSON
Category: Databases
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
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."
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
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
Each of the four courses in this Specialization contains four weeks' worth of content.
You should have completed the first two courses in the Python for Everybody specialization or have an equivalent basic understanding of Python.
University credit is not available for completing this Specialization.
More questions
Financial aid available,