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
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
Included with 
Get in-depth knowledge of a subject
(1,260 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,260 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
SQL, PostgreSQL, Relational Databases, Database Design, Data Integrity, Database Management, Data Modeling, Database Theory, and Databases
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
PostgreSQL, SQL, Stored Procedure, Database Design, Transaction Processing, Text Mining, Data Import/Export, Data Manipulation, Data Integrity, Query Languages, Relational Databases, and Database Management
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
PostgreSQL, Natural Language Processing, SQL, JSON, Python Programming, Data Storage, Databases, Database Management, Data Processing, Application Programming Interface (API), and 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
NoSQL, Database Architecture and Administration, Cloud Applications, Scalability, Relational Databases, Databases, Database Systems, Database Design, Data Store, SQL, PostgreSQL, Distributed Computing, and JSON
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
Compare with similar products
| Rating | ||||
|---|---|---|---|---|
| Level | ||||
| Skills | ||||
| Tools | ||||
| Last updated | ||||
| Number of practice exercises | ||||
| Degree eligibility | ||||
| Part of Coursera Plus |
You might also like
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,