Database Administration & Management Course outline - University of Sargodha

Course Title: Database Administration & Management

Course Code: CS-3441

Course Structure: Lectures: 3/Labs: 0

Credit Hours: 3

Prerequisites: CMP-3450 (Database Systems)

Course Objectives:

•                     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.

Course Syllabus:

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.Processes.Managing Oracle Instances.Startup and
Shutdown Database.Managing Files.Creating Database and Data dictionary.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.Server Side Configuration.Client Side Configuration. Usage and Configuration of
Oracle Shared Server. Backup and Recovery. Sizing Shared Pool, Sizing Buffer Cache, I/O
Issues. Tuning Rollback Segments. Tuning Shared Servers, Types of Locks, Block Efficiency,
Storage hierarchy, Avoiding Dynamic allocation, Statistics, PCTFREE and PCTUSED,
Monitoring Index Usage.

Course Outline:

1.      Installation; SQL* Plus; Oracle Enterprise Manager; DBA Tools. Oracle Architectural
Components: Oracle Server; Oracle Instance.

2.      Physical Structure; SGA; Shared Pool; Library Cache; Data Dictionary Cache; Large
Pool; User Process; Server Process; Background Processes.

3.      Managing an Oracle Instance: Parameter File; Creating SPFILE; Oracle Managed Files;
Startup and Shutdown Database; Alert Log File; Background Trace File; User Trace File.

4.       Creating Database and Data dictionary.

5.      Managing Control Files and Redo Log Files.

6.      Managing Tablespaces, Operations with Tablespaces.

7.      Data File Management, Segments, Block.

8.      Managing Undo Data, Undo Data Statistics: Managing Tables and Users:

9.      Indexes Management, Maintaining Data Integrity, Constraints. Managing Privileges.

10. Basic Oracle Net Architecture: Types of Networks, Oracle Net Services, Oracle Shared
Server, Connection Manager, Oracle Net Connections.

11.  Server Side Configuration: The Listener Process; Configuring Listener, Sessions,
Creating and Managing Listener.

12.  Client Side Configuration: Host Naming Method, Local Naming Method, Net Assistant,
Configurations. Usage and Configuration of Oracle Shared Server.

13.  Backup and Recovery, Instance and Media Recovery, Configuration of Archive log
mode, User Managed Complete Recovery, Loading Data into Database, Tuning Tools,
Sizing Shared Pool, Sizing Buffer Cache, I/O Issues.

14.  Tuning Rollback Segments, Latches, Rollback Segment Tuning Shared Servers, Types of
Locks, Block Efficiency, Storage hierarchy, Avoiding Dynamic allocation, Statistics,
PCTFREE and PCTUSED, Monitoring Index Usage.

Textbook(s):

•         Oracle Database 11g DBA Handbook by Bob Bryla and Kevin Loney, McGraw-Hill
Osborne Media; 1^st Edition (December 6, 2007). ISBN-10: 0071496637

•         Database Administration: The Complete Guide to DBA Practices and Procedures
by Craig S. Mullins, Addison-Wesley Professional; 2^nd Edition (October 21, 2012).
ISBN-10: 0321822943

Reference Material:

•                     Database Systems: A Practical Approach to Design, Implementation and
Management by Thomas M. Connolly and Carolyn E. Begg, Addison-Wesley; 5^th
Edition (2009). ISBN-10: 0321523067

•                     Oracle Database 11g The Complete Reference by Kevin Loney, McGraw-Hill
Osborne Media; 1^st Edition (2008). ISBN-10: 0071598758

•                     Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle
Press) by Rich Niemiec, McGraw-Hill Osborne Media; 1^st Edition (2012). ISBN-10:
0071780262

•         Online Material URL http://otn.oracle.com

Note: This content is obtained from official documents of University of Sargodha and applied on BS Computer Science for Main Campus, Sub Campuses, and Affiliated Colleges.