DB-201
Database Optimization
Cost: $200
Duration: 1
Day
Skill Level: Advanced
How We Conduct Training :
Online :
Google Meet or Zoom
In-Person :
O&B Headquarters (3F Carlos J. Valdes Building, 108 Aguirre, Legazpi Village, Makati City)
Client's premises (Private sessions available with a minimum number of participants)
Course Overview
Database performance problems are often impossible to catch through manual testing during development, or even in the first few months of production.
They usually manifest themselves only one or more years after the end of a project, when the original developers have moved on and any warranties have expired.
These often lead to serious financial and reputational damage to businesses, and finding and fixing problems can take weeks if not months.
Learning Outcomes
This course covers common database performance problems and how to avoid them.
Suitable For
Developers seeking to avoid database performance problems
Course Outline
Database Optimization
- Profiling & Replication
- Types of Data Stores
- Understanding Query Plans
- Indexing
- Queries
- Denormalization
- Deadlocks
- Application
- Archiving & Partitioning
- Reclaiming Storage & Gathering Statistics
- Write Ahead Log (WAL) Tuning
- Backup & Replication
Software and Hardware Requirements
Software
- Docker or Docker Desktop
- PostgreSQL version 18 or higher
- pgAdmin 4 (for GUI administration)
EXCLUSIVE TRAINING FOR YOU COMPANY
AT YOUR PREFERRED SCHEDULE
Tailored to the needs of your organization, we also offer cadetship
programs which include a series of our standardized O&B Academy courses.
Get a quote