PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 35 years of active development on the core platform.
PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative solutions.
PostgreSQL runs on all major operating systems has been ACID -compliant since 2001, and has powerful add-ons such as the popular PostGIS.
Within the training, PostgreSQL optimized usage practices and competencies are explained in detail and reinforced with applied practices, starting from the basic level to the advanced levels, in a way that will be diversified and structured according to the participant levels.
Training progresses under the following main headings and topics;
- PostgreSQL data types, functions, operators
- Querry Logics
- Transactions
- Foreign Keys
- Window Functions
- JSON and XML
- Indexes
- View and Materialized View
- Recursive Querries
- Common Tables
- Grouping Sets
- Plpgsql
- Functions and Procedures
- Triggers
- PostgreSQL Addins
- pgLoader