PostgreSQL for Everybody

Overview

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.

Syllabus

Course 1: Database Design and Basic SQL in PostgreSQL
Course 2: Intermediate PostgreSQL
Course 3: JSON and Natural Language Processing in PostgreSQL
Course 4: Database Architecture and NoSQL at Scale with Deno

Courses

1 review
16 hours 21 minutes
View details

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 to an online API and spidering its data and storing the data in a JSON column in PostgreSQL. Students will explore how full-text inverted indexes are structured. Students will build their own inverted indexes and then make use of PostgreSQL built-in capabilities to support full-text indexes.
0 reviews
16 hours 5 minutes
View details

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 parsing CSV files and inserting data into a database. You’ll also take a look at how PostgreSQL handles and indexes text data. Specifically, students will do assignments that alter table schemas, create stored procedures, construct advanced queries, explore sorting and grouping query data, and techniques for working with text in databases including regular expressions.
2 reviews
13 hours 34 minutes
View details

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 DELETE CASCADE, etc) will enable you to create tables, column types and define the schema of your data in PostgreSQL. You will learn about data modeling and how to represent one-to-many and many-to-many relationships in PostgreSQL. Students will do hands-on assignments creating tables, inserting data, designing data models, creating relational structures and inserting and querying relational data in tables.
0 reviews
10 hours 59 minutes
View details

In this final course of the PostgreSQL for Everybody specialization, you’ll explore how modern databases are built and scaled. You’ll begin by examining PostgreSQL’s architecture, including how it implements CRUD operations, indexing, transactions, and ACID (Atomicity, Consistency, Isolation, Durability) guarantees. Then you’ll shift to NoSQL systems using the Deno environment. You’ll learn how Deno implements a distributed Key-Value store and how it applies BASE (Basic Availability, Soft State, Eventual Consistency) principles. Through hands-on projects, you’ll deploy your own Deno KV service on Deno’s global infrastructure and build a Deno client to interact with it. By the end, you’ll understand the design tradeoffs between ACID and BASE databases and gain practical experience deploying and scaling both relational and NoSQL systems.