MIT4002

Data Base Administration
Code: 
MIT4002
Year / Semester: 
4th Semester
Objective: 

To equip students with the knowledge of Database Administration.

Credits: 
2

Introduction

DBMS architecture and data independence, DBA roles and responsibilities

SQL *PLUS Overview

SQL Plus Fundamentals, Producing more readable outputs, Accepting values at urntime, Using iSQL *Plus

Modifying Data

Introduction to DML Statements, Truncating a table, Transaction control language

Managing Constraints

Creating constraints, Dropping constraints, enabling and disabling constaints, deferring constraints checks

Managing Views

Creating and modifying views, Using views, Inserting, Updating and deleting data through views

User Access and Security

Creating and modifying use accounts, creating and using roles, granting and revoking privileges, Managing user groups with profiles

Oracle Overview and Architecture

An overview of logical an physical storage structures, Oracle memory structures, Oracle background processes, connecting to oracle instance, processing SQL command.

Managing Oracle

Starting up the oracle instance, managing sessions, shutting down the oracle instance, instances messages and instance alerts. Control and Redo Log Files

Managing tables, indexes and constraints

Storing data (create, alter, analyzing, querying table information), Managing indexes, Managing constraints, Managing the control files, Maintaining and monitoring redo log files

Managing Users and Security

Profiles, Managing users, managing privileges, managing roles, querying role information

Introduction to Network Administration

Network design considerations, network responsibilities for the DBA, network configuration, Overview of oracle Net features, Oracle Net Stack Architecture

Backup and Recovery Overview

Database backup, restoration and recovery, Types of failure in oracle environment, defining a backup and recovery strategy, Testing the backup and recovery plan

Introduction to performance tuning

brief overview of Tuning methodology, General tuning concepts Starting up the oracle instance, managing sessions, shutting down the oracle instance, instances messages and instance alerts. Control and Redo Log Files

Managing tables, indexes and constraints

Storing data (create, alter, analyzing, querying table information), Managing indexes, Managing constraints, Managing the control files, Maintaining and monitoring redo log files

Managing Users and Security

Profiles, Managing users, managing privileges, managing roles, querying role information

Introduction to Network Administration

Network design considerations, network responsibilities for the DBA, network configuration, Overview of oracle Net features, Oracle Net Stack Architecture

Backup and Recovery Overview

Database backup, restoration and recovery, Types of failure in oracle environment, defining a backup and recovery strategy, Testing the backup and recovery plan

Introduction to performance tuning

brief overview of Tuning methodology, General tuning concepts

Suggested Readings: 

Oracle Database Administration for Microsoft SQL Server DBAs,MALCHER, TMH