• Describe common database administration tasks.
• Define database security measures and create users, groups and roles.
• Perform full and incremental backup and restore procedures.
• Configure a database server including various database parameters and logging.
• Create and manage database objects including tables, schemas, keys and indexes.

Module 1: Introduction to Database Management

• Day in the Life of a Database Administrator

• Database Management Lifecycle

• Database Objects

• System Objects and Database Configuration

• Database Storage

Module 2: Managing Databases

• Types of Backup

• Backup Policies

• Using Database Transaction Logs for Recovery

• Overview of Database Security

• Users, Groups, and Roles

• Managing Access to Databases and Their Objects

• Auditing Database Activity

• Encrypting Data

Module 3: Monitoring and Optimization

• Overview of Database Monitoring

• Monitoring Usage and Performance - Part 1

• Monitoring Usage and Performance - Part 2

• Using Indexes

Module 4: Troubleshooting and Automation

• Troubleshooting Common Issues

• Using Status Variables, Error Codes, and Documentation

• Using Logs for Troubleshooting

• Overview of Automating Database Tasks

• Automating Reports and Alerts

Module 5: Final Project