Clinical Professor, School of Information
29 Learning Experiences
PostgreSQL for Everybody
What You'll Learn
- How to use the PostgreSQL database effectively
- Dive into database architecture and deployment strategies
- Explore database design principles
- Compare and contrast SQL and NoSQL database design approaches and acquire skills applicable to data mining and application development
4-Course Series
57 hours
15 hours per course (approx.)
Shareable Certificate
Add to your LinkedIn profile
About 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.
Skills You'll Gain
- Natural Language Processing (NLP)
- Database Design
- Data Management
- JSON
- PostgreSQL
- NoSQL
- SQL (Programming Language)
- PL/pgSQL
- Database Architecture
What You'll Earn
- Certificate of Completion
- Certificates of completion acknowledge knowledge acquired upon completion of a non-credit course or program.
Course content developed by U-M faculty and managed by the university. Faculty titles and affiliations are updated periodically.
Intermediate Level
Completion of the first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python.
Series Video
4 Courses in this series
-
Free U-M Access CourseDatabase Design and Basic SQL in PostgreSQL
Create relational database models using PostgreSQL, practicing data modeling, SQL commands, and schema creation through hands-on exercises.
-
Free U-M Access CourseIntermediate PostgreSQL
Enhance your PostgreSQL skills with advanced queries, stored procedures, text search, and data import from CSVs.
-
Free U-M Access CourseJSON and Natural Language Processing in PostgreSQL
Explore how PostgreSQL handles full-text search, JSON data, and inverted indexing for advanced natural language processing.
-
Free U-M Access CourseDatabase Architecture and NoSQL at Scale with Deno
Compare ACID and BASE databases, explore PostgreSQL performance, and implement NoSQL search capabilities with Deno.
What Learners Are Saying
As I build online teaching and learning applications, the SQL part is almost the most creative part. I mean others are better at designing pretty user interfaces but for me the SQL is where the essence of applications and performance comes from. And so there's just way…
Charles "Dr. Chuck" Severance PhD, Clinical Professor of Information, School of Information
