DATABASE

Breaking down SQL Server schemas, views, indexes, and comparing object-oriented databases with relational ones.

A deep dive into SQL Server storage structures, overflow considerations, transaction logs, and practical backup/restore strategies.

A quick guide to RAID usage, capacity planning, workload considerations, and key Oracle concepts.

An informal guide to core database design terminologies, dependencies, normalization, and best practices.

Notes on SQL operator precedence, RAID fundamentals, transactional vs analytical databases, and the difference between DBMS and filesystems.