Masters of Computer Applications:Data Base AdministrationThapar University
Price on request
Frequent Asked Questions
Recognised Bachelors degree of minimum 3 years duration in any discipline with Mathematics at least at 10+2 school level and has also qualified in the Entrance Test to be conducted by the University.OR Recognised Bachelor's Degree of minimum 3 years duration in any discipline with Mathematics as one of the subjects and has also qualified in the Entrance Test to be conducted by the University.
Discrete Mathematical Structures
Elements of Electronics Engineering
Problem Solving and Programming in C
Computer Organization and Architecture
Fundamental of Microprocessors and Interfacing
Object Oriented Programming using c++ and Java
System Analysis and Design
Statistics and Combinatorics
Data Base Management System
Design and Analysis of Algorithms
Advanced Java and Network Programming
Computer Graphics and Multimedia
ERP and Tools
Information and Network Security
Software Project Management
Net Framework and C# Programming
System Development Project
Data Base Administration
Introduction: Describe the basic concepts of a relational database, Know core database administrator tasks
Installing Oracle Database 10g Software ,Create an Oracle Database, Database interfaces: Use structured query language (SQL), Use Procedural Language/Structured Query Language (PL/SQL), Use Java, Use the Oracle C++ Call Interface (OCCI) ,Controlling the database: Start and stop the agent, Start and stop the enterprise manager database console , Start and stop the listener, Startup and shutdown the database
Storage Structures management ,Administering users: Create and manage database user accounts, Create and manage roles, Grant and revoke privileges ,Managing Schema Objects: Create and modify tables, Define constraints, View the attributes of a table, View the contents of a table, Create indexes and views ,Managing Data: Manipulating data through SQL, Using Import, Using Export, Using SQL Loader.
PL/SQL: Identify PL/SQL objects, Understand triggers and triggering events, Identify configuration options that affect PL/SQL performance
Oracle Database Security: Apply the principal of least privilege, Manage default user accounts, Implement standard password security features and Audit database activity.
Oracle Net Services: Understand Oracle Net concepts, Use Oracle Net Manager to create and configure listeners, Use the listener control utility to control the Oracle Net Listener, Use the Oracle Net Manager to configure client and middle-tier connection, Use TNSPING to test Oracle Net connectivity
Performance Monitoring and Proactive Maintenance: Troubleshoot invalid and unusable objects, Gather optimizer statistics, View performance metrics, React to performance issues, Set warning and critical alert thresholds, Collect , Undo Management: Monitor and administer undo, Configure undo retention, and Guarantee undo retention, Use the undo advisor ,Monitoring and Resolving Lock Conflicts: Types of locks, Detect and resolve lock conflicts, Manage deadlocks
Backup and Recovery Concepts: Describe the basics of database backup, restore and recovery, List the types of failure that may occur in an Oracle Database, Database backups: Create consistent database backups, Back your database up without shutting it down, Create incremental backups, Automate database backups, Monitor the flash recovery area,
Database Recovery: Recover from loss of a control file, Recover from loss of a redo log file, Recover from loss of a data file.
Laboratory Work: Laboratory work will be based on Oracle Installation, managing oracle Instance/ Database, database Storage structure, Schema Objects, and Oracle Net Services. Also practicals will be undertaken on user administration, security, SQL and utilities, Proactive Database and implementation of database recovery.