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).
Course Outline
Database Optimization
- Profiling & Replication
- Indexing
- Queries
- Schema
- Deadlocks
- Application Calls
- Archiving
- Partitioning
- Reclaiming Storage
- Gathering Statistics
Skill Level
Suitable For
Developers seeking to avoid database performance problems
Duration
day
Related Topics
Skill Level
Suitable For
Developers seeking to avoid database performance problems
Duration
day
Related Topics
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).
Course Outline
Database Optimization
- Profiling & Replication
- Indexing
- Queries
- Schema
- Deadlocks
- Application Calls
- Archiving
- Partitioning
- Reclaiming Storage
- Gathering Statistics