PostgreSQL Fundamentals

This course offers a Foundational introduction to PostgreSQL, which is an open-source relational database management system. You will learn about the history of PostgreSQL, get an introduction to databases, and learn PostgreSQL fundamentals. You will also learn how to begin using PostgreSQL databases.

Intended audience

This course is intended for:

• Database administrators
• Database developers
• Database architects
• Database engineers

Course objectives

In this course, you will learn how to:

• Begin using PostgreSQL databases

Prerequisites

We recommend that attendees of this course have the following prerequisites:

• Familiarity with relational databases
• Familiarity with structured query language (SQL)

Delivery method

This course is delivered through

• Digital training

Duration

20 minutes

Course outline

This course covers the following concepts:

• PostgreSQL history
• PostgreSQL lineage
• Database 101
• Database 101 - Transactions
• Database 101 - Isolation
• PostgreSQL 101
• Features
• Database limitations
• PostgreSQL terminology