transactions
Database Transactions Skill
Overview
Understand and implement database transactions with ACID properties and proper concurrency control.
Topics Covered
ACID Properties
- Atomicity
- Consistency
- Isolation
- Durability
- Trade-offs
Isolation Levels
- Read uncommitted
- Read committed
- Repeatable read
- Serializable
More from pluginagentmarketplace/custom-plugin-sql
mysql
MySQL database administration and development
452data-analysis-sql
SQL for data analysis with exploratory analysis, advanced aggregations, statistical functions, outlier detection, and business insights. 50+ real-world analytics queries.
57data-warehouse
Data warehouse design mastery with star schema, dimensional modeling, fact/dimension tables, slowly changing dimensions, and enterprise best practices. Complete schema examples included.
51redis
Redis data structures and commands including strings, lists, hashes, sets, sorted sets, streams, and transactions for high-performance caching and real-time applications.
49postgresql
PostgreSQL administration and setup including installation, configuration, backup/recovery, replication, and high-availability. Learn production PostgreSQL operations.
41bi-fundamentals
BI fundamentals with metric definition, KPI calculation, dimensional modeling, dashboard optimization, and data storytelling. 40+ metric examples and calculation patterns.
36