Introduction to Database Management-Overview of Database Management Tasks
Introduction to Relational Database Administration
Day in the Life of a Database Administrator
()
Database Management Lifecycle
()
Summary & Highlights
Introduction to Database Management-Server Objects and Hierarchy
Database Objects
()
System Objects and Database Configuration
()
Database Storage
()
Summary & Highlights
Managing Databases-Backup and Restore Databases
Introduction to Backup and Restore
()
Types of Backup
()
Backup Policies
()
Using Database Transaction Logs for Recovery
()
Summary & Highlights
Managing Databases-Security and User Management
Overview of Database Security
()
Users, Groups, and Roles
()
Managing Access to Databases and Their Objects
()
Auditing Database Activity
()
Encrypting Data
()
Summary & Highlights
Monitoring and Optimization-Monitoring and Optimization
Overview of Database Monitoring
()
Monitoring Usage and Performance - Part 1
()
Monitoring Usage and Performance - Part 2
()
Optimizing Databases
()
Optimizing Queries
Using Indexes
()
Summary & Highlights
Troubleshooting & Automation-Troubleshooting & Automation
Troubleshooting Common Issues
()
Using Status Variables, Error Codes, and Documentation
()
Using Logs for Troubleshooting
()
Overview of Automating Database Tasks
()
Automating Reports and Alerts
()
Summary & Highlights
Final Assignment and Final Exam-Final Assignment
Instructions for Peer-graded assignment
Final Assignment and Final Exam-Course Wrap Up
Congratulations & Next Steps
Team & Acknowledgements