Intermediate

Database Operations Fundamentals

Learn relational database concepts, safe SQL inspection, backup and restore planning, query troubleshooting and access hygiene.

10 lessons · 360 minutes of guided study · 1 practical project
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 completed

Follow 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