Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

University of Michigan

PostgreSQL for Everybody

University of Michigan via edX Professional Certificate

Overview

Learn how to use the PostgreSQL open-source relational database management system (RDBMS) in order to explore topics ranging from database design to database architecture and deployment. Explore the benefits that PostgreSQL provides over other solutions, such as MySQL, when dealing with large datasets. These four specialized classes cover JSON, NoSQL, natural language processing, and more. The skills gained in these courses are useful for anyone interested in data mining, application development, or machine learning.

Syllabus

Courses under this program:
Course 1: Database Design and Basic SQL in PostgreSQL

This first course in PostgreSQL for Everybody explores the use of SQL in the PostgreSQL environment and introduces SQL techniques and commands. This course also explores data modeling and database relationships, while introducing hands-on assignments to work within PostgreSQL.



Course 2: Intermediate PostgreSQL

This second course in PostgreSQL for Everybody explores a wide range of SQL techniques to aggregate and transact data in PostgreSQL.This course also explores handling, reading, and parsing data with PostgreSQL and working with text in databases with regular expressions.



Course 3: JSON and Natural Language Processing in PostgreSQL

In this third course in PostgreSQL for Everybody, learners will learn how PostgreSQL creates and uses JSON and natural language content. Learners will explore using multiple sources of data and how text is structured within PostgreSQL.



Course 4: Database Architecture, Scale, and NoSQL with Elasticsearch

In this fourth and final course in PostgreSQL for Everybody, learners will explore database architectures, CRUD operations and how ACID requirements are implemented in PostgreSQL. Learners will compare how to scale SQL and NoSQL database services and build NoSQL applications using ElasticSearch.



Courses

Taught by

Charles Severance

Reviews

Start your review of PostgreSQL for Everybody

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.