Masters of Computer Applications:Data Base Administration

Master

In Patiala

Price on request

Description

  • Type

    Master

  • Location

    Patiala

  • Duration

    3 Years

Facilities

Location

Start date

Patiala (Punjab)
See map
Thapar University P.O Box 32, 147004

Start date

On request

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

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.

Masters of Computer Applications:Data Base Administration

Price on request