OLTP Courses and Certifications

InfoQ

Redesigning OLTP for a New Order of Magnitude - Database Performance and Scalability

Explore how TigerBeetle addresses OLTP challenges, examining impedance mismatch, workload contention, storage faults, and non-determinism in modern database systems.

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

Herramientas de la Inteligencia de Negocios

246 ratings

Aprende el proceso de extraer y transformar data para generar insumos y tomar decisiones. Usa software, herramientas y sistemas de apoyo.

• edX
• 5 weeks, 5-6 hours/week
• Self-Paced
• Free Online Course (Audit)

• Best of All Time

Understanding Storage I/O Under Load - Exploring Disks and Managing IO Workloads

Explore disk management and IO workloads with a new approach, focusing on SSD capabilities, mixed workloads, and scheduler algorithms for optimized performance.

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

ByteGrad

The Ultimate Next.js Dashboard Stack - Shadcn, WebSocket/SSE, OLTP/OLAP Database

Master building powerful analytics dashboards with Next.js using Shadcn UI, WebSocket/SSE for real-time updates, and OLTP/OLAP databases including DuckDB and Hydra integration.

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

Database Design

57 ratings at DataCamp

Learn to design databases in SQL to process, store, and organize data in a more efficient way.

• DataCamp
• 4 hours
• Self-Paced
• Free Trial Available

Data Warehousing Concepts

29 ratings at DataCamp

This introductory and conceptual course will help you understand the fundamentals of data warehousing.

• DataCamp
• 4 hours
• Self-Paced
• Free Trial Available

CMU Database Group

Aurora DSQL - Serverless, Scalable, Global OLTP Database System

Discover Aurora DSQL's serverless architecture and global scalability for OLTP workloads in this technical deep-dive by Marc Brooker from the CMU Database Group seminar series.

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

USENIX

OLTP SQL Database Query Tracing and Linting

Explore SQL database query tracing and linting techniques for effective incident handling and data migration operations in OLTP systems.

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

Databricks

Race to Real-Time - Low-Latency Streaming ETL With Next-Gen OLTP-DB

Discover how to build low-latency streaming ETL pipelines achieving sub-2 second end-to-end processing using Apache Spark Structured Streaming and next-gen OLTP databases for real-time insights.

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

PASS Data Community Summit

In-Memory OLTP in SQL Server - Overview and Architecture

Dive into SQL Server's In-Memory OLTP architecture, exploring memory optimization, native compilation, and lock-free concurrency control for enhanced database performance.

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

PASS Data Community Summit

In-Memory OLTP Internals - Understanding the 30x Performance Boost in SQL Server Hekaton

Discover how SQL Server Hekaton's in-memory architecture revolutionizes data management, offering unprecedented performance boosts through optimized memory storage and innovative checkpoint mechanisms.

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

PASS Data Community Summit

The Ambiguous Case of Off Row Storage in In-Memory OLTP

Dive into the complexities of off-row storage mechanisms in In-Memory OLTP, exploring implementation strategies and performance implications for SQL Server databases.

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

CMU Database Group

HorizonDB - Co-Designing PostgreSQL and Azure for Cloud-Native OLTP

Discover how HorizonDB co-designs PostgreSQL and Azure for cloud-native OLTP workloads, exploring innovative database architecture and cloud integration strategies.

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

USENIX

Bridging the Gap between Relational OLTP and Graph-based OLAP

Explore GART, an innovative system bridging relational OLTP and graph-based OLAP, offering real-time graph analytics with superior performance and data freshness for dynamic applications.

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

SQLBits

Synapse Link: Capabilities and Restrictions for Real-Time OLTP Data Analytics

Explore Synapse Link's capabilities for real-time OLTP data analytics in Azure Synapse, examining its potential and limitations.

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