Courses with lecturer

Term

Language

Place

Form

Price without VAT

19. - 20. 12. 2024

Language

Place

online

Form

virtual classroom

Code of the course: KT21010082-0021

Price without VAT

13 000 Kč

Order

6. - 7. 2. 2025

Language

Place

online

Form

virtual classroom

Code of the course: KT21010082-0022

Price without VAT

13 000 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010082-0004

Price without VAT

13 000 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010082-0005

Price without VAT

13 000 Kč

Order

Target audience

PostgreSQL database system administrators who want to deepen their knowledge of advanced topics, especially in the field of large, high-availability solutions.

Course content

Database performance measurement - Importance of benchmarking, key query performance measurement: Profiler, recommendations for identifying locking and blocking
Optimization of physical database design - performance optimization model, schema optimization strategy: keys, schema optimization strategy: responsible denormalization, schema optimization strategy: generalization
Query optimization for performance - performance optimization model: queries, what is the logical flow of the query, decisions about the use of subqueries, best practices for building effective queries
Query Optimization - Recommendations for correct query writing. Acceleration of existing indices. JOIN optimization. Fast data synchronization using the MERGE operator.
Index strategy optimization - performance optimization model: indexes, index usage decisions
Management of competing operations - performance optimization model: locking and blocking problems, presentations on the use of effective queries to reduce locking and blocking, locking and blocking reduction strategies, DEADLOCKS
Application processing optimization - Minimize blocking and deadlocks. Transaction optimization. Recommendations from practice.

Materials

Materials are in electronic form.

Objectives

Understand the architecture of the database system
Perform installation and implementation of the database system
Tune performance
Break up tables into sections for optimization
Understand the possibilities of high availability
Understand the replication process
Monitor the database system
Use procedural language
Use extension tools
Use and manage conection pooling

Do you want this tailor-made course for your company?

News with the course

Database 7. 4. 2021

Database systems trainings

Database systems are a great potential for today's companies. There are many database products on the market that compete on performance, reliability, scalability, and many other factors. In the field of databases, we offer courses in PostgreSQL, MongoDB, MySQL.

More news