Database training

• Trainings for every level of knowledge and experience
• Strong combination of theory and practice
• Up-to-date course material
• Directly applicable in practice
• Experienced and practice-oriented trainers
• High ratings
• OptimaData certification

Tailored training

Every environment is different. OptimaData therefore also provides (corporate) training on a customized basis. A database training specific to your needs or a combination of our training offerings. Much is possible. For example, we can also provide a workshop on Galera Cluster or specifically PostgreSQL on Kubernetes with a Kubernetes operator such as CloudNativePG. But also the use of cloud databases and the efficient use of (cloud) resources without exponential cloud costs. If you would like to request a customized training or more information about the possibilities, please contact us.

Objective

Proper management and maintenance of the database and associated applications requires a sound basic knowledge. The DBA Standard training course focuses on introducing the basic principles and best practices. Important topics covered in this training include configuring access and security, optimizing performance, implementing backup and restore procedures and other crucial aspects for optimal deployment of the databases and applications.

Target audience

Database Administrators with some experience in relational database management systems.

Different platforms

The training is available for PostgreSQL, PostgresPURE, MariaDB, MySQL, Microsoft SQL Server, and MongoDB.

A selection of the topics

• An introduction;
• Architecture in general;
• Installing and configuring;
• Securing a database environment;
• Analysing and optimising the database performance;
• Monitoring a database environment;
• Making a back-up and restoring it.

Duration

4 days

Costs

€2.200,- (ex. VAT, incl. necessary materials and catering)

Objective

During the training, a participant will get to know more in-depth aspects of database management, such as the finesses of database performance and tuning, integration with other systems, query optimisation, locking problems, and advanced clustering. Additionally, the database will be compared to other database systems, such as Oracle.

Target audience

The program is open to DBAs who have completed the DBA Standard training as well as DBAs who have several years of experience with database environments.

Different platforms

The training is available for PostgreSQL, PostgresPURE, MariaDB, MySQL, Microsoft SQL Server, and MongoDB.

Content

Topics that will be dealt with, are:

• Architecture in general;
• Database performance tuning;
• Setting up complex database configurations;
• Optimal and maximum availability;
• Comparison to other databases and integration.

Duration

3 days

Costs

€1,650,- (ex. VAT, incl. necessary materials and catering)

Objective

The Developer Training aims to provide participants with skills and knowledge to enable them to work with databases as software developer.

Target audience

This training requires knowledge of – and experience with – the use of relational databases as software developer.

Different platforms

The training is available for PostgreSQL, PostgresPURE, MariaDB, MySQL, Microsoft SQL Server, and MongoDB.

Content

Topics that will be dealt with, are:

• Architecture in general;
• The use and numerous possibilities of the Data Definition Language (DDL);
• The use and various possibilities of the Data Manipulation Language (DML), such as SQL and PL/pgSQL.

Duration

4 days

Costs

€2.200,- (ex. VAT, incl. necessary materials and catering)