DB-201

Database Optimization Training

Cost: $100
Duration: 0.5
 Day
 Skill Level: Advanced

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.
  • Write well-structured code using Object Oriented Principles (OOP).

Suitable For

Developers seeking to avoid database performance problems

Course Outline

Course Outline

Database Optimization

  • Profiling & Replication
  • Indexing
  • Queries
  • Schema
  • Deadlocks
  • Application Calls
  • Archiving
  • Partitioning
  • Reclaiming Storage
  • Gathering Statistics

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