Monthly Subscription Starting at AED 99 + VAT

Relational Database Administration (DBA)
  • Level Foundation
  • المدة 21 ساعات hours
  • الطبع بواسطة IBM
  • Offered by

عن

Ongoing and proactive management is critical to the security and performance of database management systems. Database administration is the function of managing the operational aspects of database systems and maintaining them. Database administrators work to ensure that applications make the most efficient use of databases and that physical resources are used adequately and efficiently. In this course, you will discover some of the activities, techniques, and best practices for managing a database. You will learn about configuring and upgrading database server software and related products. You will also learn about database security; how to implement user authentication, assign roles, and assign object-level permissions. You will also gain an understanding of how to perform backup and restore procedures in case of system failures. You will learn about how to optimize databases for performance, monitor databases, collect diagnostic data, and access error information to help you resolve issues that may occur. Many of these tasks are repetitive, so you will learn how to schedule maintenance activities and regular diagnostic tests and send automated messages of the success or failure of a task.

الوحدات

Overview of Database Management Tasks

    • 2 Videos
    • 2 Readings
    • 1 ExternalTool
    • 2 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Overview of Database Management Tasks
  • Graded Quiz: Overview of Database Management Tasks

1 External Tool

  • (Optional) Obtain IBM Cloud Feature Code and Activate Trial Account

2 Videos

  • Day in the Life of a Database Administrator
  • Database Management Lifecycle

2 Readings

  • Introduction to Relational Database Administration
  • Summary & Highlights

Server Objects and Hierarchy

    • 3 Videos
    • 1 Readings
    • 2 ExternalTool
    • 2 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Server Objects and Hierarchy
  • Graded Quiz: Server Objects and Hierarchy

2 External Tool

  • Hands-on Lab: MySQL Configuration, Storage Engines, and System Tables
  • Hands-on Lab: PostgreSQL Instance Configuration and System Catalog

3 Videos

  • Database Objects
  • System Objects and Database Configuration
  • Database Storage

1 Readings

  • Summary & Highlights

Backup and Restore Databases

    • 4 Videos
    • 1 Readings
    • 3 ExternalTool
    • 3 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Back Up and Restore Databases
  • Graded Quiz: Back Up and Restore Databases

3 External Tool

  • Hands-on Lab: Upload and Export using Datasette
  • Hands-on Lab: Backup and Restore using PostgreSQL
  • Hands-on Lab: Backup and Restore using MySQL

4 Videos

  • Introduction to Backup and Restore
  • Types of Backup
  • Backup Policies
  • Using Database Transaction Logs for Recovery

1 Readings

  • Summary & Highlights

Security and User Management

    • 5 Videos
    • 1 Readings
    • 2 ExternalTool
    • 1 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Security and User Management
  • Graded Quiz: Security and User Management

2 External Tool

  • Hands-on Lab: MySQL User Management, Access Control, and Encryption
  • Hands-on Lab: User Management and Access Control in PostgreSQL

5 Videos

  • Overview of Database Security
  • Users, Groups, and Roles
  • Managing Access to Databases and Their Objects
  • Auditing Database Activity
  • Encrypting Data

1 Readings

  • Summary & Highlights

Monitoring and Optimization

    • 5 Videos
    • 2 Readings
    • 3 ExternalTool
    • 2 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Monitoring and Optimization
  • Graded Quiz: Monitoring and Optimization

3 External Tool

  • Hands-on Lab: Improving Performance of Slow Queries in MySQL
  • Hands-on Lab: Monitoring and Optimizing your Databases in MySQL
  • Hands-on Lab: Monitoring and Optimizing your Databases in PostgreSQL

5 Videos

  • Overview of Database Monitoring
  • Monitoring Usage and Performance - Part 1
  • Monitoring Usage and Performance - Part 2
  • Optimizing Databases
  • Using Indexes

2 Readings

  • Optimizing Queries
  • Summary & Highlights

Troubleshooting & Automation

    • 5 Videos
    • 1 Readings
    • 2 ExternalTool
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Troubleshooting and Automation
  • Graded Quiz: Troubleshooting and Automation

2 External Tool

  • Hands-on Lab: Troubleshooting with PostgreSQL
  • Hands-on Lab: Automating Tasks in MySQL using Shell Scripts

5 Videos

  • Troubleshooting Common Issues
  • Using Status Variables, Error Codes, and Documentation
  • Using Logs for Troubleshooting
  • Overview of Automating Database Tasks
  • Automating Reports and Alerts

1 Readings

  • Summary & Highlights

Final Assignment

    • 1 Readings
    • 1 PeerReview
    • 4 ExternalTool
Show info about module content

4 External Tool

  • Hands-on Lab: Final Assignment - Database Administration - Part 1
  • Hands-on Lab: Final Assignment - Database Administration - Part 2
  • Hands-on Lab: Final Assignment - Database Administration - Part 3
  • (Optional) Final Assignment - Database Administration - Part 3 using Db2

1 Peer Review

  • Peer Review: Peer Reviewed Assignment

1 Readings

  • Instructions for Peer-graded assignment

Final Quiz

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Graded Quiz: Final Quiz

1 Readings

  • Final Quiz Instructions

Course Wrap Up

    • 2 Readings
Show info about module content

2 Readings

  • Congratulations & Next Steps
  • Team & Acknowledgements

Auto Summary

Dive into Relational Database Administration with this comprehensive beginner course. Ideal for IT and Computer Science enthusiasts, it covers database management lifecycle, optimization, security, and maintenance practices. Taught by Coursera experts, the 1260-minute program includes video lectures and hands-on labs. Available through Starter and Professional subscriptions, it's perfect for aspiring Database Administrators.

Ramesh Sannareddy
Instructors

Ramesh Sannareddy

Rav Ahuja
Instructors

Rav Ahuja