PostgreSQL for DevOps

Database

DevOps

Open Source

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

Power BI Essential Skills

BI / Big Data

Microsoft

Would you like to familiarize yourself with Microsoft Power BI administration? In addition to theory, our course offers various workshops focusing on Power BI tests, virtual machines for deploying a Power BI test environment and Power BI reports and data sources. Upon completion of the Power BI Essential Skills Training, you will be able to independently install, configure and maintain a Power BI architecture. Installing and managing a Power BI infrastructure are topics included in this course.

Duration

3 day(s)

Price

2700 CHF

PostgreSQL for Developers

Database

Open Source

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

PostgreSQL Performance Tuning

Database

Open Source

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

PostgreSQL DBA Essential

Database

Open Source

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

Oracle Database Appliance (ODA)

Database

Oracle

This training summarizes the years of experience our instructors have accumulated using the Oracle Database Appliance (ODA). Our experts will show you how to take advantage of this single-box database to achieve maximum performance and flexibility. Upon completion of this course, participants will have a solid understanding of ODA architecture’s key concepts. If ODA hardware is available for hands-on exercises, the training can be extended to three days.

Duration

3 day(s)

Price

2700 CHF