Masters of Computer Applications:Data Base Administration

Thapar University
In Patiala

Price on request
Compare this course with other similar courses
See all

Important information

  • Master
  • Patiala
  • Duration:
    3 Years

Important information

Where and when

Starts Location
On request
Thapar University P.O Box 32, 147004, Punjab, India
See map

Frequent Asked Questions

· Requirements

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.

Course programme

Semester I

Discrete Mathematical Structures
Elements of Electronics Engineering
Problem Solving and Programming in C
Operating Systems
Computer Organization and Architecture

Semester II

Data Structures
Fundamental of Microprocessors and Interfacing
Object Oriented Programming using c++ and Java
System Analysis and Design
Statistics and Combinatorics

Semester III

Software Engineering
Data Base Management System
Design and Analysis of Algorithms
Operations Research
Computer Networks

Semester IV

Advanced Java and Network Programming
Computer Graphics and Multimedia
ERP and Tools
Minor Project

Semester V

Information and Network Security
Software Project Management
Net Framework and C# Programming

Semester VI

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.

Compare this course with other similar courses
See all