Database Engineering.

SQL Server, Postgres, Oracle, Cassandra, Mongo, Yugabyte — replication, performance, and surviving 3am pages.

Database Tutorials

Guided lessons with examples, validation, and troubleshooting.

Microsoft SQL Server

8 documents

View SQL Server
3 MIN READ

Connect to SQL Server and Identify Your Instance

Connect securely, distinguish an instance from a database, and collect a reproducible configuration baseline.

Read tutorial
3 MIN READ

Create a SQL Server Database and Inspect Its Files

Create a small lab database, insert a fixture, and understand data files, log files, and growth settings.

Read tutorial
3 MIN READ

Understand SQL Server Architecture Through Active Requests

Relate sessions, query execution, waits, and storage activity to the Database Engine.

Read tutorial

Oracle Database

11 documents

View Oracle
2 MIN READ

Inspect Oracle RAC Instances and Application Services

Connect RAC membership, database instances, and application service placement in one health check.

Read tutorial
3 MIN READ

Build and Validate an Oracle Physical Standby Lab

Prepare a distinct standby identity, duplicate the primary, and establish broker-managed redo apply.

Read tutorial
3 MIN READ

Perform and Verify a Planned Data Guard Switchover

Reverse primary and standby roles with broker validation and application-level acceptance checks.

Read tutorial

PostgreSQL

10 documents

View PostgreSQL
3 MIN READ

Build and Verify a TLS-Capable PostgreSQL 15 Client

Build PostgreSQL in a separate software directory and verify that the intended client and server are in use.

Read tutorial
3 MIN READ

Install PostgreSQL 15 from Source with TLS Support

Build PostgreSQL in a separate software directory and verify that the intended client and server are in use.

Read tutorial
3 MIN READ

Install PostgreSQL 17 from Source with TLS Support

Build PostgreSQL in a separate software directory and verify that the intended client and server are in use.

Read tutorial

Apache Cassandra

22 documents

View Cassandra
3 MIN READ

Add a Cassandra Datacenter Without Moving Clients Too Early

Extend a cluster into a second datacenter, populate its replicas, and verify it before directing reads there.

Read tutorial
3 MIN READ

Rehearse a Cassandra 3.11-to-4.1 Upgrade

Turn a Cassandra upgrade into a sequence of observable checks and controlled changes.

Read tutorial
3 MIN READ

Build a Three-Node Cassandra Lab

Create a small Cassandra cluster and prove that replication works with a real read/write example.

Read tutorial

MongoDB

3 documents

View MongoDB
2 MIN READ

Copy a MongoDB Database with mongodump and mongorestore

Create a BSON backup and restore it into a separate namespace for verification.

Read tutorial
3 MIN READ

Understand the MongoDB 5.0-to-6.0 Replica-Set Upgrade

Separate the server-binary upgrade from the feature compatibility version change and test elections along the way.

Read tutorial
3 MIN READ

Rehearse a MongoDB Replica-Set Upgrade

Separate the server-binary upgrade from the feature compatibility version change and test elections along the way.

Read tutorial

Couchbase

4 documents

View Couchbase
3 MIN READ

Replace and Reinstall a Couchbase Node

Reintroduce a rebuilt server only after its old cluster membership and service responsibilities have been handled.

Read tutorial
3 MIN READ

Remove a Couchbase Node with Rebalance

Move data and service responsibilities off a node before shutting it down.

Read tutorial
3 MIN READ

Plan a Couchbase Community Edition Upgrade

Choose a supported Community Edition upgrade path and prove a recovery method before changing binaries.

Read tutorial

Presto

3 documents

View Presto
3 MIN READ

Understand PrestoDB Node, Cluster, and Catalog Configuration

Follow a query from the coordinator to a worker and use that model to configure and diagnose PrestoDB.

Read tutorial
3 MIN READ

Deploy a PrestoDB Coordinator and Worker in a Lab

Follow a query from the coordinator to a worker and use that model to configure and diagnose PrestoDB.

Read tutorial
3 MIN READ

Diagnose PrestoDB Discovery and Query Execution

Follow a query from the coordinator to a worker and use that model to configure and diagnose PrestoDB.

Read tutorial

Oracle GoldenGate

11 documents

View GoldenGate
4 MIN READ

Add an Explicit Table Mapping to Oracle GoldenGate

Map selected source tables to the intended target schema and test inserts, updates, and deletes.

Read tutorial
4 MIN READ

Design a GoldenGate Bidirectional Replication Lab

Build two one-way paths with explicit loop prevention and write ownership before attempting active-active behavior.

Read tutorial
4 MIN READ

Monitor GoldenGate Health Beyond Process Status

Combine process state, checkpoint progress, lag, errors, and transaction evidence into a useful health check.

Read tutorial

Automation

22 documents

View Automation
5 MIN READ

Build a Self-Managing Log Rotation Pipeline

Compress, checksum, and expire application logs on a schedule without losing an in-flight write.

Read tutorial
5 MIN READ

Automate Backups with Checksums and Retention

Ship a nightly backup script with integrity verification and a tiered retention policy.

Read tutorial
5 MIN READ

Write a Self-Healing Service Watchdog

Detect a wedged process and restart it with backoff and a failure ceiling before paging a human.

Read tutorial

Oracle 26ai Tablespace and Space Management: A Practical DBA Starter Guide

A DBA-friendly introduction to Oracle tablespaces, data files, autoextend, free space, temp usage, undo, and the SQL checks every Oracle admin should know.

Oracle 26ai User Management: Users, Roles, Privileges, and Safer Access

A practical Oracle DBA guide to creating users, assigning roles, managing privileges, and avoiding over-permissioned accounts.

PostgreSQL Performance Basics: What DBAs Should Check First

A practical starter guide to PostgreSQL performance: slow queries, indexes, vacuum, statistics, memory, connections, and wait symptoms.

PostgreSQL Indexing Explained: B-tree, Selectivity, and Query Plans

A simple but detailed guide to PostgreSQL indexing for DBAs and developers, with practical examples and common mistakes.

Cassandra Architecture Basics: Nodes, Partitions, Replication, and Consistency

A practical introduction to Cassandra architecture for DBAs: clusters, nodes, partition keys, replication factor, consistency levels, and operational tradeoffs.

Cassandra Data Modeling: Query-First Design for DBAs

Cassandra data modeling explained simply: why query-first design matters, how partition keys work, and why normalization habits can hurt performance.

MongoDB Architecture Basics: Documents, Collections, Replica Sets, and Sharding

A DBA-friendly introduction to MongoDB architecture, including documents, collections, replica sets, sharding, indexes, and operational checks.

MongoDB Indexing and Query Performance: What to Check First

A practical MongoDB indexing guide covering query patterns, compound indexes, covered queries, explain plans, and common performance traps.

YugabyteDB Architecture: Distributed SQL Explained for DBAs

A practical explanation of YugabyteDB architecture, distributed SQL, tablets, replication, nodes, and PostgreSQL-compatible access.

YugabyteDB for PostgreSQL DBAs: What Feels Familiar and What Changes

A practical guide for PostgreSQL DBAs learning YugabyteDB: SQL compatibility, distributed storage, replication, indexes, and operational differences.

Oracle 26ai Architecture Explained for DBAs: Instance, CDB, PDB, Memory, and Services

A practical Oracle 26ai architecture guide for DBAs, covering the instance, database files, CDB/PDB model, SGA, PGA, background processes, listener, services, and SQL*Plus verification commands.

Oracle AI Database 26ai New Features: A Practical DBA Guide

A simple but detailed DBA-friendly walkthrough of Oracle AI Database 26ai features, including AI Vector Search, JSON Relational Duality, SQL Firewall, SQL enhancements, and SQL*Plus changes.