PostgreSQL Essentials

Sign in to track your progress and continue where you left off.

52 Topics

1

What is PostgreSQL?

5 min Quiz

2

Installing PostgreSQL

5 min

3

Connecting with psql

5 min

4

Creating Databases

4 min

5

Data Types

6 min Quiz

6

CREATE TABLE

6 min Quiz

7

INSERT INTO

5 min

8

SELECT Queries

5 min Quiz

9

WHERE Clause

5 min Quiz

10

ORDER BY and LIMIT

4 min

11

UPDATE and DELETE

5 min

12

Aggregate Functions

5 min Quiz

13

GROUP BY and HAVING

6 min Quiz

14

JOINs

7 min Quiz

15

Subqueries

6 min

16

CTEs (WITH Clause)

6 min Quiz

17

Window Functions

7 min Quiz

18

Indexes

6 min

19

Transactions

6 min Quiz

20

Foreign Keys

5 min

21

Views

5 min

22

Stored Functions

6 min

23

Triggers

7 min

24

JSONB Columns

6 min Quiz

25

Full Text Search

7 min

26

EXPLAIN and Performance

6 min

27

Partitioning

7 min

28

Roles and Privileges

6 min

29

Backup and Restore

5 min

30

Connection Pooling

6 min

31

pg_stat_statements

5 min

32

Materialized Views

6 min

33

Lateral Joins

6 min

34

UPSERT (INSERT ON CONFLICT)

5 min Quiz

35

Array Operations

5 min

36

Date and Time Functions

5 min

37

String Functions

5 min

38

Recursive CTEs

7 min

39

Constraints Advanced

7 min

40

Row Level Security

7 min

41

Replication Basics

7 min

42

Extensions

5 min

43

PostgreSQL with Node.js

6 min

44

PostgreSQL with Python

5 min

45

Vacuum and Maintenance

6 min

46

Schema Design Patterns

6 min

47

Lateral Subqueries

5 min

48

pg_cron Scheduling

5 min

49

Logical Replication

7 min

50

Query Optimization Tips

6 min

51

PostgreSQL Security Hardening

6 min

52

TimescaleDB for Time-Series

7 min