- Day in the life of an Data Administrator
- Database Management Lifecycle
- Database Objects
- System Objects and Database Configuration
- Database Storage
Beginner
Online
5 Weeks
Free
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Type of course
certificate availability
certificate providing authority
The syllabus
Week 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
Week 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
Week 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
Week 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
Week 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
NoSQL Database
Great Learning
Introduction to NoSQL Databases
IBM via Coursera
NoSQL Database Basics
IBM via Edx
Relational Database Basics
IBM via Edx
Introduction to Database Queries
NYU via Edx
Introduction to Relational Databases RDBMS
IBM via Coursera
Databases and Structured Query Language for Data S...
IBM via Coursera
Courses of your interest
C++ Foundation
PW Skills
Data Science Foundations to Core Bootcamp
Springboard
User Experience Design And Research
UM–Ann Arbor via Futurelearn
Data Analysis with Excel for Complete Beginners
CloudSwyft Global Systems, Inc via Futurelearn
Artificial intelligence Design and Engineering wit...
CloudSwyft Global Systems, Inc via Futurelearn
Data Science Fundamentals on Microsoft Azure
CloudSwyft Global Systems, Inc via Futurelearn
Artificial Intelligence Projects
Great Learning
More Courses by IBM
R Programming Basics for Data Science
IBM via Edx
Threat Intelligence Lifecycle Fundamentals
IBM via Edx
Introduction to Data Engineering
IBM via Coursera
Introduction to the Threat Intelligence Lifecycle
IBM via Coursera
Introduction to Web Development with HTML CSS Java...
IBM via Coursera
Introduction to Devops
IBM via Coursera
Data Scientist Career Guide and Interview Preparat...
IBM via Coursera
Data Analyst Career Guide and Interview Preparatio...
IBM via Coursera
Introduction to Software Programming and Databases
IBM via Coursera