Database Optimization Courses and Certifications

CMU Database Group

OtterTune: AI-Powered Database Optimization as a Service

Explore AI-powered database optimization with OtterTune, revolutionizing performance tuning through machine learning and automation.

• YouTube
• 1 hour 7 minutes
• On-Demand
• Free Video

Conf42

Enhancing a Distributed SQL Database Engine - Performance Optimization Techniques

Explore optimization techniques for distributed SQL databases, focusing on benchmarking, performance analysis, and containerization strategies to enhance engine efficiency and scalability.

• YouTube
• 38 minutes
• On-Demand
• Free Video

NashKnolX

Database Optimization Techniques

Master key strategies for enhancing database performance through query optimization, indexing, and efficient storage to reduce latency and ensure scalability.

• YouTube
• 46 minutes
• On-Demand
• Free Video

Database Management Final Part (5): Indexing,B Trees,B+Trees

201 ratings at Udemy

Learn Indexing in Database Management Systems with no prerequisites

• Udemy
• 14 hours 28 minutes
• On-Demand
• Paid Course

Accelerating Analytical Queries using the AlloyDB Columnar Engine

In this lab you will explore features of the AlloyDB Columnar Engine.

• Google Skills
• 1-2 hours
• On-Demand
• Paid Course

Hussein Nasser

Table Clustering in MySQL and Postgres - The Pros and Cons

Explore database clustering in MySQL and Postgres, including benefits, drawbacks, and implementation across popular databases. Learn about this crucial feature for optimizing data organization and retrieval.

• YouTube
• 28 minutes
• On-Demand
• 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
• On-Demand
• Free Video

Database Parameter Auto-Tuning Through CI/CD Pipelines

Learn how Yahoo Japan automates MySQL parameter tuning using machine learning in CI/CD pipelines, addressing challenges in cloud computing and improving database performance.

• YouTube
• 25 minutes
• On-Demand
• Free Video

From Insanity to Ingenuity: Seven Practical Tips for Navigating the AI Storm in DBaaS Evolution

Explore AI's impact on DBaaS evolution with seven practical tips. Learn about LLMs, data quality, storage management, and innovative trends shaping the future of cloud-native databases and developer workflows.

• YouTube
• 38 minutes
• On-Demand
• Free Video

PASS Data Community Summit

Query Optimizer Deep Dive

Dive into SQL Server's query optimizer internals, execution plans, and performance tuning techniques with expert Paul White in this comprehensive deep-dive session.

• YouTube
• 2 hours 35 minutes
• On-Demand
• Free Video

PyCon Israel

Advanced Database Indexing Techniques for Backend Performance

Master advanced database indexing techniques to optimize performance and efficiency, turning your backend into a high-performing powerhouse.

• YouTube
• 33 minutes
• On-Demand
• Free Video

SQLBits

Should We Defragment Indexes? - A Deep Dive into Modern Disk Architecture and I/O Performance

Explore modern disk architecture and I/O dynamics to understand when index defragmentation may hinder performance, challenging conventional practices.

• YouTube
• 19 minutes
• On-Demand
• Free Video

DSDSD - Dutch Seminar on Data Systems Design

LingoDB: An Open Compilation and Optimization Framework for Sustainable Data Processing

Discover how LingoDB's open-source framework enables efficient data processing through flexible architecture, cross-domain optimizations, and seamless adaptation to modern hardware capabilities.

• YouTube
• 27 minutes
• On-Demand
• Free Video

CMU Database Group

Query Cost Models: More Cardinality Estimation - Lecture 14

Delve into advanced cardinality estimation techniques for query cost models with Professor Andy Pavlo, exploring key concepts and methodologies for database query optimization.

• YouTube
• 1 hour 12 minutes
• On-Demand
• Free Video

SQL for Database Administrators

Gain the database skills you need to become a confident, high-earning SQL DBA. Learn how to create, grow, and manage your PostgreSQL database.

• DataCamp
• 16 hours
• On-Demand
• Free Trial Available