Database Optimization Courses and Certifications

Eloquent Performance Patterns

Learn advanced techniques to optimize Laravel app performance using Eloquent ORM. Covers database efficiency, memory usage, complex relationships, searching, and geospatial queries for real-world scenarios.

• Laracasts
• 2 hours 12 minutes
• Self-Paced
• Paid Course

Amazon Web Services;  Amazon

Building with Amazon Aurora Databases

Explore parallel query in Amazon Aurora, learning its benefits for large datasets, triggering situations, and impact on workload performance. Hands-on tasks included.

• AWS Skill Builder
• 1 hour
• Self-Paced
• Paid Course

PostgreSQL Tutorial for Beginners

Comprehensive PostgreSQL tutorial covering installation, basic to advanced queries, and data manipulation. Ideal for beginners and experienced developers seeking to master this powerful database system.

• freeCodeCamp
• 2-3 hours
• Self-Paced
• Free Video

Amazon Web Services;  Amazon

Empower Search with AI using Amazon OpenSearch Service

Leverage AI-driven search with Amazon OpenSearch Service. Master semantic and vector search, optimize vector databases, and implement neural sparse search for enhanced application discovery and insights.

• AWS Skill Builder
• 2 hours
• Self-Paced
• Free Certificate

Amazon Web Services;  Amazon

Amazon Redshift - Best Practices for Data Warehousing on AWS

Master data warehousing optimization techniques for Amazon Redshift, covering table design, query performance, workload management, and data modeling best practices to enhance database efficiency and performance.

• AWS Skill Builder
• 30 minutes
• Self-Paced
• Free Certificate

Amazon Web Services;  Amazon

Amazon Aurora PostgreSQL for Developers

Master Amazon Aurora PostgreSQL for developers, from SQL basics to advanced query optimization, monitoring, and best practices for building high-performance, scalable applications on AWS.

• AWS Skill Builder
• 4 hours 10 minutes
• Self-Paced
• Free Certificate

Credential

MongoDB Data Modeling Skills for Developers

Master MongoDB schema design patterns, optimization techniques, and transition from relational to document modeling for efficient database development.

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

Schema Design Optimization

Master MongoDB schema design patterns including single collection and bucket strategies to optimize performance and scale data models efficiently in sharded clusters.

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

Schema Design Patterns and Anti-patterns

Discover essential MongoDB schema design patterns like inheritance and computed patterns while avoiding common anti-patterns such as unbounded arrays for optimal performance.

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

MongoDB Indexes II

Dive into MongoDB's index internals and optimization techniques to dramatically boost your database query performance and efficiency.

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

MongoDB Indexes

Master MongoDB performance optimization through creating single, compound, and multikey indexes plus deletion techniques in this 2-hour hands-on tutorial.

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

PASS Data Community Summit

Query Tuning Techniques Every SQL Programmer Should Know

Learn essential query tuning techniques to optimize SQL performance, enhance database efficiency, and improve application responsiveness. Gain valuable insights from industry experts.

• YouTube
• 1 hour 35 minutes
• Self-Paced
• Conference Talk

Caleb Curry

Oracle SQL All-in-One Quick Start Tutorial Series

Comprehensive Oracle SQL tutorial covering essential concepts, syntax, and practical applications for database management and querying in just 4 hours.

• YouTube
• 4 hours 8 minutes
• Self-Paced
• Free Video

Hussein Nasser

Understanding Aggregate Functions Performance - The Backend Engineering Show

Explore aggregate function performance in databases, focusing on COUNT, AVG, and MAX. Learn about clustering, sequential and random writes, and optimization strategies for improved query efficiency.

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

CodeHelp - by Babbar

What Is Partitioning and Sharding in DBMS - DB Optimisation

Explore database optimization techniques including partitioning and sharding. Learn about scale-up methods, replica sets, and strategies for scaling out databases to improve performance and efficiency.

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