PostgreSQL Database Engineering

This professional PostgreSQL Database Engineering program takes learners through PostgreSQL Architecture, Advanced SQL, Indexes and Query Planning, Transactions and Locking, JSONB and Full Text, Partitioning and Replication, Roles and Security, Production Operations. Target audience: Engineers operating reliable PostgreSQL systems at scale.

Jane Instructor8 chapters32 hoursCertificate included

What you'll learn

Apply postgresql architecture to a practical PostgreSQL Database Engineering project.

Apply advanced sql to a practical PostgreSQL Database Engineering project.

Apply indexes and query planning to a practical PostgreSQL Database Engineering project.

Apply transactions and locking to a practical PostgreSQL Database Engineering project.

Apply jsonb and full text to a practical PostgreSQL Database Engineering project.

Apply partitioning and replication to a practical PostgreSQL Database Engineering project.

Skills covered

PostgreSQL

SQL

JSONB

Query Tuning

Replication

Database Security

Prerequisites

SQL joins and relational design

Who this is for

Engineers operating reliable PostgreSQL systems at scale.

Course modules

1PostgreSQL ArchitectureFree preview

2Advanced SQLFree preview

3Indexes and Query Planning

4Transactions and Locking

5JSONB and Full Text

6Partitioning and Replication

7Roles and Security

8Production Operations

Assessments and certification

PostgreSQL Database Engineering Practice Quiz

8 questions · 20 min · Pass mark 70%

Quiz

PostgreSQL Database Engineering Certification Exam

8 questions · 60 min · Pass mark 70%

Final exam

Earn your AMNEXT ACADEMY certificate

Complete the course and pass its certification assessment to receive a verifiable certificate.