Intermediate
Database Operations Fundamentals
Learn relational database concepts, safe SQL inspection, backup and restore planning, query troubleshooting and access hygiene.
Start this path →What you’ll be able to do
- Inspect schema and query data safely
- Explain transactions, indexes and basic query plans
- Plan database backups, restore tests and least-privilege access
Your route through the course
0 / 10 completedFollow the order for a guided experience. Lessons remain open if you need to revisit or jump ahead.
01Guided lessonRelational data and safe SQL inspectionRead tables and relationships while keeping queries bounded.30 min · Not started02Guided lessonTransactions and data integrityExplain atomic changes, constraints and rollback boundaries.35 min · Not started03Guided lessonIndexes and query plansUnderstand why indexes can improve reads and add write/storage costs.40 min · Not started04Guided lessonDatabase backups and restore drillsPlan consistent backups and prove that a restored database is usable.45 min · Not started05Guided lessonIndexes, query plans and slow queriesExplain how an index may affect a query and what an execution plan can reveal.35 min · Not started06Guided lessonTransactions, locks and consistencyDescribe commit, rollback and the operational risks of long-running transactions.35 min · Not started07Guided lessonRelational tables, keys and constraintsExplore relational tables, keys and constraints through a structured explanation, a safe hands-on exercise and a verification checklist.35 min · Not started08Guided lessonSQL filtering, joins and aggregationExplore sql filtering, joins and aggregation through a structured explanation, a safe hands-on exercise and a verification checklist.35 min · Not started09Guided lessonDatabase users, roles and least privilegeExplore database users, roles and least privilege through a structured explanation, a safe hands-on exercise and a verification checklist.35 min · Not started10Guided lessonBackup consistency and restore verificationExplore backup consistency and restore verification through a structured explanation, a safe hands-on exercise and a verification checklist.35 min · Not started