Courses

Nowadays, lots of businesses opt for the public Cloud with PostgreSQL as a managed service, which relieves them of certain tasks such as operating systems, patching, backup and recovery procedures. Even if PostgreSQL is administered by a public Cloud provider, it is essential to understand basic tuning concepts and techniques. If you want to get a basic understanding of PostgreSQL, from architecture to monitoring, psql command lines to graphical interfaces, data loading and unloading to performance tuning, the PostgreSQL Training for DevOps is for you.

Duration

2 day(s)

Price

1800 CHF

Do you want to start developing an application on PostgreSQL, or do you already develop on PostgreSQL and want to avoid common errors? Be sure not to miss out on our PostgreSQL training for developers. At the end of the course, you will understand what PostgreSQL can do for you from a development perspective. Topics range from basic concepts such as data types and permissions to more advanced topics such as PL/pgSQL, partitioning and working with JSON.

Duration

2 day(s)

Price

1800 CHF

Optimizing PostgreSQL database performance is a broad topic that can open up a lot of different questions. For example, how do I configure my PostgreSQL instance? What indexes should I create, and what are the best tools for monitoring my PostgreSQL instance’s performance? During our PostgreSQL Performance Tuning Training, our experts will share their knowledge, working methods and tools with you. Through various practical exercises and demonstrations, you will understand how the PostgreSQL optimizer works and learn how to get the most out of it.

Duration

2 day(s)

Price

1800 CHF

Do you have PostgreSQL databases in your IT environment and want to learn database administration best practices to get the most out of PostgreSQL? If you want to know more about backup and recovery strategies for PostgreSQL, then our PostgreSQL DBA training is for you. At the end of this course, you will be familiar with PostgreSQL architecture, DBA best practices for PostgreSQL and the various high availability options. You will also be able to set up a standby database and know how to run backups safely.

Duration

2 day(s)

Price

1800 CHF

Migration to PostgreSQL is a topical issue and many companies are considering making the change. Through various hands-on exercises and live demonstrations, you will understand how PostgreSQL differs from other databases and what tools are available to simplify migration. During PostgreSQL migration training, you will also learn what solutions (workarounds) you can implement if you are dependent on a specific feature of your source database that is not available in PostgreSQL or that is implemented in another way.

Duration

2 day(s)

Price

1800 CHF