Database Optimization Courses and Certifications

PASS Data Community Summit

Performance Optimization with Azure SQL Database

Discover built-in Azure tools for identifying and resolving database performance issues, enhancing customer experience and streamlining troubleshooting processes.

• YouTube
• 58 minutes
• Self-Paced
• Conference Talk

Qdrant - Vector Database & Search Engine

Binary Quantization Methods for Vector Database Optimization

Dive into vector database optimization through binary quantization, exploring compression techniques, search speed improvements, and practical implementation strategies for efficient vector similarity search.

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

Mastering SQL using Postgresql

263 ratings at Udemy

Learn key SQL concepts such as how to create database objects, write effective queries and many more

• Udemy
• 9 hours 24 minutes
• Self-Paced
• Paid Course

PostgreSQL Bootcamp : Complete Beginner to Advanced Course

240 ratings at Udemy

Learn PostgreSQL Database, PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin4

• Udemy
• 5 hours 41 minutes
• Self-Paced
• Paid Course

SQL Optimization with SingleStore

194 ratings at Udemy

Architecture, Performance, and Workload Optimization

• Udemy
• 2 hours 27 minutes
• Self-Paced
• Paid Course

CMU Database Group

Query Optimization Part 1 - CMU Intro to Database Systems - 15

Discover query optimization fundamentals including cost estimation, plan enumeration, and optimization techniques to improve database performance and efficiency.

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

CMU Database Group

Query Optimization Part 2 - CMU Intro to Database Systems - 16

Dive into advanced query optimization techniques including cost-based optimization, join algorithms, and performance tuning strategies for database systems.

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

Building a High-Performance Time Series Database from Scratch - Optimization Strategies

Explore optimization strategies for high-performance time series databases, including string interning, caching, goroutine management, and efficient resource allocation using sync.Pool.

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

Paul G. Allen School

Deep Reinforcement Learning for Query Optimization in Database Systems

Exploring deep reinforcement learning approaches to improve database query optimization, enhancing performance and reducing maintenance burden in database management systems.

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

CMU Database Group

Query Cost Models and Statistics in Database Optimization - Lecture 12

Dive into advanced database query optimization techniques, focusing on cost models and statistical approaches for efficient query processing and performance tuning.

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

CMU Database Group

Unnesting Queries in Database Query Optimization - Lecture 11

Dive into advanced database query optimization techniques, focusing on unnesting strategies and their implementation for improved query performance in database management systems.

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

CMU Database Group

Query Plan Transformations in Database Query Optimization - Lecture 6

Dive into advanced query plan transformation techniques and optimization strategies for database systems, exploring methods to enhance query performance and execution efficiency.

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

CMU Database Group

Query Planning and Optimization in Database Systems - Lecture 15

Dive into advanced database concepts focusing on query planning strategies, optimization techniques, and execution methods for improved database system performance.

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

Master IMS database optimization through advanced tuning techniques, buffer pool management, access method selection, and performance analysis for enhanced system efficiency.

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

Master advanced IMS database design by implementing logical relationships, coding DBDs and PSBs, using utilities for reorganization, and tuning performance based on Monitor reports.

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