Courses

Relational Database Management System (RDBMS) Administration

By February 26, 2025 No Comments

Course Objectives

This course covers the essential RDBMS Administration concepts and applications in order to ensure that a Database Server will cover all its tasks in a fast, reliable and secure manner with minimum response times, data loss and security issues.

 

Contents

  1. RDBMS Basic Concepts

1.1 Introduction

1.2 Job roles involved

  1. Installing an RDBMS

2.1 System pre requirements

2.2 Storage plan

2.3 Setting up the software

2.4 Creating separate databases

  1. Security Management

3.1 Creating users and groups

3.2 Limiting user storage quota-privileges

3.3 Limiting user resources consumption

  1. Backup

4.1 Database operating modes

4.2 Backup types

  1. Recovery

5.1 Recovery methods

5.2 Minimizing time to recover

  1. Performance Tuning Concepts

6.1 Introduction

6.2 Factors influencing performance

  1. Indexes

7.1 Index types

7.2 SQL optimizer

7.3 Explain plan

  1. Optimizing Performance

8.1 Best practices

 

Entry Requirements

Basic IT and Database-SQL concepts understanding preferably with hands-on background is required from the participants.

 Target Group

Technical personnel involved in administering a RDBMS

 Mode of Delivery: Live, instructor lead learning in a physical or virtual classroom

 Duration: The duration of this course is 3 full training days

Language: English

Participants: The maximum number of participants for this course is 12 persons

 

Time schedule

The time required always depends on the knowledge of the attending participants and the schedule stated below can be used as estimate.

   
Course Structure Hours Days
RDBMS Basic Concepts Introduction 1 Day 1
Job roles involved
Installing an RDBMS System pre requirements 3
Storage plan
Setting up the software
Creating separate databases
Security Management Creating users and groups 2
Limiting user storage quota-privileges
Limiting user resources consumption
Backup Database operating modes 1 Day 2
Backup types 2
Recovery Recovery methods 1
Minimizing time to recover 2
Performance Tuning Concepts Introduction 1 Day 3
Factors influencing performance 1
Indexes Index types 1
SQL optimizer 1
Explain plan 1
Optimizing Performance Best practices 1