database
A program that stores data in an organised way and answers questions about it, such as PostgreSQL.
In more detail
A database keeps data on disk so it survives restarts, lets many programs read and change it safely, and answers questions you ask in a query language. Relational databases such as SQLite and PostgreSQL store data in tables and are queried with SQL; other kinds store documents, key-value pairs or graphs.
Examples
A Bloom filter in front of a database skips queries for keys that are certainly absent.In the course inventory, dbservers is a group of database hosts that share a data directory.In the APIs course: The course service keeps its tasks and owners in a small SQL database.In AWS you can run a database yourself on EC2 or use a managed service such as Amazon RDS or DynamoDB.A self-hosted runner can reach a database that only answers inside your own network.Module six shows why writing to a database and to Kafka separately is unsafe.In the twelve-factor app a database is a backing service reached through a handle in config, and stateless processes keep anything that must persist in it. Database schema changes need compatibility planning in rolling and blue-green releases.Linux keeps several small databases as files: the account database in /etc/passwd and /etc/group, and each package manager's record of installed packages. Larger systems use database servers such as PostgreSQL. Either way, change them through the tools meant for them rather than by hand.Server Components can query the database directly; the connection code must stay server-only.The course trace has a SELECT basket child span with db.system="postgresql".A metrics page must never query a database while it is being built.Serious web sites store shared data in a database; the course's name list page uses a text file instead.A slow database query behind one widget should not hold up the whole page; give it its own Suspense boundary.Recovery reconnects the database tier first, then applications, then users.The SQL course compares SQLite, which runs every exercise, with PostgreSQL.In Terraform: Databases are the resources where a careless replacement or destroy costs the most, because the data goes with them. Read any plan touching one twice.In this course: A fake or in-memory stand-in can test business rules quickly, but only the real database engine can prove that your SQL is valid, constraints are enforced, migrations apply and transactions isolate correctly. Give each test its own data through a rolled-back transaction, a fresh schema or a disposable database.Related terms
- index — A separate, sorted structure a database keeps alongside a table so it can find matching rows without reading them all.
- B-tree — A balanced search tree whose nodes each hold many sorted keys and have many children, so the tree is very wide and very shallow.
- managed node — A machine that Ansible configures; it needs only a way in, normally SSH, and a Python interpreter, not Ansible itself.
- SQL — The standard language for defining, querying and changing data in a relational database.
- resource — Anything an API gives a name to and lets clients work with, such as one task, a collection of tasks or a job.
- representation — The data sent to describe a resource’s state in one particular format, such as a JSON document for a task.
- N+1 query problem — A performance bug where code runs one query for a list and then one more query per item, so N items cost N+1 queries.
- relational database — A database that stores data in tables and links rows in one table to rows in another through shared key values.
- NoSQL — Databases that do not use the relational table model, such as key-value and document stores, trading query freedom for predictable scale.
- Amazon RDS — Amazon Relational Database Service, which runs relational database engines such as PostgreSQL and MySQL as a managed service.
- Amazon DynamoDB — Amazon's fully managed key-value and document database, which stores items in tables without any servers for you to run.
- self-hosted runner — A runner you install and operate on your own hardware or cloud machine, selected with the self-hosted label.
- PostgreSQL — A widely used open source relational database server with strict typing, rich data types and extensions.
- transaction — A group of database changes that succeed or fail together, so the data is never left half-updated.
- dual write — Writing the same change to two separate systems, such as a database and a message broker, from application code with no shared transaction.
- backing service — Any service an application uses over the network, such as a database, cache, queue, mail relay or payments provider.
- schema — A formal description of the structure of data: which fields or columns exist, their types and which are required.
- database migration — A scripted, versioned change to a database's structure, such as adding a table or a constraint.
- volume — Storage managed by Docker that lives outside any container, so data survives when the container is removed.
- service — A long-running program that waits for and answers requests, such as a web API or a database; in Compose, one named entry under services.
- health check — A regular automated test of whether a program or service is working, such as a request to its health endpoint or a command run inside its container.
- volume backup — A copy of the data in a volume, saved somewhere else so it can be restored.
- connection pool — A set of already open database connections that a program reuses instead of opening a new one for each request.
- JPA — The Jakarta standard for mapping Java objects to relational database tables and managing them, implemented by libraries such as Hibernate.
- /etc/passwd — The world-readable file that lists local accounts, one per line: name, UID, GID, description, home directory and login shell, separated by colons.
- package database — The local record a package manager keeps of every installed package, its version and the files it owns.
- directory service — A central network database, often queried by many machines, that stores user accounts and groups so they do not have to be copied to every host.
- ORM — A library that lets code read and write database rows as ordinary objects, generating the SQL for you.
- span — One timed operation within a trace, such as handling a request or running a query, with its start, duration and attributes.
- SQLite — A small relational database that runs as a library inside your program and keeps the whole database in one file.
- microservice — A small, independently deployed service that owns one business capability, such as billing or notifications.
- progressive loading — Showing each part of a page as soon as its own data is ready, instead of waiting for the slowest part.
- SQL injection — An attack where untrusted input is joined into a database query so that part of it runs as SQL, letting an attacker read or change data.
- document database — A NoSQL database that stores each record as a flexible document, usually JSON, with its own nested structure.
- key-value store — A database that stores each item under a unique key and fetches it by that key, very quickly and at large scale.
- managed database — A database service a cloud provider runs for you, handling machines, patching and backups while you manage settings and data.
- resource replacement — When Terraform must destroy a resource and create a new one because a changed setting cannot be updated in place.
- database engine — The database software itself, such as PostgreSQL, MySQL or SQLite, which decides the features, SQL dialect and extensions available.
- repository pattern — Putting all the code that reads and writes one kind of data behind a single object, so the rest of the app never talks to the database directly.
- entity — A thing in an application's domain with its own identity, such as a user, account or product, usually stored in a database.
Taught in
- What An AI Engineer Does — AI Engineering: LLM Apps, RAG & Agents
- Reasoning Techniques — AI Engineering: LLM Apps, RAG & Agents
- Vector Indexes And Databases — AI Engineering: LLM Apps, RAG & Agents
- Function Calling — AI Engineering: LLM Apps, RAG & Agents
- Designing Tools A Model Can Use — AI Engineering: LLM Apps, RAG & Agents
- What MCP Is — AI Engineering: LLM Apps, RAG & Agents
- Excessive Agency — AI Engineering: LLM Apps, RAG & Agents
- Evaluating RAG And Agents — AI Engineering: LLM Apps, RAG & Agents
- Bloom Filters: Membership Without The Data — Algorithms & Data Structures for Working Engineers
- AVL Trees: Rotations That Keep The Guarantee — Algorithms & Data Structures for Working Engineers
- B-Trees: The Structure Behind Every Database Index — Algorithms & Data Structures for Working Engineers
- Heaps And Priority Queues — Algorithms & Data Structures for Working Engineers
- Installing Ansible — Ansible Configuration Management at Scale
- The Static Inventory File — Ansible Configuration Management at Scale
- Host Groups And Host Variables — Ansible Configuration Management at Scale
- What An API Is, And The Alternatives — Modern API Architecture: REST, GraphQL & gRPC
- The REST Constraints — Modern API Architecture: REST, GraphQL & gRPC
- Naming Resources And Collections — Modern API Architecture: REST, GraphQL & gRPC
- Performance Optimization — Modern API Architecture: REST, GraphQL & gRPC
- Ten Findings, Six Pillars — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- Seven Ways To Leave A Rack — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- The Estimate That Copied The Rack — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- Cloud Concepts Sprint: Twelve Cards — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- Whose Job Was The Patch? — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- Twelve Alerts, Ten Services — AWS Certified Cloud Practitioner (CLF-C02) Exam Prep
- Surviving A Hundred And Eighty Minutes — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- CodePipeline: Stages, Actions And The Key Nobody Shared — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- CodeBuild: The Build That Passed With Failing Tests — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- CodeDeploy: Hooks That Never Ran — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- CloudFormation In Depth: Replace Or Update? — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- High Availability Across Tiers: What Fails Over By Itself? — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- Scaling Patterns: When Capacity Arrives Too Late — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- Recovery To RTO And RPO: Backups Nobody Could Delete — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- Testing Resilience: The Experiment That Would Have Been The Outage — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- Finding The Problem: The Composite Alarm That Stayed Quiet — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- Troubleshooting Failed Deployments: Read The First Failure — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- Automating Data Protection: Keys, Secrets And A Partner Shortcut — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- Auditing: Who Opened Port Twenty Two? — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- Long-Stem Clinic: When Two Answers Both Work — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- The Full Mock And Your Review Plan — AWS Certified DevOps Engineer – Professional (DOP-C02) Exam Prep
- The Morning An Availability Zone Went Dark — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Reading A 130-Minute Exam — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- The Network As A Control: CIDR, Routes, ACLs And Security Groups — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Private Paths: VPC Endpoints And PrivateLink — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- The Edge: WAF, Shield, CloudFront And GuardDuty — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Protecting Data: Versions, Object Lock, Backups And Secrets — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Decoupling: SQS, SNS, EventBridge And Step Functions — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Load Balancers And Auto Scaling: Capacity That Arrives On Time — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Databases That Survive: Standbys, Replicas And Global Tables — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Disaster Recovery By The Numbers — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Storage Performance: IOPS, Throughput And The Right Volume — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Compute Performance: Families, Placement And Lambda Memory — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Database Performance: Caches, Proxies And Capacity Units — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Network Performance: Peering, Transit Gateway And The Edge — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Ingest And Transform: Streams, Lakes And Partitions — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- The Performance Clinic: Five Slow Systems, Five Fixes — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Compute Cost: Commit, Interrupt Or Pay As You Go — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Database Cost: Serverless, Capacity Modes And Reservations — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Network Cost: NAT Gateways, Zones And Data Out — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Long-Stem Clinic: The Phrase That Decides — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- The Full Mock And Your Review Plan — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Monday, Five Tickets — Microsoft Azure Administrator (AZ-104) Exam Prep
- Should Theo Be An Owner? Azure Roles And Scopes — Microsoft Azure Administrator (AZ-104) Exam Prep
- The Deleted IP Address: Locks, Tags, Groups And Subscriptions — Microsoft Azure Administrator (AZ-104) Exam Prep
- Ninety-Nine Percent Full: Disks, Sizes And Availability — Microsoft Azure Administrator (AZ-104) Exam Prep
- Twenty Minutes Down At Lunchtime: App Service Plans And Slots — Microsoft Azure Administrator (AZ-104) Exam Prep
- Ten Workloads, One Week: The Compute Decision Drill — Microsoft Azure Administrator (AZ-104) Exam Prep
- Branch Policies And Protection Rules — Microsoft Azure DevOps Engineer Expert (AZ-400) Exam Prep
- A Retailer Moves To Azure In A Weekend — Microsoft Azure Fundamentals (AZ-900) Exam Prep
- What The Cloud Changes — Microsoft Azure Fundamentals (AZ-900) Exam Prep
- The Benefits, In Microsoft's Words — Microsoft Azure Fundamentals (AZ-900) Exam Prep
- IaaS, PaaS And SaaS On Azure — Microsoft Azure Fundamentals (AZ-900) Exam Prep
- Regions, Zones And The Resource Hierarchy — Microsoft Azure Fundamentals (AZ-900) Exam Prep
- Zero Trust, Defence In Depth And Defender For Cloud — Microsoft Azure Fundamentals (AZ-900) Exam Prep
- What Drives An Azure Bill — Microsoft Azure Fundamentals (AZ-900) Exam Prep
- Governance: Policy, Locks And Purview — Microsoft Azure Fundamentals (AZ-900) Exam Prep
- Monitoring: Advisor, Service Health And Azure Monitor — Microsoft Azure Fundamentals (AZ-900) Exam Prep
- Governance Decision Drill — Microsoft Azure Fundamentals (AZ-900) Exam Prep
- Look-Alike Services Sprint — Microsoft Azure Fundamentals (AZ-900) Exam Prep
- Runners: Where Code Executes — Continuous Integration & Continuous Delivery Pipelines
- Choose The Right Workload Resource — Certified Kubernetes Application Developer (CKAD) Exam Prep
- Sidecars And Init Containers — Certified Kubernetes Application Developer (CKAD) Exam Prep
- Persistent And Ephemeral Volumes — Certified Kubernetes Application Developer (CKAD) Exam Prep
- Jobs And CronJobs That Behave — Certified Kubernetes Application Developer (CKAD) Exam Prep
- Design And Build: Timed Drill And Checkpoint — Certified Kubernetes Application Developer (CKAD) Exam Prep
- Blue/Green With Labels And A Service — Certified Kubernetes Application Developer (CKAD) Exam Prep
- Probes And Health Checks — Certified Kubernetes Application Developer (CKAD) Exam Prep
- Debugging Applications In Kubernetes — Certified Kubernetes Application Developer (CKAD) Exam Prep
- ConfigMaps And Secrets — Certified Kubernetes Application Developer (CKAD) Exam Prep
- Custom Resources And Operators — Certified Kubernetes Application Developer (CKAD) Exam Prep
- Services And Networking: Timed Drill And Checkpoint — Certified Kubernetes Application Developer (CKAD) Exam Prep
- Mock Exam: Sixteen Tasks Against The Clock — Certified Kubernetes Application Developer (CKAD) Exam Prep
- Default Deny, Then Exactly The Doors You Need — Certified Kubernetes Security Specialist (CKS) Exam Prep
- Encryption At Rest: What etcd Really Holds — Certified Kubernetes Security Specialist (CKS) Exam Prep
- Secrets In Use: Leaks Through Env, Specs And Images — Certified Kubernetes Security Specialist (CKS) Exam Prep
- Minimal Base Images: Less To Attack — Certified Kubernetes Security Specialist (CKS) Exam Prep
- SBOMs: Knowing What You Ship — Certified Kubernetes Security Specialist (CKS) Exam Prep
- Elasticity and Scale — Cloud Infrastructure & Hyperscaler Architecture
- The Shared Responsibility Model — Cloud Infrastructure & Hyperscaler Architecture
- Regions, Availability Zones and Reliability — Cloud Infrastructure & Hyperscaler Architecture
- Virtual Private Clouds — Cloud Infrastructure & Hyperscaler Architecture
- Load Balancing and DNS — Cloud Infrastructure & Hyperscaler Architecture
- Comparing Compute Options — Cloud Infrastructure & Hyperscaler Architecture
- Auto Scaling Groups — Cloud Infrastructure & Hyperscaler Architecture
- Object, Block, and File Storage — Cloud Infrastructure & Hyperscaler Architecture
- S3: Buckets and Objects — Cloud Infrastructure & Hyperscaler Architecture
- Elastic File System (EFS) — Cloud Infrastructure & Hyperscaler Architecture
- Managed Relational Databases (RDS) — Cloud Infrastructure & Hyperscaler Architecture
- NoSQL and DynamoDB — Cloud Infrastructure & Hyperscaler Architecture
- When to Pick Which Database — Cloud Infrastructure & Hyperscaler Architecture
- Observability with CloudWatch — Cloud Infrastructure & Hyperscaler Architecture
- Metrics, Logs, and Alarms — Cloud Infrastructure & Hyperscaler Architecture
- How Bills Actually Get Large — Cloud Infrastructure & Hyperscaler Architecture
- Infrastructure as Code (Handover to Terraform) — Cloud Infrastructure & Hyperscaler Architecture
- The Two A.M. Page — CompTIA Cloud+ (CV0-004) Exam Prep
- Who Patches What: Service Models And Availability — CompTIA Cloud+ (CV0-004) Exam Prep
- The Range That Already Belonged To Someone — CompTIA Cloud+ (CV0-004) Exam Prep
- Peered To Everything, Reaching Nothing — CompTIA Cloud+ (CV0-004) Exam Prep
- Forty Terabytes Nobody Opens: Storage And Databases — CompTIA Cloud+ (CV0-004) Exam Prep
- The Container That Did Not Come Back — CompTIA Cloud+ (CV0-004) Exam Prep
- Two Domain Controllers, One Host: Virtualisation — CompTIA Cloud+ (CV0-004) Exam Prep
- Thirty Eight Percent More: Billing Models And Tags — CompTIA Cloud+ (CV0-004) Exam Prep
- Six Big Servers Doing Very Little: Rightsizing — CompTIA Cloud+ (CV0-004) Exam Prep
- Architecture Sprint: Ten Faults Before Friday — CompTIA Cloud+ (CV0-004) Exam Prep
- A Release That Cannot Take Checkout Down — CompTIA Cloud+ (CV0-004) Exam Prep
- Six Systems And A Lease That Ends In March — CompTIA Cloud+ (CV0-004) Exam Prep
- Two Environments That Should Have Been Twins — CompTIA Cloud+ (CV0-004) Exam Prep
- A Worksheet With Eight Boxes: Provisioning To Requirements — CompTIA Cloud+ (CV0-004) Exam Prep
- Deployment Sprint: A Plan That Deletes The App Server — CompTIA Cloud+ (CV0-004) Exam Prep
- Slow At Lunchtime: Logs, Traces And Alerts — CompTIA Cloud+ (CV0-004) Exam Prep
- Nine In The Morning, Every Monday: Scaling — CompTIA Cloud+ (CV0-004) Exam Prep
- Thursday, Twenty Past Two: Backup And Recovery — CompTIA Cloud+ (CV0-004) Exam Prep
- No Patch Is Coming: The Life Cycle Of Cloud Resources — CompTIA Cloud+ (CV0-004) Exam Prep
- Operations Sprint: Twelve Servers, Two Hours — CompTIA Cloud+ (CV0-004) Exam Prep
- Two Hundred And Fourteen Findings: Vulnerability Management — CompTIA Cloud+ (CV0-004) Exam Prep
- The Intern Who Could Delete Backups: Identity And Access — CompTIA Cloud+ (CV0-004) Exam Prep
- An Image That Runs As Root: Security Best Practices — CompTIA Cloud+ (CV0-004) Exam Prep
- Allowed In, Lost On The Way Back: Security Controls — CompTIA Cloud+ (CV0-004) Exam Prep
- The Bill That Jumped Overnight: Spotting Attacks — CompTIA Cloud+ (CV0-004) Exam Prep
- Security Sprint: A Table To Complete — CompTIA Cloud+ (CV0-004) Exam Prep
- Five Deploys, Five Failures: Troubleshooting Deployments — CompTIA Cloud+ (CV0-004) Exam Prep
- A Padlock Warning On Monday: Troubleshooting Security — CompTIA Cloud+ (CV0-004) Exam Prep
- Troubleshooting Sprint: Three Tickets, One Morning — CompTIA Cloud+ (CV0-004) Exam Prep
- Exam On Thursday: The PBQ Clinic And Final Review — CompTIA Cloud+ (CV0-004) Exam Prep
- Shared Responsibility Model & Cloud Threat Landscapes — Cloud Security & DevSecOps Engineering
- AWS Organizations, Account Hierarchies & Azure Management Groups — Cloud Security & DevSecOps Engineering
- Security Landing Zones & Centralized Egress Inspection — Cloud Security & DevSecOps Engineering
- Cloud Network Isolation: VPC Peering & PrivateLink — Cloud Security & DevSecOps Engineering
- Shift-Left Security Principles & Automated Pipeline Gates — Cloud Security & DevSecOps Engineering
- Static Application Security Testing with Semgrep — Cloud Security & DevSecOps Engineering
- Software Composition Analysis with Trivy — Cloud Security & DevSecOps Engineering
- Kubernetes NetworkPolicies & Microsegmentation — Cloud Security & DevSecOps Engineering
- Securing the Kubernetes Control Plane & Node Components — Cloud Security & DevSecOps Engineering
- Enforcing OPA Guardrails on Terraform Plan Payloads — Cloud Security & DevSecOps Engineering
- Continuous IaC Drift Detection & State Protection — Cloud Security & DevSecOps Engineering
- CloudTrail Logging, Integrity Validation & Athena — Cloud Security & DevSecOps Engineering
- Envelope Encryption & Data Protection with KMS — Cloud Security & DevSecOps Engineering
- Forty Minutes To Count Again — Confluent Apache Kafka Certifications (CCDAK and CCAAK) Exam Prep
- Twelve Lines Instead Of Four Hundred — Confluent Apache Kafka Certifications (CCDAK and CCAAK) Exam Prep
- The Connector That Was Created Twice — Confluent Apache Kafka Certifications (CCDAK and CCAAK) Exam Prep
- A Sink That Died On Record Nine — Confluent Apache Kafka Certifications (CCDAK and CCAAK) Exam Prep
- Risk Assessment: Qualitative vs Quantitative — Cybersecurity Fundamentals, GRC & Cryptography
- Regulatory Compliance: SOC 2, HIPAA, GDPR & PCI-DSS — Cybersecurity Fundamentals, GRC & Cryptography
- Symmetric Encryption: AES-GCM & ChaCha20 — Cybersecurity Fundamentals, GRC & Cryptography
- Public Key Infrastructure: X.509 Certificates & CAs — Cybersecurity Fundamentals, GRC & Cryptography
- Post-Quantum Cryptography & Key Lifecycles — Cybersecurity Fundamentals, GRC & Cryptography
- Data Classification Schemes & Sensitivity Labeling — Cybersecurity Fundamentals, GRC & Cryptography
- Data States: Security at Rest, in Transit, and in Use — Cybersecurity Fundamentals, GRC & Cryptography
- Privacy Principles, GDPR Subject Rights & Minimization — Cybersecurity Fundamentals, GRC & Cryptography
- Asset Lifecycle Management & Media Sanitization — Cybersecurity Fundamentals, GRC & Cryptography
- Business Impact Analysis, RTO & RPO Modeling — Cybersecurity Fundamentals, GRC & Cryptography
- Disaster Recovery Sites: Hot, Warm & Cold — Cybersecurity Fundamentals, GRC & Cryptography
- Backup Architectures: 3-2-1, Immutability & Air-Gaps — Cybersecurity Fundamentals, GRC & Cryptography
- Incident Roles, Escalation & Crisis Comm — Cybersecurity Fundamentals, GRC & Cryptography
- Security Architecture Gap Analysis — Cybersecurity Fundamentals, GRC & Cryptography
- Enterprise Risk Registers & Treatment Plans — Cybersecurity Fundamentals, GRC & Cryptography
- Security Capstone Review & Certification — Cybersecurity Fundamentals, GRC & Cryptography
- Restoration: Failed Deployment Recovery Time — DevOps & Site Reliability Engineering
- Codebase And Dependencies — DevOps & Site Reliability Engineering
- Config And Backing Services — DevOps & Site Reliability Engineering
- Build, Release, Run And Processes — DevOps & Site Reliability Engineering
- Disposability, Dev Prod Parity And Logs — DevOps & Site Reliability Engineering
- Admin Processes And The Open Source Update — DevOps & Site Reliability Engineering
- Testing Strategies And The Test Pyramid — DevOps & Site Reliability Engineering
- Building And Versioning The Artifact — DevOps & Site Reliability Engineering
- Deployment Strategies: Rolling Updates — DevOps & Site Reliability Engineering
- Install Docker And Verify Your Environment — Docker Architecture & Production Containers
- ARG, ENV, LABEL, EXPOSE And VOLUME — Docker Architecture & Production Containers
- Scan, Patch And Inspect The Software Supply Chain — Docker Architecture & Production Containers
- Ephemeral Filesystems And Named Volumes — Docker Architecture & Production Containers
- Bind Mounts, Permissions And Backups — Docker Architecture & Production Containers
- Bridge Networks, DNS And Container Communication — Docker Architecture & Production Containers
- Port Publishing, Localhost And Network Troubleshooting — Docker Architecture & Production Containers
- Environment, Secret Files And Runtime Restrictions — Docker Architecture & Production Containers
- Define The Service And Database With Compose — Docker Architecture & Production Containers
- Health Checks, Dependencies And Reliable Startup — Docker Architecture & Production Containers
- Development Overrides, Hot Reloading And Debuggers — Docker Architecture & Production Containers
- Integration Tests, Test Data And Compose Cleanup — Docker Architecture & Production Containers
- Harden And Deliver The Complete Service Stack — Docker Architecture & Production Containers
- From Local Containers To Kubernetes — Docker Architecture & Production Containers
- Classes, Interfaces, and Object-Oriented C# — Modern .NET Core, C# & Enterprise Microservices
- Entity Framework Core: Code First and Migrations — Modern .NET Core, C# & Enterprise Microservices
- Querying, Change Tracking, and Saving Data — Modern .NET Core, C# & Enterprise Microservices
- Environment Configuration: Secrets & Multi-Stage — Production Full-Stack Engineering
- Database Access & Migrations: ORM & Data Layers — Production Full-Stack Engineering
- Multi-Tenant Identity: Tenant Isolation & Middleware — Production Full-Stack Engineering
- Asynchronous Event Processing: Outbox Pattern & Queues — Production Full-Stack Engineering
- Health Probes & Graceful Shutdown: Kubernetes Lifecycles — Production Full-Stack Engineering
- Shipping in Scratch and Distroless Images — Concurrent Systems Programming with Go
- Testing Basics With JUnit 5 — Modern Java: Virtual Threads & High-Throughput Services
- Designing Testable Code — Modern Java: Virtual Threads & High-Throughput Services
- Persistence With JPA And Hibernate — Modern Java: Virtual Threads & High-Throughput Services
- Database Integration With Testcontainers — Modern Java: Virtual Threads & High-Throughput Services
- Tying It All Together — Modern Java: Virtual Threads & High-Throughput Services
- Dual Writes And Why They Lose Data — Apache Kafka & Event Streaming
- The Transactional Outbox — Apache Kafka & Event Streaming
- When Kafka Is The Wrong Tool — Apache Kafka & Event Streaming
- One Command, Six Programs — Kubernetes and Cloud Native Associate (KCNA) Exam Prep
- Five Jobs, Five Workloads — Kubernetes and Cloud Native Associate (KCNA) Exam Prep
- Bookings That Survive The Pod: Volumes And Claims — Kubernetes and Cloud Native Associate (KCNA) Exam Prep
- The Image Nobody Tested: Cloud Native Principles — Kubernetes and Cloud Native Associate (KCNA) Exam Prep
- Slow, Or Broken? Metrics, Logs And Traces — Kubernetes and Cloud Native Associate (KCNA) Exam Prep
- Architecture Sprint: The Refunds Review — Kubernetes and Cloud Native Associate (KCNA) Exam Prep
- Pinned For Stability: Images, Registries And Code — Kubernetes and Cloud Native Security Associate (KCSA) Exam Prep
- Encoded Is Not Hidden: Secrets — Kubernetes and Cloud Native Security Associate (KCSA) Exam Prep
- One Pod Away: Network Attackers And Sensitive Data — Kubernetes and Cloud Native Security Associate (KCSA) Exam Prep
- Threat Model Sprint: Name It, Then Stop It — Kubernetes and Cloud Native Security Associate (KCSA) Exam Prep
- Who Built This Image? Supply Chain And Registries — Kubernetes and Cloud Native Security Associate (KCSA) Exam Prep
- Which Benchmark, And Who Checked It? Compliance And Frameworks — Kubernetes and Cloud Native Security Associate (KCSA) Exam Prep
- Audit Day: Final Review — Kubernetes and Cloud Native Security Associate (KCSA) Exam Prep
- Pods, Init Containers And Sidecars — Kubernetes: Production-Grade Container Orchestration
- Jobs And CronJobs — Kubernetes: Production-Grade Container Orchestration
- Troubleshooting: Probes, Logs, exec And CrashLoopBackOff — Kubernetes: Production-Grade Container Orchestration
- StatefulSets, Stable Identity And Data Recovery — Kubernetes: Production-Grade Container Orchestration
- etcd Snapshots And A Tested Restore — Kubernetes: Production-Grade Container Orchestration
- Users, UIDs And The Password File — Linux Fundamentals & Systems Administration
- Groups, And How Shared Access Is Granted — Linux Fundamentals & Systems Administration
- What A Package Manager Guarantees — Linux Fundamentals & Systems Administration
- Server Components: Async Execution & Constraints — Next.js 15 & Modern App Router Architecture
- Serialization Boundaries: Props & Server Guardrails — Next.js 15 & Modern App Router Architecture
- Not Found Handling: not-found.tsx & Programmatic Exits — Next.js 15 & Modern App Router Architecture
- Server Actions: use server Directives & Mutations — Next.js 15 & Modern App Router Architecture
- Server Action Security: Zod Validation & Auth Gates — Next.js 15 & Modern App Router Architecture
- Request Memoization: Automatic Deduplication Tiers — Next.js 15 & Modern App Router Architecture
- Close Phase & Signal Dispatch: Sockets & Teardown — Node.js Internals & Backend Services
- Routing & Middleware: Path Parsing & Async Context — Node.js Internals & Backend Services
- Production Hardening: Graceful Shutdown & Docker — Node.js Internals & Backend Services
- The Three Signals: Logs, Metrics And Traces — Full-Stack Observability: Metrics, Tracing & Logging
- Cardinality And How It Bankrupts You — Full-Stack Observability: Metrics, Tracing & Logging
- Prometheus Scraping And The Pull Model — Full-Stack Observability: Metrics, Tracing & Logging
- Traces, Spans And Context Propagation — Full-Stack Observability: Metrics, Tracing & Logging
- Observability Sprint: One Failed Checkout — Prometheus Certified Associate (PCA) Exam Prep
- Where Did Two Hours Go? Prometheus Architecture — Prometheus Certified Associate (PCA) Exam Prep
- Off By Five: What Prometheus Is Not For — Prometheus Certified Associate (PCA) Exam Prep
- A Database You Cannot Recompile: Exporters — Prometheus Certified Associate (PCA) Exam Prep
- Seventy Seven Percent, Book Now? The Full Mock — Prometheus Certified Associate (PCA) Exam Prep
- HTML Forms And Dynamic Programs — Hands-on Python: Complete Video Course & Book
- A Standard Library Tour — Hands-on Python: Complete Video Course & Book
- Suspense Architecture: Promises, Fallbacks, And Co-ordination — React 19 & Modern Component Architecture
- SOC Operating Models, Tiers & Key Performance Metrics — Security Operations & Threat Hunting (SOC)
- SIEM Architecture: Ingestion Pipelines & Indexing — Security Operations & Threat Hunting (SOC)
- Windows Event Logs, Sysmon & Linux Auditd Telemetry — Security Operations & Threat Hunting (SOC)
- Incident Triage, Severity Scoping & Communication — Security Operations & Threat Hunting (SOC)
- Containment & Eradication: Host, Net & Identity — Security Operations & Threat Hunting (SOC)
- Recovery & System Validation Testing — Security Operations & Threat Hunting (SOC)
- Post-Incident Review & Root Cause Analysis — Security Operations & Threat Hunting (SOC)
- The Threat Model Habit — Application Security & Threat Modeling for Engineers
- Authentication Versus Authorisation — Application Security & Threat Modeling for Engineers
- Injection In All Its Forms — Application Security & Threat Modeling for Engineers
- Broken Object Level Authorization — Application Security & Threat Modeling for Engineers
- Rate Limiting And Resource Consumption — Application Security & Threat Modeling for Engineers
- Why Tables And Relations Beat Files — PostgreSQL, Indexing & Relational Data Modeling
- Where PostgreSQL Differs From SQLite — PostgreSQL, Indexing & Relational Data Modeling
- What A Design Is For, And How To Run A Design Discussion — Scalable System Design & Distributed Architecture
- Back Of The Envelope Estimation: Traffic And Throughput — Scalable System Design & Distributed Architecture
- Back Of The Envelope Estimation: Storage And Bandwidth — Scalable System Design & Distributed Architecture
- Latency Numbers Every Engineer Should Know — Scalable System Design & Distributed Architecture
- The Storage Decision: Relational Versus Document — Scalable System Design & Distributed Architecture
- The Storage Decision: Key Value, Search And Blob — Scalable System Design & Distributed Architecture
- Consistency, And The Truth About CAP — Scalable System Design & Distributed Architecture
- Eventual Consistency And What It Costs A Product — Scalable System Design & Distributed Architecture
- Caching Strategies And Topology — Scalable System Design & Distributed Architecture
- Cache Invalidation And The Three Hard Cases — Scalable System Design & Distributed Architecture
- The Difference Between A Queue And A Log — Scalable System Design & Distributed Architecture
- Idempotency, And Exactly Once As A Fiction — Scalable System Design & Distributed Architecture
- Load Balancing And The Failure Modes It Introduces — Scalable System Design & Distributed Architecture
- Monolith Versus Services: The Honest Trade Offs — Scalable System Design & Distributed Architecture
- Worked Design One: Ticket Booking, Correctness First — Scalable System Design & Distributed Architecture
- Worked Design One: Scaling The Ticket Booking System — Scalable System Design & Distributed Architecture
- Providers And The required_providers Block — Infrastructure as Code with Terraform
- Predicting Changes, Then Applying Them — Infrastructure as Code with Terraform
- Simulating A Managed Database — Infrastructure as Code with Terraform
- The Test Pyramid And Where It Is Wrong — Automated Testing, TDD & Quality Engineering
- Integration Testing With Containers — Automated Testing, TDD & Quality Engineering
- Testing With Real Databases — Automated Testing, TDD & Quality Engineering
- Literal Types: String, Number, Boolean Literals And const — Production TypeScript
- void, undefined And null: Exact Optional Property Types — Production TypeScript
- Optional Properties, Readonly And Index Signatures — Production TypeScript
- Union Types, Intersections And Property Conflicts — Production TypeScript
- Tuples: Fixed Length, Labeled Elements And Variadic Tuples — Production TypeScript
- The in Operator And Instanceof Narrowing — Production TypeScript
- Generic Interfaces, Classes And Type Aliases — Production TypeScript
- Generic Constraints: extends, keyof And Indexed Access — Production TypeScript
- Core Utilities: Partial, Required, Readonly, Pick And Omit — Production TypeScript
- Union Utilities: Exclude, Extract, NonNullable And Awaited — Production TypeScript
- Declaration Files, Ambient Namespaces And Module Augmentation — Production TypeScript
- Modern Decorators: Stage 3 Standards And Class Metadata — Production TypeScript
- The Spine Artifact: Generating Typed Models From OpenAPI — Production TypeScript
- The Plan That Wanted To Destroy Production — HashiCorp Terraform Associate (004) Exam Prep
- Dependencies, depends_on And Lifecycle Rules — HashiCorp Terraform Associate (004) Exam Prep
- Sensitive Data, Ephemeral Values And Secrets From Vault — HashiCorp Terraform Associate (004) Exam Prep
- Module Scope: What Goes In, What Comes Out — HashiCorp Terraform Associate (004) Exam Prep
- One File, Five Services: Stacks From Compose Files — Docker Certified Associate (DCA) Exam Prep
- Where Do The Tasks Land? Labels, Constraints And Templates — Docker Certified Associate (DCA) Exam Prep
- Stuck In Pending: Troubleshooting Services And Reading docker inspect — Docker Certified Associate (DCA) Exam Prep
- The Same Shop On Kubernetes: Pods, Services And Storage For The DCA — Docker Certified Associate (DCA) Exam Prep
- Orchestration Sprint: Eight Calls In Eight Minutes — Docker Certified Associate (DCA) Exam Prep
- Networking Sprint: Eight Questions On Bridges, Meshes And Ports — Docker Certified Associate (DCA) Exam Prep
- Who Let Femi In? UCP Roles, Grants, LDAP And Client Bundles — Docker Certified Associate (DCA) Exam Prep
- Storage Sprint: Eight Questions On Layers, Drivers And Volumes — Docker Certified Associate (DCA) Exam Prep
- The Pager Goes Off At 2 A.M.: A Three-Question Triage — CompTIA Linux+ (XK0-006) Exam Prep
- The App In /bin That Vanished: The FHS, Distributions And Licences — CompTIA Linux+ (XK0-006) Exam Prep
- No Space For Tonight's Scans: Partitions And LVM On Both Families — CompTIA Linux+ (XK0-006) Exam Prep
- Twelve Old Servers, Two New Hosts: KVM, QEMU, libvirt And Disk Images — CompTIA Linux+ (XK0-006) Exam Prep
- The Upgrade That Broke Nginx: Packages, Repositories And Pins On Both Families — CompTIA Linux+ (XK0-006) Exam Prep
- One Word Locked Out Every Directory User: PAM, SSSD, LDAP And Kerberos — CompTIA Linux+ (XK0-006) Exam Prep
- What Changed Last Night? Integrity, Scans, Benchmarks And Secure Deletion — CompTIA Linux+ (XK0-006) Exam Prep
- Forty Servers By Teatime: Ansible Playbooks, Inventories And Puppet Manifests — CompTIA Linux+ (XK0-006) Exam Prep
- The Assistant Was Confident: Reviewing AI-Generated Code, Prompts And Data — CompTIA Linux+ (XK0-006) Exam Prep
- The Customers Noticed First: SLAs, SLOs, Alerts, SNMP And Log Aggregation — CompTIA Linux+ (XK0-006) Exam Prep
- Forbidden, With Perfect Permissions: Paths, ACL Masks And SELinux Denials — CompTIA Linux+ (XK0-006) Exam Prep
- Kernel Parameters: Now, At Boot, And Which File Wins — Linux Foundation Certified System Administrator (LFCS) Exam Prep
- Scheduling: cron, systemd Timers And at — Linux Foundation Certified System Administrator (LFCS) Exam Prep
- Recovering From Boot, File System And Disk Failures — Linux Foundation Certified System Administrator (LFCS) Exam Prep
- SELinux: Modes, Labels, Ports And Booleans That Last — Linux Foundation Certified System Administrator (LFCS) Exam Prep
- Packet Filtering With nftables: A Default Drop That Stays Up — Linux Foundation Certified System Administrator (LFCS) Exam Prep
- Swap: Partitions, Volumes, Files And Priorities — Linux Foundation Certified System Administrator (LFCS) Exam Prep
- Storage Performance: Busy, Slow, Or Both — Linux Foundation Certified System Administrator (LFCS) Exam Prep
- User Limits: Who Gets Which Number At Login — Linux Foundation Certified System Administrator (LFCS) Exam Prep
- Inventory Variables: Ranges, group_vars And host_vars — RHCE in Ansible (EX294): Automate Red Hat Systems
- Privilege Escalation: sudo Rules And become — RHCE in Ansible (EX294): Automate Red Hat Systems
- Facts And Magic Variables: Let Each Node Describe Itself — RHCE in Ansible (EX294): Automate Red Hat Systems
- Conditionals: register, when, changed_when And failed_when — RHCE in Ansible (EX294): Automate Red Hat Systems
- Roles: The Directory Ansible Expects, Defaults And Handlers — RHCE in Ansible (EX294): Automate Red Hat Systems
- Packages And Repositories: yum_repository And dnf — RHCE in Ansible (EX294): Automate Red Hat Systems
- Ansible Vault: Secrets Encrypted, Runs Without A Prompt — RHCE in Ansible (EX294): Automate Red Hat Systems
References
- PostgreSQL: what is PostgreSQL?
- PostgreSQL: about
- PostgreSQL docs: The SQL language
- AWS: What is a database?
- PostgreSQL documentation
- Volumes (Docker docs)
- man7: passwd(5)
- Prisma Data Guide: What is an ORM?
- sqlite3 documentation
- SQLite: about
- PostgreSQL documentation: Table Basics
- What is Amazon Relational Database Service?
- PostgreSQL: PREPARE
Certification courses
- AWS AIP-C01 course and practice exam: AI engineering with LLM apps, RAG and agents
- AWS Cloud Practitioner course and practice exam: CLF-C02
- AWS DevOps Engineer Professional course and practice exam: DOP-C02
- AWS Solutions Architect Associate course and practice exam: SAA-C03
- AZ-104 course and practice exam: Microsoft Azure Administrator
- AZ-400 course and practice exam: Microsoft Azure DevOps Engineer Expert
- AZ-900 course and practice exam: Microsoft Azure Fundamentals
- CKAD course and practice exam: Certified Kubernetes Application Developer
- CKS course and practice exam: Certified Kubernetes Security Specialist
- CompTIA Cloud+ course and practice exam: CV0-004
- CCDAK and CCAAK course and practice exams: Confluent Apache Kafka certifications
- KCNA course and practice exam: Kubernetes and Cloud Native Associate
- KCSA course and practice exam: Kubernetes and Cloud Native Security Associate
- PCA course and practice exam: Prometheus Certified Associate
- Terraform Associate course and practice exam: HashiCorp Terraform Associate (004)
- DCA course and practice exam: Docker Certified Associate
- CompTIA Linux+ course and practice exam: XK0-006
- LFCS course and practice exam: Linux Foundation Certified System Administrator
- RHCE course and practice exam: Red Hat Certified Engineer in Ansible (EX294)