bongoDev

Loading...

Empowering technology learners worldwide with professional online live trainings. Transform your IT career with expert-led courses.

Facebook Instagram LinkedIn Github

Company

About Us
Careers
Blog
Events

Legal

Privacy Policy
Refund Policy
Terms and Conditions

Contact us

[email protected]
01757258398 01978367094 01576641348
01757258398

Our office

Flat 5/A, Shimanto Plaza, Plot #26/D, Main Road-03, Section #11, Mirpur, Dhaka 1216

© 2026 bongoDev. All rights reserved. | ই-ট্রেড লাইসেন্স: TRADEDNCC/015304/2024

Courses Job Success

Blog Events Free Assessment Login

bongoDev | Database Reliability Pro - Knowledge Hub

Knowledge Hub/Database Reliability Pro

Englishবাংলা

Learning path

Database Reliability Pro

Production database reliability across transactions, isolation, locking, connection pools, indexing, query plans, replication, backups, PITR, failover, schema changes, PostgreSQL, MySQL, managed cloud databases, capacity, security and incident troubleshooting.

Discount price

৳ 320.00৳ 120.00Save ৳ 200.00

Lessons

78 published lessons · 1 free preview

01Database Reliability Mental Model: Correctness, Durability, Availability & RecoverabilityTreat the database as a stateful production system whose reliability must preserve business correctness as well as uptime.Beginner · 34 min readFree previewFree preview
02Choose the Right Data System: Relational, Key-Value, Document & Distributed Trade-offsSelect a database model by consistency, query, scaling and failure requirements instead of popularity.Beginner · 38 min readLockedLocked
03Transactions & ACID: The Business Correctness BoundaryUnderstand what a transaction protects and what it does not protect across external systems.Beginner · 42 min readLockedLocked
04Isolation Levels & Concurrency AnomaliesChoose isolation deliberately by understanding dirty reads, non-repeatable reads, phantoms, write skew and serialization failures.Intermediate · 48 min readLockedLocked
05MVCC, Row Versions & VisibilityUnderstand how multi-version concurrency control improves concurrency and creates cleanup/visibility responsibilities.Intermediate · 46 min readLockedLocked
06Locks, Blocking & DeadlocksDiagnose contention by finding the blocker, waiter, lock scope and transaction holding time.Intermediate · 52 min readLockedLocked
07Database Connections: Lifecycle, Limits & Failure ModesUnderstand why database connections are finite resources rather than free network sockets.Beginner · 40 min readLockedLocked
08Connection Pooling: Sizing, Backpressure & Pooler ArchitectureSize pools from database capacity and concurrency rather than multiplying an arbitrary per-pod default.Intermediate · 50 min readLockedLocked
09SQL Request Lifecycle: Parse → Plan → Execute → CommitTrace where query latency can be spent before assuming the SQL text itself is slow.Beginner · 38 min readLockedLocked
10Indexes: Reliability, Selectivity & Write Trade-offsDesign indexes to reduce necessary work without creating unlimited write and maintenance cost.Intermediate · 48 min readLockedLocked
11Query Plans & EXPLAIN: Read the Work, Not Just the SQLUse execution plans to understand rows, access methods, joins, estimates and actual work.Intermediate · 54 min readLockedLocked
12Statistics, Cardinality Estimates & Plan StabilityUnderstand how data distribution and statistics drive optimizer decisions.Advanced · 48 min readLockedLocked
13CPU, Memory, Buffer Cache & Working SetDiagnose whether database work is CPU-bound, memory-pressure-bound or I/O-bound.Intermediate · 50 min readLockedLocked
14Storage I/O, WAL/Redo, fsync & Commit LatencyUnderstand how durable writes interact with transaction logs and storage latency.Advanced · 54 min readLockedLocked
15Checkpoints, Vacuum/Purge, Compaction & Background MaintenanceTreat background maintenance as required reliability work, not optional overhead.Advanced · 52 min readLockedLocked
16Constraints & Data Integrity as Reliability ControlsUse the database to enforce invariants that must remain true under concurrency and retries.Intermediate · 42 min readLockedLocked
17Schema Evolution: Backward Compatibility & Mixed VersionsDesign schema changes for periods where old and new application versions run simultaneously.Intermediate · 50 min readLockedLocked
18Zero-Downtime Database Migrations: Expand → Migrate → ContractPerform large schema/data changes without forcing downtime or destroying rollback options.Advanced · 58 min readLockedLocked
19Replication Mental Model: Durability, Read Scale & RecoveryUnderstand what replication protects, what it copies, and what failures it cannot undo.Intermediate · 44 min readLockedLocked
20Synchronous vs Asynchronous Replication & Commit Trade-offsChoose replication acknowledgement rules based on accepted latency and data-loss risk.Advanced · 48 min readLockedLocked
21Leader Election, Promotion, Failover & FencingFail over without creating two writers or silently losing acknowledged data.Advanced · 56 min readLockedLocked
22Read Replicas, Staleness & Read-After-Write GuaranteesUse read replicas only when application consistency requirements tolerate their lag.Advanced · 48 min readLockedLocked
23Backup Strategy: Logical, Physical, Snapshot & Log-BasedDesign backups from restore requirements instead of treating “backup succeeded” as the goal.Intermediate · 52 min readLockedLocked
24Point-in-Time Recovery: Base Backup + Transaction LogRecover to a chosen moment before corruption or operator error using a valid base plus log history.Advanced · 56 min readLockedLocked
25Restore Validation: A Backup Is Not Proven Until RestoredContinuously prove that backups can produce a usable database within recovery objectives.Intermediate · 46 min readLockedLocked
26RPO, RTO & Database Recovery TieringTurn business impact into measurable database recovery objectives and architecture choices.Intermediate · 42 min readLockedLocked
27Multi-AZ High Availability & Failure-Domain DesignDesign database availability so one host or zone failure does not become a full service outage.Advanced · 50 min readLockedLocked
28Regional Disaster Recovery: Standby, Replication & FailbackRecover database service after regional loss while controlling data authority and reconciliation.Advanced · 58 min readLockedLocked
29Multi-Region Consistency, Quorums & Latency Trade-offsReason about cross-region writes using quorum, consistency and latency rather than marketing labels.Advanced · 58 min readLockedLocked
30Partitioning & Sharding: Scale Without Losing OperabilityPartition data with a strategy that supports routing, growth, resharding and incident response.Advanced · 58 min readLockedLocked
31Hotspots, Skew & Monotonic Key Failure ModesDetect uneven load that aggregate database metrics can hide.Advanced · 46 min readLockedLocked
32Primary Keys, IDs & Data LocalityChoose identifiers that preserve uniqueness, index health, locality and distributed generation requirements.Intermediate · 42 min readLockedLocked
33PostgreSQL Reliability Operations: Processes, WAL & Catalog EvidenceBuild a practical operational model for PostgreSQL without memorizing every configuration knob.Intermediate · 54 min readLockedLocked
34PostgreSQL VACUUM, Autovacuum, Bloat & Transaction AgeKeep MVCC cleanup healthy so old row versions do not become a capacity incident.Advanced · 58 min readLockedLocked
35PostgreSQL Locks, Wait Events & Long TransactionsUse blocker/waiter relationships and wait events to diagnose PostgreSQL stalls safely.Advanced · 58 min readLockedLocked
36PostgreSQL Streaming Replication, Slots & PITROperate PostgreSQL replication and recovery while respecting WAL retention and lag risks.Advanced · 60 min readLockedLocked
37MySQL/InnoDB Reliability: Redo, Undo, Buffer Pool & TransactionsBuild a production mental model for InnoDB transaction durability, locking and caching.Intermediate · 54 min readLockedLocked
38MySQL Replication, GTIDs, Lag & FailoverOperate MySQL replicas and failover with clear transaction identity and data-loss boundaries.Advanced · 58 min readLockedLocked
39MySQL Locks, Metadata Locks & Performance SchemaDiagnose MySQL contention including DML locks, metadata locks and statement waits.Advanced · 54 min readLockedLocked
40Managed Database Reliability on AWS, Azure & GCPUse managed services without outsourcing ownership of schema, workload, recovery and client behavior.Intermediate · 52 min readLockedLocked
41Database Proxies & Poolers: PgBouncer, Managed Proxies & Trade-offsUse a proxy/pooler to control connections without hiding application or transaction mistakes.Advanced · 52 min readLockedLocked
42Database Observability: Golden Signals, Waits & Business CorrelationBuild observability around user impact, workload, waits, capacity and data safety.Intermediate · 52 min readLockedLocked
43Slow Query Engineering: Detect → Explain → Fix → Regress-TestTreat slow query remediation as a controlled performance change with evidence.Advanced · 58 min readLockedLocked
44Database Capacity Planning: Throughput, Concurrency, Headroom & GrowthPlan database capacity from workload and bottlenecks rather than CPU thresholds alone.Advanced · 56 min readLockedLocked
45Database Saturation & Overload ProtectionPrevent overloaded databases from collapsing under unlimited concurrency and retries.Advanced · 54 min readLockedLocked
46Cache + Database Reliability: Protect the Source of TruthDesign cache behavior so a cache outage does not become a database outage.Advanced · 48 min readLockedLocked
47Queues & Write Buffering: Smoothing Database Load SafelyUse asynchronous buffering without losing visibility into backlog, durability and correctness.Advanced · 46 min readLockedLocked
48Database Retry Safety, Idempotency & Transaction BoundariesRetry only operations whose correctness remains safe after uncertain outcomes.Advanced · 56 min readLockedLocked
49ORM Reliability: N+1 Queries, Hidden Transactions & Connection LeaksRecognize how abstraction layers can amplify database load or hide transaction behavior.Intermediate · 48 min readLockedLocked
50Data Corruption & Integrity Incident ResponseRespond to suspected logical or physical corruption without making irreversible changes too early.Advanced · 60 min readLockedLocked
51Database Security: Authentication, Authorization, TLS & Least PrivilegeReduce the blast radius of credential compromise and application defects.Intermediate · 48 min readLockedLocked
52Secrets, Credential Rotation, Certificates & Database IdentityRotate database identity without causing a fleet-wide reconnect outage.Advanced · 46 min readLockedLocked
53Maintenance, Patching & Minor-Version UpgradesPatch databases with predictable blast radius, compatibility checks and rollback/recovery paths.Intermediate · 46 min readLockedLocked
54Major Database Upgrades & Compatibility StrategyPlan major upgrades as data-platform migrations with rehearsed fallback and validation.Advanced · 58 min readLockedLocked
55Database Change Management: DDL, Config, Indexes & Risk GatesTreat database changes as production releases with explicit impact, rollback and observability.Advanced · 52 min readLockedLocked
56Running Databases on Kubernetes: Stateful Reliability Trade-offsUnderstand when Kubernetes helps database automation and what stateful responsibilities remain.Advanced · 54 min readLockedLocked
57NoSQL Reliability: Key-Value & Document Database PatternsApply the same reliability questions to non-relational stores: consistency, partitions, backups, hotspots and recovery.Intermediate · 50 min readLockedLocked
58Consensus, Quorum & Split-Brain Fundamentals for Database EngineersReason about safe write authority in replicated distributed data systems.Advanced · 60 min readLockedLocked
59Database SLOs & Reliability AlertsAlert on conditions that threaten user journeys and data safety rather than every noisy database metric.Advanced · 48 min readLockedLocked
60Database Incident Triage: First 5 / 15 / 30 MinutesStabilize database incidents with user-impact scope, blocker/bottleneck evidence and safe mitigation.Advanced · 58 min readLockedLocked
61Connection Exhaustion & Pool Storm IncidentTroubleshoot too-many-connections and pool wait incidents without blindly raising limits.Advanced · 54 min readLockedLocked
62Lock Storm & Deadlock IncidentResolve blocking safely by identifying lock graph, transaction age and business operation.Advanced · 56 min readLockedLocked
63Replication Lag & Replica Failure IncidentDiagnose whether lag is caused by source generation, network transfer, replay/apply or replica resource saturation.Advanced · 58 min readLockedLocked
64Storage Full, WAL/Redo Growth & Runaway Disk IncidentRespond before full storage converts a capacity issue into crash/recovery risk.Advanced · 58 min readLockedLocked
65Failover Incident: Promotion, Client Reconnect & Recovery ValidationOperate a database failover as an end-to-end application recovery, not a database-only event.Advanced · 60 min readLockedLocked
66Database Performance Testing: Realistic Workloads & Safe BenchmarksBenchmark the database with production-like data shape, concurrency and transaction mix.Advanced · 54 min readLockedLocked
67Database Load Shedding, Prioritization & Graceful DegradationProtect critical write and read paths when the database approaches saturation.Advanced · 50 min readLockedLocked
68Transactional Outbox, Inbox & Reliable Database-to-Event HandoffsBridge database commits and asynchronous events without relying on an unsafe dual-write.Advanced · 58 min readLockedLocked
69Saga & Compensation Patterns for Cross-System TransactionsPreserve business consistency across multiple services when one ACID transaction cannot span them.Advanced · 54 min readLockedLocked
70Database Ownership, Service Catalog & Operational ReadinessMake database ownership, dependencies and recovery responsibilities discoverable before incidents.Intermediate · 42 min readLockedLocked
71Database Reliability Review & Production Readiness ChecklistReview a database-backed service before launch using failure, capacity, recovery and correctness evidence.Advanced · 50 min readLockedLocked
72Lab: Connection Pool Storm During Kubernetes AutoscalingReproduce an autoscaling-driven connection storm and fix the entire feedback loop.Advanced · 72 min readLockedLocked
73Lab: Bad Migration, Metadata Lock & Production RecoveryPractice detecting and safely aborting a schema migration that blocks production traffic.Advanced · 76 min readLockedLocked
74Lab: Primary Failure, Promotion, Stale Reads & FailbackExercise database failover with application reconnection, consistency validation and controlled failback.Advanced · 82 min readLockedLocked
75Lab: Logical Corruption, PITR & Business ReconciliationRecover from replicated logical corruption while preserving valid business changes where possible.Advanced · 86 min readLockedLocked
76Database Reliability Troubleshooting PlaybookUse a deterministic evidence path during database incidents instead of random tuning or restarts.Advanced · 68 min readLockedLocked
77Database Command & Evidence Playbook: PostgreSQL, MySQL & LinuxUse commands and queries because of the question they answer, not because they are familiar.Advanced · 64 min readLockedLocked
78Database Reliability Pro CheatsheetConsolidate reliability architecture, incident flow, SQL/engine evidence, recovery and review checklists.Advanced · 56 min readLockedLocked