jypi
  • Explore
ChatWays to LearnMind mapAbout

jypi

  • About Us
  • Our Mission
  • Team
  • Careers

Resources

  • Ways to Learn
  • Mind map
  • Blog
  • Help Center
  • Community Guidelines
  • Contributor Guide

Legal

  • Terms of Service
  • Privacy Policy
  • Cookie Policy
  • Content Policy

Connect

  • Twitter
  • Discord
  • Instagram
  • Contact Us
jypi

© 2026 jypi. All rights reserved.

Relational Databases Certification
Chapters

1Relational Concepts and Architecture

2SQL Fundamentals: DDL, DML, and Querying

3Data Modeling and Normalization

4Keys, Constraints, and Data Integrity

5Joins, Subqueries, Views, and Set Operations

6Indexes, Execution Plans, and Query Optimization

7Transactions, Concurrency, and Isolation

ACID Properties ExplainedTransaction Boundaries and ScopeAutocommit vs Explicit TransactionsIsolation Levels OverviewRead Phenomena: Dirty, Nonrepeatable, PhantomLock Types and GranularityBlocking and DeadlocksDeadlock Detection and AvoidanceMVCC Concepts and SnapshotsOptimistic vs Pessimistic ConcurrencySavepoints and Partial RollbacksLong-Running TransactionsIdempotency and Retry PatternsConsistency and Business InvariantsTesting Concurrency Scenarios

8Advanced SQL and Procedural Features

9Operations, Security, and Monitoring

10Backup, Recovery, Replication, and Cloud Operations

Courses/Relational Databases Certification/Transactions, Concurrency, and Isolation

Transactions, Concurrency, and Isolation

22 views

Guarantee consistency under load with ACID transactions, locking, MVCC, and robust retry strategies.

Content

11 of 15

Savepoints and Partial Rollbacks

Original version
3 views

Versions:

Version 22798

Watch & Learn

AI-discovered learning video

Sign in to watch the learning video for this topic.

Sign inSign up free

Start learning for free

Sign up to save progress, unlock study materials, and track your learning.

  • Bookmark content and pick up later
  • AI-generated study materials
  • Flashcards, timelines, and more
  • Progress tracking and certificates

Free to join · No credit card required

Unlock this content

Sign up free to view this chapter, save your progress, and unlock study modes.

  • Full chapters & explanations
  • Flashcards & practice
  • Track progress
Sign inCreate free account
Flashcards
Mind Map
Speed Challenge

Comments (0)

Please sign in to leave a comment.

No comments yet. Be the first to comment!

Ready to practice?

Sign up now to study with flashcards, practice questions, and more — and track your progress on this topic.

Study with flashcards, timelines, and more
Earn certificates for completed courses
Bookmark content for later reference
Track your progress across all topics