Databases
Databases sit at the core of nearly every application. This hub gathers resources on relational databases, SQL, Oracle administration, data mining techniques, and the data structures that underpin efficient storage and retrieval. Whether you are writing your first query or optimizing production workloads, you will find reading lists and context here to sharpen your skills.
Starter Path
A structured path through data fundamentals, query writing, and database design.
Data & Databases Path →Curated Reading List
Oracle Reading List
Oracle Database administration, PL/SQL programming, performance tuning, and RAC architecture resources.
Data Mining Reading List
From statistical foundations to machine learning pipelines—classification, clustering, association rules, and practical data analysis.
Data Structures and Algorithms Using Visual Basic.NET
Core data structures implemented in VB.NET—arrays, linked lists, trees, graphs, sorting, and searching algorithms.
Google Apps: The Missing Manual
Practical guide to Google's productivity suite—Sheets formulas, Apps Script automation, and data management workflows.
Recent Updates
Zero-Downtime Database Changes: Safe Migration Patterns
Patterns for deploying database schema changes without downtime. Covers expand-contract migrations, backward-compatible columns, and online index builds.
PostgreSQL 18 Skip Scan for Multicolumn Indexes
How PostgreSQL 18 skip scan optimizes queries on multicolumn indexes. Covers when skip scan activates, benchmark patterns, and index design implications.
PostgreSQL UUIDv7: Time-Ordered IDs for Modern Applications
How UUIDv7 solves the performance problems of UUIDv4 in PostgreSQL. Covers index locality, generation strategies, and migration from serial or UUIDv4 columns.
PostgreSQL 18 Upgrade Guide: Performance and Operations
What changes in PostgreSQL 18 and how to plan your upgrade. Covers new performance features, breaking changes, pg_upgrade steps, and rollback strategies.
How to Use This Hub
- → Start with relational basics before moving to specialized topics like data mining
- → Oracle resources cover both development and DBA perspectives
- → Data structure fundamentals apply across all database work
- → Cross-reference with Programming Languages for language-specific database integrations