Roadmap

DBA / Databases

Маршрут по SQL, моделированию данных, индексам, транзакциям, миграциям, бэкапам и operational DBA.

База

SELECT, filters, joins, aggregates, grouping and safe query reading.

dbadevelopment

Entities, relationships, constraints, normalization and pragmatic schema design.

dbaarchitecturedevelopment

Практика

Indexes, query performance, full scans, composite indexes and write penalties.

dbadevelopmentdevops

Практика

ACID, commit/rollback, isolation levels, locks, deadlocks and concurrent behavior.

dbadevelopment

Schema changes, backwards compatibility, rollout, rollback and large data changes.

dbadevelopmentdevops

Production

Logical and physical backups, restore tests, RPO/RTO and data reliability.

dbadevops

Production

Sessions, locks, long queries, connection pressure and safe operational database diagnostics.

dbadevops

Production

Roles, least privilege, sensitive data, backups, secrets and production data risks.

dbasecurity