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

MariaDB Galera Cluster

Database

Open Source

Do you have MariaDB databases in your IT infrastructure and plan to upgrade to a high-availability solution with the Galera cluster? If you want to make the most of the Galera cluster and learn the relevant best practices, then this course is for you. Upon completion of the MariaDB Galera Cluster Training, you will be able to administer a MariaDB/Galera cluster and safely perform backups and recoveries. Finally, you will learn how to use Maxscale for load balancing and tackle high-availability advanced features.

Duration

2 day(s)

Price

1800 CHF

Linux for DBAs

Microsoft

Open Source

Oracle

OS

Red Hat

SUSE

As a database administrator (DBA), you must know the operating system on which the database is installed (Linux, Unix, etc.). This course covers all the essential Linux concepts and distributions (Red Hat, SUSE, Oracle Enterprise Linux, etc.) you need to know to operate your database without any hassle. You will gain plenty of practical experience during this workshop as it includes many hands-on exercises.

Duration

2 day(s)

Price

1800 CHF

Oracle Application Express (APEX) for Developers

Application Servers

Database

Oracle

If you have basic knowledge of Oracle development tools (PL/SQL) and want to do web-development on Oracle Application Express (APEX), then the Oracle Application Express Training for Developers is for you. Upon completion of this course, you will be able to use Oracle APEX to build applications for your organization that will allow you to manage data capture and reporting. This course will also cover the implementation of external resources (email and print server) and web services, as well as best practices throughout the application development life cycle on Oracle APEX.

Duration

3 day(s)

Price

2700 CHF

Oracle APEX Administration

Application Servers

Database

Oracle

APEX is a free web application development tool provided with the Oracle database. It allows database administrators and PL/SQL developers to create modern web applications quickly and easily. As with its development, administrating this tool requires specific knowledge to use it to your best advantage. During this training course, you will learn to support the development team and make the most out of your APEX setup.

Duration

2 day(s)

Price

1800 CHF

Docker and Kubernetes Essential Skills

DevOps

Open Source

If you want to know more about Docker and Kubernetes and get an insight into container orchestration with Kubernetes (and how easy it is to deploy applications), then our training will meet your needs.

We will use the example of an application as a common thread along this workshop. From the early stages of containerization to the final deployment, you will learn what Docker containers are and how Kubernetes orchestrates containers. At the end of this Docker and Kubernetes training, you will be able to build and run your own Docker container and deploy your applications in a Kubernetes cluster.

Duration

3 day(s)

Price

2700 CHF

Migration to PostgreSQL

Database

Open Source

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

Oracle Performance Tuning

Database

Oracle

Do you want to learn how to optimize an Oracle database, configure an Oracle instance, know which Oracle indexes to create or discover the best performance monitoring tools for an Oracle database? Our instructors will teach you how to optimize an Oracle database and share best practices. During the Oracle Performance Tuning Training, you will have the opportunity to put your learning into practice by setting up a standby database.

Duration

3 day(s)

Price

2700 CHF

Microsoft Windows PowerShell

Database

Microsoft

Do you want to know about the best practices for implementing the Microsoft PowerShell online command interface and script language? By the end of this course, you will have acquired all the skills and tools a system administrator needs daily. You will also master PowerShell architecture and language basics, as well as good development practices. Implementing and fully administrating remote servers via PowerShell is also discussed during this training.

Duration

2 day(s)

Price

1800 CHF

Microsoft SQL Server Performance Tuning

Database

Microsoft

Is SQL Server performance troubleshooting a skill you would like to develop? Do your users complain about slow service and you don’t know where to start due to lack of knowledge? Our Microsoft SQL Server Performance Tuning Training will provide you with the required know-how. At the end of this course, you will master the key skills for tuning and troubleshooting on SQL Server to improve your Microsoft infrastructures’ performance.

Duration

3 day(s)

Price

2700 CHF