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

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

167 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 Cloud Skills Boost
• 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

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

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

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

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

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

Presto Foundation

Demystifying Expression Evaluation in Presto C++ - Vectorized Database Optimization

Dive into advanced expression evaluation techniques in Velox, exploring vectorized execution optimizations, dictionary operations, and sophisticated fuzz testing frameworks for enhanced database performance.

• YouTube
• 28 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

AI Interviews: System Performance and Security

Master system performance optimization and security through AI interview practice, covering load balancing, monitoring, database optimization, authentication, and vulnerability assessment techniques.

• CodeSignal
• On-Demand
• Free Certificate

Amazon Web Services;  Amazon

Travailler avec des index dans DynamoDB (Français) | Working with Indexes in DynamoDB (French)

Découvrez les requêtes, analyses et index secondaires de DynamoDB pour optimiser l'accès aux données. Apprenez à concevoir des index efficaces adaptés à vos besoins spécifiques.

• AWS Skill Builder
• 2-3 hours
• On-Demand
• Free Certificate