IIRF Online > Office Productivity > Oracle > Database Administration > IBM: Relational Database Administration (DBA)
IBM: Relational Database Administration (DBA) by Edx
This course helps you develop the foundational skills required to perform the role of a Database Administrator (DBA) including designing, implementing, securing, maintaining, troubleshooting and automating databases such as MySQL, PostgreSQL and Db2.
Course Highlights
- 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.
Skills you will learn!
Curriculum
5 Topics
Day in the Life of a Database Administrator
Database Management Lifecycle
Database Objects
System Objects and Database Configuration
Database Storage
8 Topics
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
4 Topics
Overview of Database Monitoring
Monitoring Usage and Performance - Part 1
Monitoring Usage and Performance - Part 2
Using Indexes
5 Topics
Troubleshooting Common Issues
Using Status Variables Error Codes and Documentation
Using Logs for Troubleshooting
Overview of Automating Database Tasks
Automating Reports and Alerts
.webp)
IBM: Relational Database Administration (DBA)
Related Database Administration Courses
Thank You!
Your review has been submitted successfully.