Database Management Systems · Administration

Database administration and performance tuning

The ongoing work of keeping a database backed up, monitored, and fast as real usage grows.

Also known as: backup and restore, performance tuning, DBA.

Start a lesson on Database administration and performance tuning

Learn first

• Indexes and B-trees: A sorted, tree-shaped shortcut structure that lets the database find rows without scanning the whole table.
• Query processing and optimization: How the database decides which order to run joins and filters in, to answer a query as cheaply as possible.

Related topics

• Database security and access control: Who's allowed to see or change what, enforced through roles, privileges, and protection against attacks like SQL injection.