Database Optimization Courses and Certifications

Packt

Fundamentals of Oracle Database Performance Tuning

Diagnose and fix Oracle database bottlenecks using time models, instance activity statistics, wait events, AWR snapshots and baselines, Statspack reports, ADDM, and server-generated alerts.

• Coursera
• 12 weeks, 1 hour a week
• Self-Paced
• Paid Course

Coursera

Optimize Your Database with Indexes

Profile relational database operations and design indexes that speed them up, learning what indexes are and when they improve performance.

• Coursera
• 1 hour 48 minutes
• Self-Paced
• Paid Course

Packt Career Certificate

The Oracle Database Performance Tuning Course

Tune Oracle databases: diagnose wait events and CPU bottlenecks with AWR, ASH, and SQL tracing, then optimize SQL, indexes, disk I/O, buffer cache, and PGA.

• Coursera
• 4 weeks, 10 hours a week
• Self-Paced
• Paid Course
• 3 courses

Packt

Comprehensive Tuning and Optimization for Oracle Databases

Diagnose and fix Oracle database performance bottlenecks: CPU and disk I/O tuning, index maintenance, table compression, In-Memory Column Store, SQL Performance Analyzer, and Database Replay.

• Coursera
• 12 weeks, 1 hour a week
• Self-Paced
• Paid Course

Coursera

Optimize SQL Queries: Uncover Performance Bottlenecks

Analyze SQL execution plans to diagnose slow queries, then apply query restructuring, indexing, and performance monitoring to keep data warehouses fast and scalable.

• Coursera
• 2 weeks, 1 hour a week
• Self-Paced
• Paid Course

Coursera

Optimize Query Performance for Data Success

Analyze query performance metrics, interpret execution plans, pinpoint bottlenecks, and allocate database resources to sustain efficiency and service levels in production systems.

• Coursera
• 2 weeks, 1 hour a week
• Self-Paced
• Paid Course

Edureka

Columnar Storage and Query Optimization

Understand why queries are slow: compare row-based and columnar storage, work with Parquet, ORC and DuckDB, read EXPLAIN plans, and apply pruning, pushdown and partitioning.

• Coursera
• 5 weeks, 2 hours a week
• Self-Paced
• Paid Course

Analyzes IMS performance data and tunes VSAM/OSAM access methods, database buffer pools, storage attributes, and secondary indexes.

• IBM Training
• 36 hours
• Self-Paced
• Free Online Course

Performance Tools and Techniques

Tune MongoDB performance: profile slow queries, monitor system resources, and optimize indexes, cache utilization, and hardware configuration for efficiency at scale.

• MongoDB University
• 1 hour
• Self-Paced
• Free Certificate

Query Optimization

Fine-tune MongoDB queries for maximum efficiency, minimizing execution time and avoiding slow queries.

• MongoDB University
• 2 hours
• Self-Paced
• Free Certificate

Optimize query performance in Azure SQL

Analyze individual query performance and determine where improvements can be made. Explore performance-related Dynamic Management Objects. Investigate how indexes and database design affect queries.

• Microsoft Learn
• 3 hours 56 minutes
• Self-Paced
• Free Online Course

Monitor and optimize operational resources in Azure SQL

Configure hardware and server resources for optimum performance after establishing a baseline. Identify sources of performance problems. Troubleshoot using Azure SQL Intelligent Insights.

• Microsoft Learn
• 2 hours 49 minutes
• Self-Paced
• Free Online Course

Hussein Nasser

Understanding Aggregate Functions Performance - The Backend Engineering Show

Explains why COUNT, AVG, and MAX behave differently under indexing, clustering, and row versus column storage, affecting database performance.

• YouTube
• 23 minutes
• Self-Paced
• Free Video

Hussein Nasser

Bloat in Databases

Discover how database bloat impacts performance and learn techniques to identify, prevent, and resolve storage inefficiencies in your database systems.

• YouTube
• 13 minutes
• Self-Paced
• Free Video

Intelligent Database Futures in Azure SQL and SQL Server 2022 - Data Exposed Live

Examines adaptive query processing in SQL Server 2022 and Azure SQL, including parameter-sensitive plans, memory grant feedback, cardinality estimation, and parallelism.

• YouTube
• 1 hour 2 minutes
• Self-Paced
• Free Video