B.E. Computer Science & Engineering:Database System Administration
Bachelor
In Patiala
Description
-
Type
Bachelor
-
Location
Patiala
-
Duration
4 Years
Facilities
Location
Start date
Start date
Reviews
Course programme
First Year: Semester I
Mathematics I
Engineering graphics
Computer Programming
Physics
Solid Mechanics
Communication Skill
First Year: Semester-II
Mathematics II
Manufacturing Process
Chemistry
Electrical and Electronic Science
Thermodynamics
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
Microprocessors
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
Project
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.
B.E. Computer Science & Engineering:Database System Administration