Back close

Course Detail

Course Name Database Administration
Course Code 18CA336
Program M. C. A., M. C. A. ( Offered at Mysuru Campus )
Credits Three
Year Taught 2018
Degree Postgraduate (PG)
School School of Arts and Sciences, School of Engineering
Campus Kochi, Mysuru, Amritapuri

Syllabus

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.

Text Books

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

DISCLAIMER: The appearance of external links on this web site does not constitute endorsement by the School of Biotechnology/Amrita Vishwa Vidyapeetham or the information, products or services contained therein. For other than authorized activities, the Amrita Vishwa Vidyapeetham does not exercise any editorial control over the information you may find at these locations. These links are provided consistent with the stated purpose of this web site.

Admissions Apply Now