Relational Database Administration

BY
IBM via Coursera

Lavel

Intermediate

Mode

Online

Duration

5 Weeks

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

Yes

certificate providing authority

Coursera

The syllabus

Module 1: Introduction to Database Management

Videos
  • Day in the life of an Data Administrator
  • Database Management Lifecycle
  • Database Objects
  • System Objects and Database Configuration
  • Database Storage
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

Mr Ramesh Sannareddy
Instructor
IBM

Other Bachelors

Mr Rav Ahuja

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

4 Weeks Online
Intermediate
Free

Building Batch Data Pipelines on GCP

Google via Coursera

6 Weeks Online
Intermediate

Enterprise Database Migration

Google via Coursera

11 Weeks Online
Intermediate

Oracle SQL Practice

LearnQuest via Coursera

3 Weeks Online
Intermediate
Free

Advanced Database Queries

NYU via Edx

5 Weeks Online
Intermediate
Free

Database Systems Concepts and Design

Georgia Tech via Udacity

16 Weeks Online
Intermediate
Free

Database Management Essentials

CU Denver via Coursera

12 Weeks Online
Intermediate

Courses of your Interest

Salesforce Administrator and App Builder

Salesforce Administrator and App Builder

SkillUp Online via Simplilearn

16 Hours Online
Intermediate
Free
Introduction to Medical Software

Introduction to Medical Software

Yale University, New Haven via Coursera

3 Weeks Online
Intermediate
Free

Google Cloud Architect Program

Google Cloud via SkillUp Online

11 Weeks Online
Intermediate
₹ 54,999

Google Cloud Architect Program

Google via SkillUp Online

11 Weeks Online
Intermediate
₹ 54,999
Information Security Design and Development

Information Security Design and Development

Coventry University, Coventry via Futurelearn

10 Weeks Online
Intermediate
Ethics Laws and Implementing an AI Solution on Mic...

Ethics Laws and Implementing an AI Solution on Mic...

CloudSwyft Global Systems, Inc via Futurelearn

14 Weeks Online
Intermediate
Network Security and Defence

Network Security and Defence

Coventry University, Coventry via Futurelearn

10 Weeks Online
Intermediate

Cyber Security Foundations Start Building Your Car...

EC-Council via Futurelearn

15 Weeks Online
Intermediate
Applied Data Analysis

Applied Data Analysis

CloudSwyft Global Systems, Inc via Futurelearn

14 Weeks Online
Intermediate
₹ 900

More Courses by IBM

AI Applications With Watson

IBM via Edx

3 Weeks Online
Intermediate
Free

Site Reliability Engineers Infrastructure Resilien...

IBM via Edx

6 Weeks Online
Intermediate
Free

Python for Data Science Project

IBM via Edx

1 Week Online
Intermediate
Free

Site Reliability Engineering Fundamentals and Secu...

IBM via Edx

5 Weeks Online
Intermediate
Free

Site Reliability Engineering Capstone

IBM via Edx

4 Weeks Online
Intermediate
Free

Blockchain Framework and Platforms

IBM via Edx

2 Weeks Online
Intermediate
Free

Introduction to System Programming on IBM Z

IBM via Edx

3 Weeks Online
Intermediate
Free

Smarter Chatbots with Node RED and Watson AI

IBM via Edx

3 Weeks Online
Intermediate
Free

Application Development using Microservices and Se...

IBM via Coursera

6 Weeks Online
Intermediate

Data Topology

IBM via Coursera

3 Weeks Online
Intermediate
Free

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books