3 credit/unit hours – Three hours of lecture weekly; one term

This course is designed to give the database administrator (DBA) a firm foundation in basic administrative tasks and provide the necessary knowledge and skills to set up, maintain, and troubleshoot a relational database. Students learn to use an administration tool to startup and shutdown a database, create a database, manage file and database storage, and manage users and their privileges. In addition, students learn to organize the database and to move data into and between databases under different environments. Hands-on practices help to reinforce key concepts.

Learning Objectives

Upon completion of this course the student will be able to:

  • Manage database files;
  • Manage tablespaces, segments, extents, and blocks;
  • Manage users, privileges, and resources;
  • Start up and shut down an instance and database;
  • Use National Language Support Features (NLSF); and
  • Demonstrate appropriate and ethical behavior and good work habits

Main Topics

1.0 Database Management Systems (DBMS) installation
2.0 Database Administration (DBA) tools
3.0 DBMS account management
4.0 DBMS performance tuning
5.0 PL/SQL programming
6.0 Internet functionality
7.0 Syntax references