Database Management · Beginner level

Beginner level · Module 5 of 5 · 10 guided hours

Database Care: Indexes, Backups and Access

Keep databases fast, safe and recoverable with indexes, backups and basic access control.

Learning objectives

  • Explain and create indexes for common queries
  • Back up and restore a database
  • Apply basic access control and protect personal data

Topics

  • what an index is
  • creating indexes
  • query plans at a glance
  • backup and restore
  • users, roles and permissions
  • personal data and privacy basics

Lessons

  1. Lesson 1 Indexes and Query Speed

    Understand how indexes speed up searches and create them for the columns your queries filter and join on.

    indexfull table scanquery planwrite cost of indexes

  2. Lesson 2 Backups and Restores

    Make regular backups, store them safely and prove that they can be restored.

    backuprestoreoff-site copyrestore test

  3. Lesson 3 Access Control and Personal Data

    Give each person only the access they need and handle personal data responsibly.

    least privilegeusers and rolesGRANT and REVOKEpersonal data

Practical activity

Add indexes for the bursar's common queries, back up the school fees database, restore it into a new file and write an access policy.

Expected outcomes

  • Faster common queries
  • A tested backup and a clear access policy

Assessment

The level project assessed against its criteria, including a demonstrated restore.

Free taster lesson Indexing, Performance & Database Security Read a free self-study lesson on this topic in the Free Course Library.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.