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
In this course you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON -
Learn moreIntermediate PostgreSQL
|
4 weeks
This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and -
Learn moreJSON and Natural Language Processing in PostgreSQL
|
4 weeks
Within this course, you’ll learn about how PostgreSQL creates and uses inverted indexes for JSON and natural language content. We will use various sources of data for our databases, including access t -
Learn moreDatabase Architecture, Scale, and NoSQL with Elasticsearch
|
4 weeks
In this final course, you will explore database architecture, PostgreSQL, and various scalable deployment configurations. You will see how PostgreSQL implements basic CRUD operations and indexes, and