• 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

Objective

For solid management and maintenance of a database and applications to happen, in-depth basic knowledge is necessary. The DBA Standard training focuses on introducing the basics and best practices. A few of the important topics that are being dealt with during the program are configuring entry and safety, optimising performance, implementing backup and restore procedures, combined with other key aspects of an optimal performance of 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)

Different environments ask for different approaches. That is why OptimaData provides custom-fit trainings for companies, too. This is a training that is either tailored to your wishes or consists of a combination of our different training offers. There are many possibilities! Would you like to apply for a custom-fit training or do you want to know more about the possibilities? Don’t hesitate to contact us!

Contact us!