Course Introduction:

Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such asOracle, IBM DB2 and Microsoft SQL Server need ongoing management. As such, corporations that use DBMS software often hire specializedinformation technology personnel called Database administrators or DBAs. In Database Administration Course students gain a comprehensive overview of all the skills necessary to become database administrators. In addition to practicing existing recovery, backup and network plans, they develop their own. They gain hands-on experience practicing security procedures and using administrative tools.

Course Prerequistes: CMP-3440 (Database Systems)

Credit Hours: 3(3+0)

Course Learning Outcomes:

• Make Students fully understand the concepts and technical issues of Database Administration.
• Make Students to have good understanding of internal functionality of Database Management System and can Administrator Huge Database implemented in a DBMS.
• They Should Perform Database Administration tasks i.e. Backup and Recovery and Performance Tuning of Databases.

Textbooks:

1. Oracle Database 11g DBA Handbook by Bob Bryla and Kevin Loney, McGraw-Hill Osborne Media; 1st Edition. ISBN-10: 0071496637
2. Database Administration: The Complete Guide to DBA Practices and Procedures by Craig S. Mullins, Addison-Wesley Professional; 2nd Edition. ISBN-10: 0321822943

Assessment Criteria:

Sessional Marks: 20 Marks

                        Quiz 05 marks

                        Assignment 01 05 marks

                        Assignment 02 10 marks

Mid Semester Exam: 30 Marks

Final Semester Exam: 50 Marks

Course Contents:

Following contents will be covered in this course

• Installation; SQL* Plus; Oracle Enterprise Manager; DBA Tools. Oracle Architectural Components: Oracle Server; Oracle Instance.
• Physical Structure; SGA; Shared Pool; Library Cache; Data Dictionary Cache; Large Pool; User Process; Server Process; Background Processes.
• Managing an Oracle Instance: Parameter File; Creating SPFILE; Oracle Managed Files;
• Startup and Shutdown Database; Alert Log File; Background Trace File; User Trace File.
• Creating Database and Data dictionary.
• Managing Control Files and Redo Log Files.
• Managing Tablespaces, Operations with Tablespaces.
• Data File Management, Segments, Block.
• Managing Undo Data, Undo Data Statistics: Managing Tables and Users:
• Indexes Management, Maintaining Data Integrity, Constraints. Managing Privileges.
• Basic Oracle Net Architecture: Types of Networks, Oracle Net Services, Oracle Shared Server, Connection Manager, Oracle Net Connections.
• Server-Side Configuration: The Listener Process; Configuring Listener, Sessions, Creating and Managing Listener.
• Client-Side Configuration: Host Naming Method, Local Naming Method, Net Assistant, Configurations. Usage and Configuration of Oracle Shared Server.
• Backup and Recovery, Instance and Media Recovery, Configuration of Archive log mode, User Managed Complete Recovery

Time Table:

MSc IT 4th (Monday: 12:30-2:00pm) (Thursday: 11:00-12:30pm)