B.E. Computer Science & Engineering:Database System Administration

Thapar University
In Patiala

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

Important information

  • Bachelor
  • Patiala
  • Duration:
    4 Years

Important information

Where and when

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

Course programme

First Year: Semester I

Mathematics I
Engineering graphics
Computer Programming
Solid Mechanics
Communication Skill

First Year: Semester-II

Mathematics II
Manufacturing Process
Electrical and Electronic Science
Organizational Behavior

Second Year- Semester - I

Measurement Science and Techniques
Optimization Techniques
Semiconductor Devices
Data Structures
Discrete Mathematical Structures
Digital Electronic Circuits
Human Values, Ethics and IPR

Second Year- Semester – II

Numerical and Statistical Methods
Electrical Engineering Materials
Computer System Architecture
Principles of Programming Languages
Analysis and Design of Information Systems
Operating Systems
Environmental Studies

Third Year- Semester – I

Object Oriented Programming
Theory of Computation
Computer Networks
Data Base Management Systems
Software Engineering
Summer Training

Third Year- Semester – II

Total Quality Management
Algorithm Analysis and Design
Software Project Management
Internet and Web Technologies

Fourth Year- Semester – I

Engineering Economics
System Software
Compiler Construction
Computer Graphics
Artificial Intelligence

Fourth Year- Semester – II

Project Semester
Industrial Training(6 weeks)

Database System Administration

DBA Fundamentals-I: Oracle overview and Architecture, Installing and managing oracle, creating a database and data dictionary, control and redo log files, Managing Table spaces and data files, Managing tables, indexes, and constraints, Managing users and security.

DBA Fundamentals �II: Basic Oracle net architecture - basic net server side configuration, basic net client-side configuration, usage and configuration of Oracle shared server architecture. Backup and Recovery, Transporting data between databases - export and import utility, Loading data into database-SQL*loader, database performance tuning.

Laboratory work: (With reference to Oracle latest version)

Installing Oracle through universal oracle installer, Starting up and shutting down Oracle instance, Creating, altering, dropping - database, tablespace, data files, control files, redo log files, Creating, altering dropping- users, profiles, roles, Granting and revoking system privileges and roles, Auditing the database, Querying the information through data dictionary about database, control file, redo log files, data files, tablespace, users, roles, profiles, indexes, constraint, tables, Configuring oracle net on the server, Configuring oracle net for the client, Configuring the shared server option, Configuring the database archiving mode, Graphically administering the database through Oracle enterprise manager, Oracle recovery manager(RMAN) overview and configuration, Working of Export utility, Working of Import utility, Usage of sql*loader to load data.

Compare this course with other similar courses
See all