PostgreSQL for Everybody
Description
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.
-
Subject
-
Language
English
-
Duration
16 weeks
-
Status
Available
-
U-M Credit Eligible
No
Technology
Instructor
-
Charles Severance
Clinical Professor, School of Information
School of Information
Courses (4)
-
Learn moreDatabase Design and Basic SQL in PostgreSQL
|
4 weeks
Create relational database models using PostgreSQL, practicing data modeling, SQL commands, and schema creation through hands-on exercises. -
Learn moreIntermediate PostgreSQL
|
4 weeks
Enhance your PostgreSQL skills with advanced queries, stored procedures, text search, and data import from CSVs. -
Learn moreJSON and Natural Language Processing in PostgreSQL
|
4 weeks
Explore how PostgreSQL handles full-text search, JSON data, and inverted indexing for advanced natural language processing. -
Learn moreDatabase Architecture and NoSQL at Scale with Deno
|
4 weeks
Compare ACID and BASE databases, explore PostgreSQL performance, and implement NoSQL search capabilities with Elasticsearch.