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

Herramientas de la Inteligencia de Negocios

246 reviews

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 a week
• On-Demand
• 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
• On-Demand
• Free Video

T-SQL Execution Plans, Indexes, Transactions, In-Memory OLTP

764 ratings at Udemy

Learn Execution Plans, Indexes, Transactions, Isolation Levels & In-Memory OLTP using T-SQL in Microsoft SQL Server

• Udemy
• 9 hours
• On-Demand
• Paid Course

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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Conference Talk

OSACon

Analytics and Real-time Database Workloads: Combining OLTP and OLAP Systems

Explore strategies for optimizing concurrent OLAP and OLTP workloads, focusing on ScyllaDB's workload prioritization features to achieve harmonious performance in distributed systems.

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

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