Course Title: 
Database Administration
Course Code: 
Year Taught: 
Postgraduate (PG)
School of Arts and Sciences
School of Engineering

'Database Administration' is a course offered in M. C. A. (Master of Computer Applications) program at Amrita Vishwa Vidyapeetham.

Introduction: DBMS Architecture and Data Independence - DBA Roles and Responsibilities. SQL * PLUS Overview: SQL plus Fundamentals, Producing more readable outputs, Accepting values at Runtime, Using iSQL *Plus. Modifying Data: Using DML, TCL- Managing Constraints -Managing Views. User Access and Security: Creating and Modifying User Accounts, Managing User Groups with Profiles. Oracle Overview and Architecture: Overview of Logical and Physical Storage Structures. Managing Oracle Instances. Control and Redo Log Files: Managing the Control Files. Managing Tables, Indexes and Constraints. Managing Users and Security. 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: Defining a Backup and Recovery Strategy, Testing- The Backup and Recovery Plan. Introduction to Performance Tuning: Brief Overview of Tuning methodology, General Tuning Concepts.

  • Craig S. Mullins, “Database Administration: The Complete Guide to DBA Practices andProcedures”, Second Edition, Addison Wesley, 2012.
  • C.J. Date, “Introduction to Database Systems”, Eighth Edition, Addison Wesley, 2003.
  • Chip Dawes, Biju Thomas, “Introduction to Oracle 9i SQL”, BPB, 2002.
  • Bob Bryla, Biju Thomas, “Oracle 9i DBA Fundamental I”, BPB, 2002.