Database Optimization Courses and Certifications

Hussein Nasser

Clustered Collections Makes Mongo Faster but There Is a Cost

Explore MongoDB's clustered collections feature, its benefits for read/write performance, and associated limitations. Learn how it compares to original collections and impacts database efficiency.

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

Strange Loop Conference

Modern B-Tree Techniques

Explore advanced B-Tree techniques in databases and file systems, covering efficiency improvements, new functionalities, and hardware adaptations. Learn about PostgreSQL implementations and other database applications.

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

PyCon US

Let's Talk Databases in Python - SQLAlchemy and Alembic

Explore SQLAlchemy and Alembic for efficient database management in Python, covering ORMs, migrations, connection pools, and performance optimization techniques.

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

International PHP Conference

Bottleneck Analysis in Web Applications - Full-Stack Profiling Techniques

Comprehensive full-stack analysis of web application request delivery, covering browser profiling, server behavior, PHP application analysis, caching, and database bottlenecks.

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

tutorialsEU

IEnumerable and IEnumerator Interfaces in C#

Explore IEnumerable and IEnumerator interfaces in C#, their advantages, use cases, and relationship to collections. Learn implementation techniques for efficient data iteration and management.

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

PASS Data Community Summit

Index Fragmentation - Internals, Analysis, and Solutions

Explore index fragmentation in SQL Server, covering internal structures, analysis techniques, and practical solutions for optimizing database performance and query efficiency.

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

PASS Data Community Summit

How to Use DMVs to Diagnose Performance Issues

Discover how to leverage Dynamic Management Views (DMVs) for effective SQL Server performance diagnostics and troubleshooting with expert Glenn Berry.

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

PASS Data Community Summit

SQL Server Index Internals - A Deep Dive

Explore SQL Server index internals, uncovering optimization techniques and performance insights for database professionals seeking advanced knowledge.

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

Caleb Curry

SQL All-in-One Tutorial Series - 13 Hours

Comprehensive SQL tutorial covering database fundamentals, querying, data manipulation, and advanced concepts for beginners to experienced developers. Enhance your data management skills.

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

ByteGrad

8 Prisma Pro Tips Every Prisma Developer Should Know

Master 8 crucial Prisma optimization techniques including Accelerate, Pulse, schema management, and performance tips to enhance your database interactions and development workflow.

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

Customize an Indexing Policy in Azure Cosmos DB SQL API

Optimize Azure Cosmos DB SQL API indexing policies for read-heavy and write-heavy workloads. Learn to customize and tune index usage for improved performance in various scenarios.

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

Optimizing Autovacuum - PostgreSQL's Vacuum Cleaner

Learn to optimize PostgreSQL's autovacuum for efficient database maintenance. Understand its workings, troubleshoot issues, and implement effective solutions to prevent bloat in production environments.

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

NDC Conferences

Why Databases Cry at Night

Explore NoSQL database performance, examining common features' impact and inherent bottlenecks to understand why databases struggle and how to optimize them.

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

Red Hat

Tuning Red Hat Enterprise Linux for Databases

Optimize database performance on Red Hat Enterprise Linux with expert tuning techniques for bare metal and virtual machines, covering IO, memory, storage, and monitoring tools.

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

Oracle

Oracle Live - MySQL Database Service New HeatWave Innovations

Explore powerful innovations in MySQL Database Service HeatWave, enhancing automation, performance, and workload acceleration. Learn about new features and hear from industry users.

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