SQL-201

Database Optimization Training

Download as PDF
Enquire Now

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

Advanced

Suitable For

Developers seeking to avoid database performance problems

Duration

0.5

 day

Related Topics

Enquire Now
SQL-201

Database Optimization Training

Download as PDF
Enquire Now

Skill Level

Advanced

Suitable For

Developers seeking to avoid database performance problems

Duration

0.5

 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