The Art of PostgreSQL
INTERACTIVE COURSE

The Art of PostgreSQL

Advanced

205 Lessons

65h

Certificate of Completion

AI Explanations
AI Explanations
The Art of PostgreSQL
186 Playgrounds
13 Quizzes
127 Illustrations

Takeaway Skills

An understanding of PostgreSQL and its applications in managing databases with CRUD operations

Familiarity with the core components of PostgreSQL, such as SQL, REPL, Window functions, and data modeling

Hands-on experience in using SQL queries with PostgreSQL and its extensions

The ability to write and integrate SQL queries into your workflow, enabling efficient data retrieval and manipulation

Course Overview

PostgreSQL is a popular and widely used open-source relational database management system. It has gained significant market share in recent years due to its robust features, high performance, and ease of use. Many companies, from small startups to large enterprises, are adopting PostgreSQL as their primary database system, making it a sought-after skill for developers. You will learn PostgreSQL with numerous code examples using different approaches. This course will enable you to seamlessly integrate SQL ...Show More

Course Content

1

Part I: Preface

2

Introduction to PostgreSQL

3

Part II: Introduction to Structured Query Language

4

Part III: Writing SQL Queries

5

Business Logic

6

A Small Application

5 Lessons

7

The SQL REPL: An Interactive Setup

8 Lessons

8

Indexing in PostgreSQL

4 Lessons

9

Part IV: SQL Toolbox

1 Lesson

10

SQL Tools

4 Lessons

11

Managing Output in SQL

9 Lessons

12

Understanding Nulls

6 Lessons

13

Window Functions

3 Lessons

14

Relations and Joins

3 Lessons

15

Part V: Data Types

1 Lesson

16

Serialization and Deserialization

6 Lessons

17

PostgreSQL Data Types 101

12 Lessons

18

Denormalized Data Types

9 Lessons

19

Part VI: Data Modeling

1 Lesson

20

Object Relational Mapping and Tooling for Database Modeling

5 Lessons

21

Normalization

5 Lessons

22

Practical Use Case: Geonames

9 Lessons

23

Modelization Anti-Patterns

4 Lessons

24

Denormalization

10 Lessons

25

Not Only SQL

5 Lessons

26

Part VII: Data Manipulation and Concurrency Control

1 Lesson

27

Another Small Application

6 Lessons

28

Isolation and Locking

5 Lessons

29

Computing and Caching in SQL

6 Lessons

30

Triggers

4 Lessons

31

Listen and Notify

4 Lessons

32

Batch Update, MoMA Collection

4 Lessons

33

Part VIII: PostgreSQL Extensions

1 Lesson

34

What’s a PostgreSQL Extension?

3 Lessons

35

Auditing Changes with hstore

5 Lessons

36

Million Song Dataset

2 Lessons

37

Using Trigrams for Typos

6 Lessons

38

Denormalizing Tags with intarray

3 Lessons

39

The Most Popular Pub Names

5 Lessons

40

Geolocation with PostgreSQL

6 Lessons

41

Counting Distinct Users with HyperLogLog

6 Lessons

42

Appendix

3 Lessons

COURSE AUTHOR

How You'll Learn

Hands-on Coding Environments

You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.

2x Faster Learning — With No Setup

Videos are holding you back. Educative‘s interactive, text-based lessons accelerate learning — no setup, downloads, or alt-tabbing required.

AI-Powered Learning

Learn faster and smarter with adaptive AI tools embedded in every Educative course.

Progress You Can Show

Built-in assessments let you test your skills. Completion certificates let you show them off.

Recommended Courses

BEFORE STARTING THIS COURSE

AFTER FINISHING THIS COURSE

FOR TEAMS

Interested in this course for your business or team?

Unlock this course (and 1,000+ more) for your entire org with DevPath