Database Administration - Syllabus
Embark on a profound academic exploration as you delve into the Database Administration course () within the distinguished Tribhuvan university's BCA department. Aligned with the BCA Curriculum, this course (CACS405) seamlessly merges theoretical frameworks with practical sessions, ensuring a comprehensive understanding of the subject. Rigorous assessment based on a 100 marks system, coupled with a challenging passing threshold of , propels students to strive for excellence, fostering a deeper grasp of the course content.
This 6 credit-hour journey unfolds as a holistic learning experience, bridging theory and application. Beyond theoretical comprehension, students actively engage in practical sessions, acquiring valuable skills for real-world scenarios. Immerse yourself in this well-structured course, where each element, from the course description to interactive sessions, is meticulously crafted to shape a well-rounded and insightful academic experience.
Course Description
This course provides the comprehensive knowledge about relational database management
system in administrative approach to integrate in enterprise levelof database in network
environment which encompasses with oracle database instances Management, database
installment in network environment, implementing user role and privileges, multitenant database
management, back and recovery.
Objectives: The general objectives of this course is to provide core knowledge of administrative
works on relational database management system
Units
Key Topics
-
Introduction to Computers
IN-01An overview of computers and their significance in today's world. This topic sets the stage for understanding the basics of computers.
-
Digital and Analog Computers
IN-02Understanding the difference between digital and analog computers, their characteristics, and applications.
-
Characteristics of Computers
IN-03Exploring the key characteristics of computers, including input, processing, storage, and output.
-
History of Computers
IN-04A brief history of computers, from their inception to the present day, highlighting key milestones and developments.
-
Generations of Computers
IN-05Understanding the different generations of computers, including their features, advantages, and limitations.
-
Classification of Computers
IN-06Categorizing computers based on their size, functionality, and application, including desktops, laptops, and mobile devices.
-
The Computer System
IN-07An in-depth look at the components of a computer system, including hardware and software.
-
Applications of Computers
IN-08Exploring the various applications of computers in different fields, including business, education, and healthcare.
Key Topics
-
Introduction to Matrices
MA-1This topic introduces the concept of matrices, including their definition, notation, and basic operations. It lays the foundation for further study of matrices and their applications.
-
Types of Matrices
MA-2This topic covers the different types of matrices, including square matrices, diagonal matrices, identity matrices, and zero matrices. It explains their properties and characteristics.
-
Equality of Matrices
MA-3This topic defines and explains the concept of equality of matrices, including the conditions for two matrices to be equal and the rules for comparing matrices.
-
Algebra of Matrices
MA-4This topic covers the basic algebraic operations of matrices, including addition, subtraction, multiplication, and scalar multiplication. It explains the rules and properties of these operations.
-
Determinants
MA-5This topic introduces the concept of determinants, including their definition, calculation, and properties. It explains the importance of determinants in matrix theory and their applications.
-
Transpose, Minors, and Cofactors of a Matrix
MA-6This topic covers the concepts of transpose, minors, and cofactors of a matrix, including their definitions, calculations, and properties. It explains their relationships and applications.
-
Properties of Determinants
MA-7This topic explains the various properties of determinants, including the multiplication property, addition property, and scalar multiplication property. It highlights their importance in matrix theory.
-
Singular and Non-Singular Matrices
MA-8This topic defines and explains the concepts of singular and non-singular matrices, including their properties and characteristics. It highlights their importance in matrix theory and applications.
-
Adjoint and Inverse of Matrices
MA-9This topic covers the concepts of adjoint and inverse of matrices, including their definitions, calculations, and properties. It explains their relationships and applications.
Working with Tablespaces and Data Files, Creating and adding tablespace and datafiles, Managing Control Files, Online Redo Logs and Archive logs; Multiplexing online redo logs and control files, database archiving.
Assigning Quotas to Users, Applying the Principle of Least Privilege, Creating and Assigning Profiles, Administering User Authentication Methods, Managing Oracle Database Users, Privileges, and Roles.
Understanding the Multitenant Architecture, Pluggable Architecture; Creating CDB; Creating Pluggable Databases (PDBs) within a CDB; Manage CDBs and PDBs, Backup and Duplicate, Manage Security in Multitenant databases
Key Topics
-
Nature of Internship
CO-1The internship work should be relevant to the field of computer science and information technology, with a minimum duration of 180 hours or ten weeks.
-
Phases of Internship
CO-2The internship evaluation consists of three phases: Proposal Submission, Mid-Term Submission, and Final Submission.
-
Provision of Supervision
CO-3A regular faculty member of the college is assigned as a supervisor to supervise the students throughout the internship period.
-
Provision of Mentorship
CO-4A regular employee of the intern providing organization is assigned as a mentor to guide the students throughout the internship period.
-
Evaluation Scheme
CO-5The evaluation scheme consists of Proposal Defense, Midterm, and Final Defense, with a total of 200 marks.
-
Report Contents
CO-6The internship report should contain prescribed content flow, including introduction, problem statement, objectives, and references.
-
Citation and Referencing
CO-7The citation and referencing standard should be APA referencing standard, with proper citation and referencing in the document.
-
Report Format Standards
CO-8The report format standards include page number, page size and margin, paragraph style, text font, section headings, figures and tables.
-
Final Report Binding and Submission
CO-9The final report should be submitted in three copies, with a golden embracing and black binding, to the Dean Office, Exam Section, Institute of Science and Technology, Tribhuvan University.
-
Programmable Array Logic (PAL)
CO-10A type of digital integrated circuit that can be programmed to perform a specific digital function, similar to PLA but with some differences.
Backup and Recovery Concepts, Database backup, restoration and recovery, defining a backup and recovery strategy, Backup and Recovery option; Data Dump; User-Managed Backup and Recovery; Configuring RMAN; RMAN Backups, Restore and Recovery, Perform CDB and PDB flashback.
Introduction to the Scheduler, Access Rights, Scheduler Components and Workflow, create a Job, Job Classes, Use Time Based, Event-Based Schedules, Create an Event-Based Schedule.