Skip to content
∂
Master's of Information Technology
Semester I
Semester II
Semester III
Semester IV
← Semester III
MIT608
Database Administration
▼
Contents
01
Introduction to Oracle Database and DBA Responsibilities
Oracle Database Architecture and the DBA Paradigm
Oracle Multitenant Architecture and Pluggable Database Management
Database Installation, DBCA, and Administrative Tools
02
Oracle Instance Configuration and Storage Management
Oracle Instance Configuration via Initialization Parameter Files
Control Files and Online Redo Log Multiplexing
Database Archiving, Tablespaces, and Startup/Shutdown
03
Security and User Management
Database Security and Auditing
Authentication, Authorization, and User Management
Privilege, Role, and Profile Management
04
Managing Database Objects
Tables, Constraints, Sequences, and Indexes
Table Partitioning and Views
PL/SQL, Cursors, and Subprograms
05
Backup, Recovery and High Availability
Backup Solutions, Terminology, and Strategy
Types of Failure and Recovery Processes
RMAN, Data Pump, and High Availability
06
Database Tuning
Performance Tuning Methodology and Instance Tuning
AWR, ADDM, and SQL Tuning
07
Task Automation with the Scheduler
Scheduler Architecture and Job Management
Time-Based and Event-Based Schedules
§
Syllabus
Library
Library
›
Semester III
›
Database Administration
🗄
Semester III · Subject
Database Administration
7 of 7 chapters available. Each chapter is one continuous read.
01
Introduction to Oracle Database and DBA Responsibilities
6 topics
02
Oracle Instance Configuration and Storage Management
7 topics
03
Security and User Management
6 topics
04
Managing Database Objects
6 topics
05
Backup, Recovery and High Availability
6 topics
06
Database Tuning
4 topics
07
Task Automation with the Scheduler
3 topics