Database Engineering & Data Systems Topics
Database design patterns, optimization, scaling strategies, storage technologies, data warehousing, and operational database management. Covers database selection criteria, query optimization, replication strategies, distributed databases, backup and recovery, and performance tuning at database layer. Distinct from Systems Architecture (which addresses service-level distribution) and Data Science (which addresses analytical approaches).
SQL Joins and Set Operations
Combining data across multiple tables using inner, outer, cross, and self joins, plus set operations (UNION, INTERSECT, EXCEPT). Covers join-key selection, fan-out and row-multiplication pitfalls, merge strategies, and integrating data from disparate sources. A high-frequency interview surface for anyone who queries relational data.
Database Forensics and Data Recovery
Investigative and recovery work on databases: examining database and application artifacts, transaction logs, and residual data to reconstruct activity, plus recovering corrupted or deleted data. Covers evidence integrity and forensic method applied to database systems. A specialized surface for security and forensics roles.