PostgreSQL Database Training Programs
This program covers PostgreSQL essentials including database setup, advanced SQL, indexing, performance tuning, and security. With a focus on open-source best practices, it equips participants to build and manage efficient PostgreSQL systems.
PostgreSQL Database Training Programs
This program covers PostgreSQL essentials including database setup, advanced SQL, indexing, performance tuning, and security. With a focus on open-source best practices, it equips participants to build and manage efficient PostgreSQL systems.
PostgreSQL Database Training Programs
This program covers PostgreSQL essentials including database setup, advanced SQL, indexing, performance tuning, and security. With a focus on open-source best practices, it equips participants to build and manage efficient PostgreSQL systems.
DB_PGS01
Introduction to PostgreSQL
3 days
Fundamental
Online/ In-Office
Querying Data
Querying Data
Querying Data
Common Table Expressions
Common Table Expressions
Common Table Expressions
Filtering Data
Filtering Data
Filtering Data
Modifying Data
Modifying Data
Modifying Data
Joining Multiple Tables
Joining Multiple Tables
Joining Multiple Tables
Transactions
Transactions
Transactions
Grouping Data
Grouping Data
Grouping Data
Managing Tables
Managing Tables
Managing Tables
Set Operations
Set Operations
Set Operations
PostgreSQL Constraints
PostgreSQL Constraints
PostgreSQL Constraints
Grouping sets, Cubes, and Rollups
Grouping sets, Cubes, and Rollups
Grouping sets, Cubes, and Rollups
PostgreSQL Data Types in Depth
PostgreSQL Data Types in Depth
PostgreSQL Data Types in Depth
Subquery
Subquery
Subquery
Conditional Expressions & Operators
Conditional Expressions & Operators
Conditional Expressions & Operators
DB_PGS02
PostgreSQL Database Developer
2 days
Mid
Online/ In-Office
Introduction to PostgreSQL for developers
Introduction to PostgreSQL for developers
Introduction to PostgreSQL for developers
Client tools
Client tools
Client tools
Transactions
Transactions
Transactions
SQL driver
SQL driver
SQL driver
Connectors
Connectors
Connectors
Functions (PL/pgSQL)
Functions (PL/pgSQL)
Functions (PL/pgSQL)
PSQL
PSQL
PSQL
Procedures
Procedures
Procedures
Database table, data types, index creation
Database table, data types, index creation
Database table, data types, index creation
Triggers
Triggers
Triggers
DB_PGS03
PostgreSQL Database Administration
5 days
Fundamental
Online/ In-Office
System Architecture
System Architecture
System Architecture
High Availability and Replication
High Availability and Replication
High Availability and Replication
Installation and Database Cluster
Installation and Database Cluster
Installation and Database Cluster
Data Dictionary
Data Dictionary
Data Dictionary
Configuration
Configuration
Configuration
Database Performance Monitor Operations
Database Performance Monitor Operations
Database Performance Monitor Operations
Database Creation and Management
Database Creation and Management
Database Creation and Management
Performance Improvement
Performance Improvement
Performance Improvement
DBA Tools-CUI and GUI
DBA Tools-CUI and GUI
DBA Tools-CUI and GUI
SQL Optimization
SQL Optimization
SQL Optimization
Security
Security
Security
Partitioning Partitioning
Partitioning Partitioning
Partitioning Partitioning
Backup, Recovery from Backup and PITR
Backup, Recovery from Backup and PITR
Backup, Recovery from Backup and PITR
PostgreSQL Management on Docker
PostgreSQL Management on Docker
PostgreSQL Management on Docker
Routine Maintenance Operations
Routine Maintenance Operations
Routine Maintenance Operations
DB_PGS04
PostgreSQL High Availability
2 days
Advanced
Online/ In-Office
PostgreSQL Replication
PostgreSQL Replication
PostgreSQL Replication
Pgpool
Pgpool
Pgpool
PostgreSQL Replication
PostgreSQL Replication
PostgreSQL Replication
Patroni Architecture
Patroni Architecture
Patroni Architecture
PostgreSQL Replication
PostgreSQL Replication
PostgreSQL Replication
Patroni, ETCD & HAProxy Installation and Configuration
Patroni, ETCD & HAProxy Installation and Configuration
Patroni, ETCD & HAProxy Installation and Configuration
PostgreSQL Replication
PostgreSQL Replication
PostgreSQL Replication
Patroni PostgreSQL switchover and Failover
Patroni PostgreSQL switchover and Failover
Patroni PostgreSQL switchover and Failover
Empower Your Skills with Expert Training
Want to learn more about our tailored training programs? Contact us to discover the right course for your needs. Our experts are here to guide you.
Empower Your Skills with Expert Training
Want to learn more about our tailored training programs? Contact us to discover the right course for your needs. Our experts are here to guide you.
Empower Your Skills with Expert Training
Want to learn more about our tailored training programs? Contact us to discover the right course for your needs. Our experts are here to guide you.
Smart data solutions for business growth and efficiency
Company
More content
Company
Services
Product
Vispeahen
BFM
BFM4Patroni
More content