- Day in the life of an Data Administrator
- Database Management Lifecycle
- Database Objects
- System Objects and Database Configuration
- Database Storage
Intermediate
Online
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
certificate availability
certificate providing authority
The syllabus
Module 1: Introduction to Database Management
Videos
Readings
- Introduction to Relational Database Administration
- Summary & Highlights
- Summary & Highlights
Practice Exercises
- Practice Quiz: Overview of Database Management Tasks
- Graded Quiz: Overview of Database Management Tasks
- Practice Quiz: Server Objects and Hierarchy
- Graded Quiz: Server Objects and Hierarchy
Module 2: Managing Databases
Videos
- Introduction to Backup and Restrore
- 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
Readings
- Summary & Highlights
- Summary & Highlights
Practice Exercises
- Practice Quiz: Back Up and Restore Databases
- Graded Quiz: Back Up and Restore Databases
- Practice Quiz: Security and User Management
- Graded Quiz: Security and User Management
Module 3: Monitoring and Optimization
Videos
- Overview of Database Monitoring
- Monitoring Usage and Performance - Part 1
- Monitoring Usage and Performance - Part 2
- Optimizing Databases
- Using Indexes
Readings
- Optimizing Queries
- Summary & Highlights
Practice Exercises
- Practice Quiz: Monitoring and Optimization
- Graded Quiz: Monitoring and Optimization
Module 4: Troubleshooting & Automation
Videos
- Troubleshooting Common Issues
- Using Status Variables, Error Codes, and Documentation
- Using Logs for Troubleshooting
- Overview of Automating Database Tasks
- Automating Reports and Alerts
Readings
- Summary & Highlights
Practice Exercises
- Practice Quiz: Troubleshooting and Automation
- Graded Quiz: Troubleshooting and Automation
Module 5: Final Assignment and Final Exam
Readings
- Instructions for Peer-graded assignment
- Congratulations & Next Steps
- Team & Acknowledgements
Practice Exercises
- Graded Quiz: Final Quiz
Instructors

Mr Ramesh Sannareddy
Instructor
IBM
Other Bachelors

Mr Rav Ahuja
Global Program Director
IBM
B.E /B.Tech, MBA
Articles
Popular Articles
Latest Articles
Similar Courses


Amazon DynamoDB Building NoSQL Database Driven App...
Amazon Web Services via Edx


Building Batch Data Pipelines on GCP
Google via Coursera


Enterprise Database Migration
Google via Coursera


Oracle SQL Practice
LearnQuest via Coursera


Advanced Database Queries
NYU via Edx


Database Systems Concepts and Design
Georgia Tech via Udacity


Database Management Essentials
CU Denver via Coursera
Courses of your interest

Salesforce Administrator and App Builder
SkillUp Online via Simplilearn

Introduction to Medical Software
Yale University, New Haven via Coursera
Google Cloud Architect Program
Google Cloud via SkillUp Online
Google Cloud Architect Program
Google via SkillUp Online

Information Security Design and Development
Coventry University, Coventry via Futurelearn

Ethics Laws and Implementing an AI Solution on Mic...
CloudSwyft Global Systems, Inc via Futurelearn

Network Security and Defence
Coventry University, Coventry via Futurelearn
Cyber Security Foundations Start Building Your Car...
EC-Council via Futurelearn

Applied Data Analysis
CloudSwyft Global Systems, Inc via Futurelearn
More Courses by IBM
AI Applications With Watson
IBM via Edx
Python for Data Science Project
IBM via Edx
Site Reliability Engineering Capstone
IBM via Edx
Blockchain Framework and Platforms
IBM via Edx
Introduction to System Programming on IBM Z
IBM via Edx
Smarter Chatbots with Node RED and Watson AI
IBM via Edx
Application Development using Microservices and Se...
IBM via Coursera
Data Topology
IBM via Coursera