TOP Courses on Postgresql databases

Database programming: with PostgreSQL DBMS and SQL language: theory and practice with data analysis. All the knowledge that you will gain in the course is easily applicable to other DBMSs, such as MySQL, Microsoft SQL Server, Oracle.

In this course you will learn the fundamentals of relational databases. You will learn more about DBMS architecture and the SQL language. As a result, you will learn how to create tables, add, modify and delete data.

Practical course on working with PostgreSQL DBMS. We will learn how to build replications, work with backups and organize monitoring of the entire system. The course program is based on real-life tasks of operations teams.

This is a course in which, based on popular databases, we will explore the basic syntax of the structured query language - SQL

The course is intended for developers of applications and SQL queries for Postgresql, it will also be useful for database server administrators, heads of IT departments, due to the fact that many specific examples of building and expanding postgres servers on enterprise. At the end of the course, a coherent picture is built - what Postgresql is, how to manage a database server, its performance, and expanded functionality.

Advanced training program. The course teaches the SQL query language and the procedural programming language PL/pgSQL of the PostgreSQL DBMS. During the course, students will master creating queries, commands for changing data, creating PL/pgSQL blocks, using cursors, triggers, creating functions and other program objects in PL/pgSQL and SQL.

The course includes all the tools that may be useful for both developers and administrators: management access, backup, replication, logging, working with statistics, ways to work with large volumes data.