PostgreSQL Database Administrator DBA

U1: Introduction to the PostgreSQL DBA course

→ Installing PotsgreSQL on Windows
→ Entering PgAdmin4 and PSQL Shell
→ Installing PotsgreSQL on Linux

U2: PostgreSQL Architecture

→ PostgreSQL Architecture and Theoretical Limits
→ Starting the PostgreSQL server engine
→ Connect to different versions of PostgreSQL Server

U3: Creating databases in PostgreSQL

→ Creating databases in PostgreSQL
→ Parameters for creating databases in PostgreSQL

U4: Database Architecture in PostgreSQL

→ Tables in PostgreSQL
→ Definition and organization of Schemas in PostgreSQL
→ Index Management in PostgreSQL

U5: Functions in PostgreSQL

→ Create SQL-like functions in PostgreSQL
→ Create functions in procedural language in PostgreSQL
→ Flow control in PostgreSQL procedural language
→ Practice - Creating functions in procedural language
→ Continued - Creating functions in procedural language
→ Multiple functions in PostgreSQL

U6: Procedures in PostgreSQL

→ Using stored procedures in PostgreSQL
→ Creating Procedures in Procedural Language in PostgreSQL
→ Practice - Creating procedures in PostgreSQL
→ Continued - Creating procedures in PostgreSQL

U7: Using triggers

→ Using triggers in PostgreSQL
→ Practice - Creating triggers in PostgreSQL
→ Practice - Update triggers in PostgreSQL

U8: Managing Views in PostgreSQL

→ Using Views in PostgreSQL
→ Practice - Using views in PostgreSQL
→ Practice - Using materialized views in PostgreSQL

U9: Index Management in PostgreSQL

→ Using Indexes in PostgreSQL
→ Working with index types in PostgreSQL
→ Unique indexes and indexes with expressions in PostgreSQL
→ Partial indexes, reindexing and multicolumn indexes

U10: PostgreSQL Administration

→ Introduction to Administration in PostgreSQL
→ Managing Databases in PostgreSQL
→ Schema Management
→ Search path in Schemes
→ Tablespace Management
→ Managing Roles and Privileges - Part 1
→ Managing Roles and Privileges - Part 2
→ Assigning role privileges in PostgreSQL
→ Revoking role privileges in PostgreSQL - Part 1
→ Revoking role privileges in PostgreSQL - Part 2
→ Modifying role attributes
→ Delete roles in PostgreSQL
→ Members of a role
→ Some useful commands with roles
→ Backups with PgAdmin
→ Install tools to make backups
→ Using pg_dump to perform backups
→ Using pg_restore to recover backups
→ Practice - Copy and restore in PostgreSQL

Course evaluation

This course contains a final exam

G-Tools: For Students

→ Exclusive access to cutting-edge student tools: improve your employability, participate in exclusive events, take advantage of our intelligent virtual assistant, and more.

⚑ Certificate of completion

→ Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.